Search results

Thanks, I knew it was done somehow, don't know why I thought it was macros :)

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?

Thanks, the report opens, only problem is there is no information on the report (the fields are blank). Presume this is something to do with the query? I've set it up as you suggested so I'm not sure where it is going wrong. I'm using a button with the function 'Add Record', so I can't use a...

I started another thread that might explain the problem a bit clearer (intended to delete this thread afterwards but couldn't find a function for it, if an admin wishes to then feel free), but thanks to everyone who has replied for the help :)

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...

Solved it, cheers. :)

I've tried a multiple field primary key and that doesn't seem to work. I can still double book a room without the system batting an eyelid. I can't set any of the fields to No Duplicates (as a room can be booked more than once, more than once on a particular date etc). Really not sure how to...

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...

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...

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 -...

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...