Prev: Report with buttons to open forms
Next: Subreport link by Date field
From: sk on 27 Apr 2010 09:31
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.
From: Daryl S on 29 Apr 2010 14:02
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.
 | 
Pages: 1
Prev: Report with buttons to open forms
Next: Subreport link by Date field