D
DFASWood
I had a user show me this. Reports in Access 2007 sometimes attach the wrong
file name to the report when the send as pdf is used. I tested it and had
the same issue. The underlying report is fine but the file name is the first
one used. (I'm not using code to send, just the Office button. ) I even
compacted and repaired the database hoping to clear an internal variable.
The attachment was still named incorrectly. I can export to PDF with the
correct file names. The problem seems to occur only on the send email.
This is not a critical error; it is just twilight zone stuff.
I did copy one report to make the other (the one with the wrong name) but I
changed the underlying tables. If I can fix the report so it emails with the
correct file name I can save a few phone calls.
file name to the report when the send as pdf is used. I tested it and had
the same issue. The underlying report is fine but the file name is the first
one used. (I'm not using code to send, just the Office button. ) I even
compacted and repaired the database hoping to clear an internal variable.
The attachment was still named incorrectly. I can export to PDF with the
correct file names. The problem seems to occur only on the send email.
This is not a critical error; it is just twilight zone stuff.
I did copy one report to make the other (the one with the wrong name) but I
changed the underlying tables. If I can fix the report so it emails with the
correct file name I can save a few phone calls.