If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report exporting different data from what is on the report
I have a standard Access 2007 report (based on a query) in my database that
pulls information on a specific item. The report runs fine but when the user right clicks on the report and exports to Excel, they get the information for a different item. I had them delete the export file and try renaming it. Neither worked. The item they are getting information on is one that they exported prior. Now it is the only record that will export, regardless of what the report is showing. Help Please. |
#2
|
|||
|
|||
Report exporting different data from what is on the report
SK -
Since I have never seen this, I wonder if it is one of those user errors where we just forget something simple. Are you sure you are checking the correct export file (check the date/time stamp before opening it). It could be the user forgot to select the Excel file type from the Export dialog box, and it really exported a database object with the same name (but you are looking for Excel and opening the old one). Or maybe the subdirectory is wrong. Or there is a typo in the exported file name. Does this happen with all reports? Just this user? I don't have Access 2007, so I can't tell if there is something going on there - just looking at the normal things to try... -- Daryl S "sk" wrote: I have a standard Access 2007 report (based on a query) in my database that pulls information on a specific item. The report runs fine but when the user right clicks on the report and exports to Excel, they get the information for a different item. I had them delete the export file and try renaming it. Neither worked. The item they are getting information on is one that they exported prior. Now it is the only record that will export, regardless of what the report is showing. Help Please. |
Thread Tools | |
Display Modes | |
|
|