stlinae
asked on
allowing for user to enter dates in a pass-through qry
The setup: using QuickBooks and it's 'qODBC' driver, from a pass-through qry, I need to pull a stored procedure query. The SP queries usually have a parameter [DateMacro] that can use things like 'todays date' 'All' of 'This year to Date' amongst others. However, you can also use [DateFrom] and [DateTo] parameter. The catch is that you MUST have the dates entered before you can run the qry.
I need reports that can have changing dates, therefore need the [DateFrom] and [DateTo] parameter. I understand how to use a form for the dates, but that doesn't work when doing this. I have to have the dates in the query before the query can be 'touched' I have included a sample of a different forums suggestion, and while I understand the idea, I don't get the process. The incorporation of VBA into Access is something I just don't have a grip on.
Please let me know if I need to clarify anything.
Module1.txt
I need reports that can have changing dates, therefore need the [DateFrom] and [DateTo] parameter. I understand how to use a form for the dates, but that doesn't work when doing this. I have to have the dates in the query before the query can be 'touched' I have included a sample of a different forums suggestion, and while I understand the idea, I don't get the process. The incorporation of VBA into Access is something I just don't have a grip on.
Please let me know if I need to clarify anything.
Module1.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER