Search results for query: *

Thanks PHV thats sorted it and a really big thank you to MajP. It works like a charm, and is just what I was after. Thanks

sorry for the delay in getting back to you. I've added the second section of code and I don't seem to be able to get it to run now. I get the following error now. The message is instant as soon as I try to do anything and it stops all code running even the stuff that was working before...

sorry I missed the 0 = 0 I assumed the =0 was the value if Null Thanks for the explaination it makes sense now.

Thanks for that Majp I had managed to sort it out. see my post above yours.

sorted it now. I had changed the format of the date to match the format in my table, dd-mm-yyyy, I put it back to the way you posted it yyyy-mm-dd and it started working. Thats what I deserved for fiddling. LOL Just before I found that I was looking what the NZ did and noticed on MS...

thanks for the second half of the solution. I've just spotted it now. :D I've been sending MsgBox 's up everywhere all night. LOL It is returning NULL everytime. even for the records I've filled in. I've checked the table names and field names and it seems ok. I'm still working through...

Ok I've now got that working now. I had a few problems to overcome which took me a while to suss out. I firstly had to learn how your code worked. LOL The first problem I had I finally tracked down to the DLookup in the checkValue Function. The criteria for the DLookup was looking for...

Many thanks for that, I'll get the page built and test out what you've provided so far, it make its so much easy to learn when you can see how things knit together.

I'm not really happy with anything much in access sort of learning it as I'm doing it at the moment, but I'm definitely willing to try and learn anything. I never thought about reading back in the weeks data, I like that idea. I'll have a look for the other thread you mentioned. but any...

I have a problem I'm looking to solve, and not sure about the best way to do it. I have a booking system where the user will be booking in up to 10 lessons per customer each week. I'm trying to come up with a method of making this easy in one step. rather than making the user manually input...

Superb, I knew there had to be a really easy way to do it but I was damned if I could find it in the help files. Many Thanks.

I'm new to access and databases and I'm trying to design a database where the user will be able to book a customer in for a lesson. A lesson will be either morning or afternoon, monday to friday. I originally had a M:N relationship between tblCustomer and tblLesson (as many customers could...

Is it possible in a query to convert the date to the day as text. I've used Day: Weekday([dteSessionDate]) to get the value 1-7 but ideally I would like it to display Sunday - Saturday Thanks