Recent content by andybeanland

Cheers PH, your pretty good at this SQL stuff eh! ;-) Really appreciate the help, thanks. Andy

That seems to be the problem - the form is taking the date in the format dd/mm/yyyy. I tried putting them in as mm/dd/yyyy and it works ok. Whats the best way to get round this problem? Thanks

Sorry, that didn't work - I got a bit excited and typed the wrong dates. Unfortunately, I know there are 6 records and it's still returning 0 results. Any ideas?

That works, thanks! I knew it was something simple!

Hello, I'm having a problem with a simple query. In the Query Builder in Access I have created a query to count the number of records between certain dates. SELECT Count([tbl_PacksSent].[DayCare]) AS NoOfDayCarePacks FROM tbl_PacksSent WHERE ((([tbl_PacksSent].[DayCare])=-1) And...

Roy, you genius! Thanks - I've been tearing my hair out with that for ages! Right, I'm off to make some more stupid errors! Cheers

I just thought I would add that the SQL was created using the Query design view in Access - would this be a problem?

Okay, I've done a debug.print of the SQL statement and this it what it gave me - all on one line - which I copied into the query builder in access and ran. No problems - and it returned what I was expecting....But when I'm still having the same problem when opening the recordset! SELECT...

I've checked the SQL in Access and it runs without problems but I couldn't get the Debug.Print to display anything in the immediate pane. Can you suggest a different way of opening a recordset that I can try? Thanks Andy

Hello, I've got an really annoying problem - I copied and pasted some code for opening a recordset but it won't work now - I can't find the problem. This is what I've got: <code> Dim conDatabase As ADODB.Connection Dim rs As ADODB.Recordset Set conDatabase = CurrentProject.Connection Set...

Yes, thats correct.

Hello, I'm trying to do a simple count of who is attending on a register. What I would like to do is count the number of children attending (its for a nursery) for each day of the week and then create a report to show this. So far I've only managed to do several seperate counts which are like...

Thanks, that works perfectly!

Thanks PH, but I just tried the code you pasted in and it just gives me a "Compile Error. Expected: List seperator or )" I've checked the correct number of brackets etc, but wasn't really sure what this was doing so didn't know what to check...

Hello, I've got a problem with a date field that I just can't resolve - hopefully you'll be able to help. I have a series of text boxes (10 in total) which are for inserting start and end times for children attending a nursery for the different days of the week. The children don't attend every...