Emailing an access report as an excel sheet

[Tumby]

My problem is- For the past two years it has been able to send an access report (via email) as an excel s/sheet.

The last three new accounts will not allow this. I can see nothing wrong with the account set ups.

I have tried all different ways of exporting the report to access with no luck.

The latest way I tried was to put in a command button to do this- this I think showed up the problem.

'Access can't find the name "l" you entered in the expression' - where do I look for the expression? What I can't understand is that it works fine with all other customer reports except the last three new ones.

Where do I look for the expression in question?

Any help would be gratefully received.

 

[dkinley]

When you get the error, does it not prompt you to debug? If so, that should highlight the line of code (behind the command button) that is throwing the error. If it isn't then probably remarking out the error handling of the command button will display the prompt.

-dK