Search results

Thanks Guys Using "Between date() and date() + timevalue("5:59:59")" was a great improvement. Seems to work a lot quicker too.

Hi everyone, Please see attached screenshot of my query problem. I have a query that looks at a table to get all values between midnight and 6:00am for the current date. The query works fine until the date changes to a single digit. I can change A: Format([DateAndTime],"dd/mm/yyyy") to A...

Thanks Paul My compiler returned an error at ....On Error ResumeerrHandler I changed it to ....On Error GoTo errHandler and it seems to work. Will this be Ok ? Also I found that the instruction MyAccessObject.usercontrol=true before exiting the routine is what I needed to keep Access...

G'Day I have a program that uses a vba routine to open a form in Access 2007. The operator can then enter dates into the form and print required information. However as soon as the form opens the routine ends and Access immediately shuts down before the operator can enter the dates. Is it...