×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Sending report to email as a xcel file and incorrect information shows.

Sending report to email as a xcel file and incorrect information shows.

Sending report to email as a xcel file and incorrect information shows.

(OP)
In my DB I run code that loads a table. I have a Report that sends the data from the table. In VBA I am using DoCmd.SendObject to send the report as Excel to my users. It does not arrive the same. On Label is incorrect.

Troubleshooting by exporting the report from Print Preview to excel:

The issue: When I preview the report manually it shows 9 fields. The problem field is Labeled "End Date" in the preview and on the report in design view. The data portion of the field is formatted as a date and exports good. In print preview everything looks good. When I export to excel (or email as excel) the field label shows "Completion Status" instead of "End Date". The actual data part of the field shows the date correctly.

In the referenced table for the report there is NOT any field labeled "Completion Status". And the report in design view, does not have a label named Completion Status".

Do you have any ideas why this is happening? The data is good but the one label is not. There are 9 fields and all nine data-es look good and all labels except the one are good.
Also, with a report in Design View is there any way search for the offending label?

Thanks,

John

RE: Sending report to email as a xcel file and incorrect information shows.

(OP)
OK. I fixed this. I don't know why it was doing it but I created a new report using the same data from the same table. I ran the code to send it to me via email and everything looked good.
John

RE: Sending report to email as a xcel file and incorrect information shows.

Sounds like corruption... Compact/Repair sometimes helps..
Sometimes importing all objects to a new file helps...
Sometimes exporting with the undocumented SaveAsText and loading with loadfromtext can fix an object... generally also import everything else to a file and load it there.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close