Results 1 to 10 of 10

Thread: [Resolved] Access VBA - Checking for entry on the fly

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Nov 2004
    Posts
    48

    [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
  •  



Click Here to Expand Forum to Full Width