Create 2 variables, StartDate, EndDate and store the values there:
StartDate = strOpenArgs(0)
EndDate = strOpenArgs(1)
...then the ControlSource of the TextBoxes on ruour report will be =StartDate and =EndDate respectively.
Create 2 variables, StartDate, EndDate and store the values there:
StartDate = strOpenArgs(0)
EndDate = strOpenArgs(1)
...then the ControlSource of the TextBoxes on ruour report will be =StartDate and =EndDate respectively.
It is still trying to turn Start Date into a column name, because I get the same error saying 'StartDate' is not a valid column name.
Did you Dim the two variables at the top of the code module for the Report?
I'll check back in when I get back from my appointment. I'll be gone for several hours, sorry.
Well I was debugging the code in VBA I put in some breakpoints and it is jumping over the if and going to the else. I put a msgBox in the else to check if it was working and it executed my else msgbox.
So possibly if I can figure out why it is jumping my if. I can fix it and maybe that should solve it.
So the Report is not seeing any OpenArgs?
Correct, or at least from my debugging that seems to be the case. Since it hits the if clause and then jumps to the else and executes the MsgBox within the else.
Any chance you can post your db?
Here you go. If you have questions about what I am trying to do you can ask. Right now I am just trying to get the Monthly Sales summary to run with the dates on it, because then I should be able to copy paste that code into the other reports.
What form is opening this report? It would have been nice to be warned this was an ADP.
Sorry I always forget to warn people about it being an ADP. The flow of forms is a follows: HomeScreen->ReportExport->SalesDates->Monthly Sales Summary(Report)
I can't run the ADP but see what this does.
I get this error. Error 2467: The expresstion you entered refers to an object that is closed or doesn't exist.
I'm sort of stuck then since I can't do any real testing with your system, sorry.
Thanks for your help though.