Recent content by stevesana

Hi Bastanu, yes I did this.. thank you

Hi Vlad, yes I did but still to no avail. I decided to use make table queries to pull all the records from Sales Invoices and Sales Invoice Details table from the SQL server and run this query from the front-end as a temporary solution. Messy but a temporary fix

@ CJ_London Have you tried a shorter date range to reduce the number of records to be returned? The query will only return a year of records using the "Between [Forms]![Reports]![StartDate] And [Forms]![Reports]![EndDate]" Have you taken a look at the data in sql server to see if there are...

@ isladogs I've tried the datepicker method but unfortunately is still stalling with OBDC timeout

This makes perfect sense with the Between #01/01/1998# And #16/03/2020# and and the entire query runs on it rather than in Access memory for a large part

Thanks I have a date picker form in this accounts program. I'll give it a try

Correct Access 2003 doesn't have a date picker but I can try your suggestion and code for a date picker to use as an input

zeroaccess unfortunately no, I wrote this accounts program 15 years ago with Access 2000 and to be honest our company is still on Access 2003. So it's been 15 years since I last messed around with Access and I can see the date picker is a new feature in the format property

Thank you

zeroaccess did your method unfortunately this didn't work either. But what I did was copy the 2 tables, Sales Invoices and Sales Invoices Details tables and made them local to my Frontend instead of a linking to the SQL Server. I ran the query again with the criteria "Between...

jdraw I have tried changing the format but still to no avail.. thanks

Thank you

Thank you

For 15 years this query had no issues until now.. How would you put a # delimiter around this as the criteria " Between [Forms]![Reports]![StartDate] And [Forms]![Reports]![EndDate] "

I thought this as well but I have 25 queries running behind this form and it's only this query that's giving me the problem. I'm guessing it has something to do with how the query is reading the dates. It works perfect if I call the criteria from the query as Between #01/01/1998# And...