Results 1 to 2 of 2

Thread: msgbox in Macro

  1. #1
    Join Date
    Jan 2003

    Question Unanswered: msgbox in Macro

    I've a query which returns count. I need to run this query in a macro and have a msgbox popup after this query to show me the count.
    Something like,

    ' You have 100 records'.

    I don't know how to set the expression in msgbox to query results.

    please do help.

  2. #2
    Join Date
    Oct 2002
    Leicester - UK
    easiest way of do this is not to, the best way is in vb

    msgbox "you have " & x & "records"

    where x is the value if you need more help, just let me know
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts