macro conditions

N

nicole

I have a query that counts the number of books on a shelf and returns this one value. I would like to set up a macro that displays a message box ( stating the shelf is full) when the value the query returns = a given value ( this is my condition statement
is this possible or will i have to send the information to a report or query?
 
S

Steve Schapel

Nicole,

You could use something like this in the Condition of the MsgBox action
in your macro...
DLookup("[YourCount]","YourQuery")>=111
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Split form 0
Creating a Chart on form from selected data in query. 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Type Mismatch with Option Group 1
VBA Coding Help for Beginner 0
Word macro that can call cells out of Excel for a find and replace 0
Change Style to 'Keep with previous' instead of Keep with Next 1

Top