Apr 8 2011, 01:41 PM
I have a form which has a text box on it. when I enter data in the field and hit the enter button, a new table is created which populates a report.
However, the report should pop up but it does not.
This is the code that I am using to run the report.
DoCmd.OpenReport "SingleTrace", acViewNormal, , , acWindowNormal
Is there a way to show the report over the form?
Apr 8 2011, 02:04 PM
Not sure I understand what your db is doing well enough to offer suggestions yet ...
How do you know that the report is not opening ... what happens if you check the TaskBar? There's always a chance that the "new table" you mention is on top of the report.
By the way, are we talking about the same thing? "A new table" isn't needed to generate a report.
Apr 8 2011, 02:14 PM
The program goes out and brings back data from a client in the form of a csv file.
The data is imported into a table which is used to populate a report.
I want the report to show on the screen. I can pull the report up with the use of the navigation bar. My goal is to get it to show on the screen over the form that calls it.
Apr 8 2011, 06:30 PM
We're not there. To help, we need to know more about what you can see.
What program "goes out and brings back data", and where does it bring it from?
Were you aware that you do NOT need to have a table to feed a report. In fact, its much more common in Access to use a query to return the records you want to see, then use that query as the source to feed the report.
1. Have you tried setting the Report to "Pop-Up"? (if a "Pop-Up" is suitable for your requirement)
2. Have you tried DoCmd.SelectObject statement to make the Report the ActiveDataObject (in lieu of the Form that calls the Report)?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here