A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report exporting different data from what is on the report



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2010, 02:31 PM posted to microsoft.public.access.reports
SK
external usenet poster
 
Posts: 88
Default 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  
Old April 29th, 2010, 07:02 PM posted to microsoft.public.access.reports
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.