Search results

  1. H

    Automatically Load Switchboard

    I'm aiming for the switchboard in my database to automatically open whenever a user loads up the database, can this be done with a macro or is there another method best suited to it?
  2. H

    Confirmation Report

    I've a form that adds records to a table. What I'm aiming to do is return a report with the information that was just entered (this is a booking system so this would be a confirmation report), but have no idea how to go about it. Even a button on the form that produces this report, or just go...
  3. H

    Prevent Duplicate Entries

    I've set up a booking system and am looking to stop the system recording double bookings. I've 3 fields, RoomID, Date and Time that need to be searched, however I can't just simply set the properties to No Duplicates (as this would mean a booking cannot be made on the same day at 9:00 and 12:00...
  4. H

    Preventing Duplicate Records Being Entered (Double Bookings)

    I have a form which allows the user to book rooms. On this form, there are the following fields: BookingID: (Autonumber) RoomID: Text box Time:Text Box Date: Text Box Class: Text Box Teacher: Text Box The form adds this information to the Booking table. What I'm looking to do is prevent the...
  5. H

    Search Query Using A Form

    Hi, I'm trying to run a query through a form, that takes several parameters and then checks to see if any rooms are booked at a certain time and date, that satisfy these parameters. On the form there is : Room - combo box Time - text box Date - text box Computers - check box Data projectos -...
  6. H

    Search multiple fields

    I've a system set up that books teaching rooms for a University, with three tables (Room, RoomEquipment and Booking). I'm looking to set up a function that allows the user to search multiple attributes of the room to see if it is already booked. The fields on the form are: RoomID - Text box...
Back
Top Bottom