|
-
Jul 11th, 2006, 10:07 AM
#1
Thread Starter
Member
[Resolved] Access VBA - Checking for entry on the fly
Im writing a booking system for a school room in Access, as the school wants it done in an office package!
I need to check wether a booking for the date, time and area has already been made one the three relevant fields have been filled. (areaID [number] , bookingDate [short date], timeID [number]) what ever i do seems to not work.
Ive tried a "SELECT INTO" then "SELECT COUNT" SQL statement but had no joy with that!
Any ideas?
Last edited by c03cg; Jul 18th, 2006 at 09:26 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|