Data did not update in report

[Tom81]

I have a client that reported a problem with a report not having the correct data. The report is based on a table that is recreated in the OnOpen event, using a make table query.
When they ran the report it showed data from about a month ago. They then closed the report and reran it and this time the data was correct.
Any ideas why it would do this?

The code that recreates the table is this:

Private Sub Report_Open(Cancel As Integer)
On Error GoTo Err_NoTable
DoCmd.SetWarnings False
DoCmd.DeleteObject acTable, "Table Name"
DoCmd.OpenQuery "MakeTable Query Name"
DoCmd.SetWarnings True

Exit_Report_Open:
Exit Sub

Err_NoTable:
If ObjectExists(acTable, "Table Name&quot = False Then
DoCmd.OpenQuery "MakeTable Query Name"
End If
End Sub


Also this database is on a Terminal Services server and is accessed remotely through Terminal Services.
The main problem the client has is that they have no way of knowing if the data is correct or not.
They just happened to catch it this time on this report.
Tom

 

[dhookom]

I would create the table prior to ever opening the report. Is there a reason why you are attempting this in the On Open event in the report? Obviously, this is making the table too late for the report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Tom81]

The reason I am doing it in the On Open event is because the reports are being run from the switchboard.
I don't know of any way to make the table automatically before opening the report from the switchboard.
According to the Access Visual Basic help files the On Open event of a report takes place before the underlying query is run.
That is why I thought the way I am doing it should work and so far it has. This is the first time I have had this problem.
I guess if I have to I can create a form to preview/print the reports from to make sure the table gets created before the report is run.
Tom

 

[dhookom]

The switchboard in Access allows you to run code. The code could run your query and then open the report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Tom81]

Thank you! I'll try that and see if they have any more problems.
Tom

 

[danvlas]

Just a thought:

Why don't you turn the Make-Trouble query into a normal select one and base the report on that query?




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html