Activate Macro based on Query Results

=?Utf-8?B?VG9kZA==?=

Guest

Posts: n/a

22nd May 2006

I have a query that has a field that calculates how many days until the next
contact needs to be made. What I would like is when the main form opens the
query will run in the background and if the number of days on the query field
is 0 or less a popup box will appear that says contact needs to be made today
or something to that affect. I do not want the query to appear, all this
needs to be transparent to the user. Thanks for any help!

« How to use Regular Expressions of VBScript? | Simple Expression table »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Run query based on results of previous query using code	H J	Microsoft Access Queries	4	8th Jun 2009 10:51 PM
Report based on query depending on results of the query	Ang	Microsoft Access Reports	2	29th Sep 2008 07:52 AM
Activate Macro based on Query Results	=?Utf-8?B?VG9kZA==?=	Microsoft Access	14	22nd May 2006 06:25 PM
Return query results based on results of another field query	=?Utf-8?B?TGVuMTQ5?=	Microsoft Access Getting Started	1	9th Jun 2005 07:39 PM
Activate macro based on cell value	LB79	Microsoft Excel Misc	1	7th Sep 2004 04:39 PM