Office Software Thread, One for Access Users in Technical; I am running a query which pulls the start date and end date from unbound controls on a form. I ...
28th January 2011, 05:29 PM #1
One for Access Users
I am running a query which pulls the start date and end date from unbound controls on a form. I have a command button which opens the date input form but I need it to wait until I have entered the dates before running the query. I use the same date input form for different queries so I can't use the after update property of the date field. The best I have come up with so far is a continue button on the date form but this means a different button for each query. I would like to put something in the query's SQL which waits until the date form end date is not null but I haven't managed to come up with anything so far. Any suggestions would be welcome.
I am using Access 2003 if that makes a difference
IDG Tech News
By Bruce123 in forum Internet Related/Filtering/Firewall
Last Post: 6th January 2011, 10:06 PM
By link470 in forum Windows
Last Post: 5th December 2009, 12:50 AM
By jag2050 in forum Windows Server 2000/2003
Last Post: 1st October 2009, 12:43 PM
By danboid in forum Windows
Last Post: 12th November 2008, 01:17 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)