ADP - Adding Date Information used in a Filter to a Report Header.

[RuralGuy]

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.

[BigCat]

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.

[RuralGuy]

Did you Dim the two variables at the top of the code module for the Report?

[RuralGuy]

I'll check back in when I get back from my appointment. I'll be gone for several hours, sorry.

[BigCat]

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.

[RuralGuy]

So the Report is not seeing any OpenArgs?

[BigCat]

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.

[RuralGuy]

Any chance you can post your db?

[BigCat]

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.

[RuralGuy]

What form is opening this report? It would have been nice to be warned this was an ADP.

[BigCat]

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)

[RuralGuy]

I can't run the ADP but see what this does.

[BigCat]

I get this error. Error 2467: The expresstion you entered refers to an object that is closed or doesn't exist.

[RuralGuy]

I'm sort of stuck then since I can't do any real testing with your system, sorry.

[BigCat]

Thanks for your help though.