I have a report in access 2003 that needs to be sent via email in excel form.
I have 244 accounts that require this and most work fine except for a few.
Trying to find the cause I noticed that in the table that controls the report, on the accounts that will not email in excel format, there are two dates which are not showing in the cells until the cell is clicked, but they are showing on the Input Form.
I have tried deleting and re-entering these dates, setting the properties to 'short date' but nothing will solve this problem.
Any ideas what I can try next? I've spent 2 days on this already.
Any help would be welcome.
I have 244 accounts that require this and most work fine except for a few.
Trying to find the cause I noticed that in the table that controls the report, on the accounts that will not email in excel format, there are two dates which are not showing in the cells until the cell is clicked, but they are showing on the Input Form.
I have tried deleting and re-entering these dates, setting the properties to 'short date' but nothing will solve this problem.
Any ideas what I can try next? I've spent 2 days on this already.
Any help would be welcome.
