PC Review Forums Newsgroups Microsoft Word Microsoft Frontpage Running a query from a form

Reply

Running a query from a form

 
Thread Tools Rate Thread
Old 15-02-2006, 08:51 AM   #1
=?Utf-8?B?V29iYmxlcw==?=
Guest
 
Posts: n/a
Default Running a query from a form


Allen Browne saved my brain yesterday with his date validation query (see
"Booking out a Guest suite , avoiding double booking in Access" posted 14/02)
his query works without question. I now have a related question. If i input a
start date i need to check the start date is not part of an already booked
period. then assuming it isnt i then need to check the dates from that start
date till the date i enter next being the end date. If i must i can just
input both and check at the end but how do i send the dates to the query and
get either a ok or not ok result.
  Reply With Quote
Reply



Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off