Recent content by esymmonds

Hi Thanks for this!! I'll have a look over it and see what I can do with it!! I'm not bad with VBA, it's something I duck in and out of when I need it! Emma :)

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

Thanks for your help Raskew and Rich, I still couldn't get it working but I have now in a long winded way, but it works so I'm happy!! What I've done is put an invisable text box on my form and every time the code goes through the loop it puts the next date into the text box and then run an...

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 changed it back after i wrote the first post i just thought id see if string instead of date changed anything. it didn't so i changed it back. should have said. I'm sooo confused :mad: Emma

Thanks Rich and Pat, Have tried out your ideas but it didn't work :( I have found tho that if i put today or tomorows date in (28/02/2004, 29/02/2004) it stores it fine, but anything after 01/03/2004 is stored mm/dd/yy. Also if i put arrival today and departure 03/03/2004 it puts the first...

I understand what your saying and I know about changing the date format but it's actually inserting the date into the table in the format mm/dd/yy when it's correct in the code (stepped thru to check the values). I've also tried changing the date to a string but it still does the same. It did...

Hello AshikHusein, I'm still learning VBA but a solution could be to use an append/update query onload to set the feild to X and another one onexit that sets it to null. Emma

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

Hello All, I have got my system to not make double bookings now! Thought I'd just post how I've done it in case there's anyone else who has problems with it. There may be an easier way to do this but I'm not that bothered cos mine works ;) First of all I have a query that finds which rooms...

Hi Andy, What I've done is taken out the bits you need and put them in a database. If you open form.avail put todays date and tommorows date in and select double. then open the query. You'll see that it gives you, among others, rooms 108 and 109 but if you check the booking table those rooms...

but a record only appears in the booking table if it's booked. It's working so far as not returning booked rooms but it returns a room with a booking date out of the criteria that is actually booked. I need to put that if the room is booked inside the criteria then no other instances can be...

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

erm.... where's your e-mail address? Emma

sorry, It's a list box (oops!) The list box displays the query results. I'm sick, been trying to get this working all day! Can I e-mail you a copy? Emma