Search results

Hi Wayne, Thanks for all your help, I've got it working now. The problem was that room_no wanted text and the room number was an integer so I just changed the feild type and it worked! Thanks again, your a genius! Emma

Have tried it again but I'm still getting the same error :( Emma

Hi Wayne, Will try that when i get home, although i didn't use those variable names in the proper booking system and it doesnt work in there. Also, I set date to now() so that I didn't have to keep typing it in! Just laziness really so I'll take that out! Is the syntax of my statement...

I will do, but that hasn't changed anything. Emma

Opps! OK, I've corrected that but I'm still getting: Run Time error 3464 Data type mismatch in criteria expression Emma

It's the update, I'm getting good at inserts now thanks to all your help! :) I tried explicitly declaring the feilds but i got less errors when i didn't so i took them out. Emma

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

Thank you sooooo much to everyone for all your help. I really really appreciate it. it works now yeah! Thanks again Emma xxx

still dosen't work, I'm going to fail.

well I've used bits of all the code you helpful lot have given me, and I've steped through the program and all the right values are in the right places when they should be, but it's still putting the date in the database as 30/12/1899, even though the date is changing properly throughout the...

I'ts kind of working using the above code except that the loop is not excecuting properly. It is only adding one record with the date 30/12/1899 which is the default date that all other dates are calculated from so there's something not quite right. There is a test copy at...

It's not really called form in the booking system, i'm just using 1 table and form in another database until I get the module working then I'll ammend it and put it in its rightful place. I used this code but I'm getting a syntax error in query expression '2' Emma

Oh Yes, well spotted! It still dosen't work tho, It's started asking me for the parameter value for bookdate, so i tried having it look at: BookDate = Forms!Form!date1.text But then it says you can't use the value if its not in focus. I can't have all the information and the button in focus...

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

Thank you, I will try that now! Emma

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