Search results

Hi! I'm hoping someone can help me! The company that I work for produce monthly staff sheets that are sent to Managers to verify thier staff and grades. We currently do this by importing the data from our payroll system and the running a macro called SVLMerge. This macro then groups together...

I have a booking system and it all works fantastically apart from the dates being stored in the form dd/mm/yyyy, except if the date is before the 13th, then it is stored mm/dd/yy. I want all dates stored as dd/mm/yyyy but i have just read in the help files that any dates in SQL code must be usa...

I have a booking system that was working all nicely. It done everything it was supposed to. Today I was demonstrating the system I made (for my degree) to my supervisor and it suddenly dosent work! Was not amused! I've figured out that something is changing the format of the date (from british...

I'm trying to make a query that will show what rooms in my hotel are available between 2 dates. The 2 tables that will be used are: Booking book_room ------ foriegn key, room_no date1 -------- Date of booking, each night of booking has a record custno Room room_no smoking -------- if room...

Hi, I'm making a booking system and I have a form that allows you to select an existing customer from a combo box. The combo box uses a query to search for a name that is entered. So you double click on the customer that you would like to book the room for. This opens another form that shows...

I'm trying to make a query that will show what rooms in my hotel are available between 2 dates. The 2 tables that will be used are: Booking book_room ------ foriegn key, room_no date1 -------- Date of booking, each night of booking has a record custno Room room_no smoking...

Hi, Still trying to make my booking system! I'm trying to make a loop that will check in a guest for each booking night of stay. (each booked night has 1 record and all it needs to do is give checkin a true value). Now the query part isn't working. It works as an access query but not when i...

Cant run my Insert statement in VBA, Please help me Hello, Can someone help me? I've been working on this for a while now and my original question is here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=60929 Basicaly I'm making a booking system and i needed some code...

Booking System Dates- Help Needed Hi, I was wondering if anyone can help me. I am a student doing a degree. for a project i need to make a booking sytem for a hotel. I've got the system working fine, apart from when I book more than one night. The feilds in the booking system are: customer...