Parameters

[hholland]

I have a report that I am trying to edit however the date parameter will not stop popping up, so that I can edit the report. The report is linked to a crosstab query and the crosstab query is linked to a query with the date parameter. I have put the date parameter in the critiera in the query and in the menu under query/parameters. I have also put the date parameter in under the query/parameters in the crosstab query. The query and the crosstab query both run fine. I have also tried to re-create the report but I get an error message about "The microsoft jet database engine could not find the object ~sq_r(then the name of my report)". Can you please help me figure out how to fix this?

Thanks

 

[Philem]

What happens when you try to run the Crosstab Query? Copy/Paste the parameter question it is asking.

What happens when you try to run Query 3? Copy/Paste the parameter question it is asking.

What happens... you get the idea. Trace back your queries, making sure that they work. If the Crosstab fails, try Q3. If that fails, try Q2. Whichever one works, the DEPENDENT query has the problem. Meaning; if Q2 works, but Q3 doesn't the problem is in Q3.

If you can get the Crosstab query working, then your report needs to reference the parameter for the Crosstab query. So, in the report would be a textbox with a Control Source of

="Report Period From "  & [AS OF DATE]

The above assumes that the parameters listed above work as expected.

HTH
P

 

[hholland]

All the queries including the crosstab query work and have the same parameter pop up (AS OF DATE), which is correct. In my report I have a text box with =[AS OF DATE] in the control source. The AS OF DATE is my parameter. However I still cannot edit the existing report or create a new report.

 

[Philem]

At this point, the only 2 things I can suggest are: 1) Create a blank database, and import ALL objects into it. 2) Backup the db, and have Access CLEANLY reinstalled.

Other than that, I'm out of ideas at the moment. What Denis and I have suggested should have worked. Apologies.

P