D
diofan56
Hi all!
I have Access 2003 (Office Professional) on a PC running under XP
Professional. I have some simple queries that are normally run once per
shift. These queries do not contain any VBA code. They access only one
table. These queries have the following conditions:
Date Date()
Issue Type “Event Logâ€
Supervisor Supervisor’s name
Employee Sorted Ascending
QC Tech QC Tech’s name
There is a Memo field in the table. This Memo field is used in the queries.
Sometimes these Memo fields contain more than 255 characters of text.
Because of this we send these queries to the supervisors in Rich Text Format
so that they can see all of the data.
When the queries are run the results are sent to the shift supervisors via
Lotus Notes. We go through the following steps:
Run the query, go to the File menu, select the Send To option, select the
Mail Recipient (As Attachment…), and select Rich Text format. Lotus Notes
opens up with the attachment but here is where the problem appears. When we
send to one particular supervisor the attachment is not in Rich Text format;
it is in Excel format. When it is in Excel format there is nothing but
garbage (formatting, etc.) in the first cell of the spreadsheet. When we
send a similar query to another supervisor the attachment is in Rich Text
Format as it should be.
I have gone so far as to delete the non-working queries, get out of Access,
get back in to Access, and create new queries but this same problem appears
immediately.
The queries have been checked many times to make sure they are the same with
the exception of the supervisor’s and QC Tech’s names.
One last thing…A change was made to the table that these queries access.
This change was the addition of 4 text fields of 255 characters each. This
change has been removed. It is at this point that the Rich Text format
problems arose.
I have no idea why this is happening or how to resolve the situation. Any
help is greatly appreciated!
Dave
I have Access 2003 (Office Professional) on a PC running under XP
Professional. I have some simple queries that are normally run once per
shift. These queries do not contain any VBA code. They access only one
table. These queries have the following conditions:
Date Date()
Issue Type “Event Logâ€
Supervisor Supervisor’s name
Employee Sorted Ascending
QC Tech QC Tech’s name
There is a Memo field in the table. This Memo field is used in the queries.
Sometimes these Memo fields contain more than 255 characters of text.
Because of this we send these queries to the supervisors in Rich Text Format
so that they can see all of the data.
When the queries are run the results are sent to the shift supervisors via
Lotus Notes. We go through the following steps:
Run the query, go to the File menu, select the Send To option, select the
Mail Recipient (As Attachment…), and select Rich Text format. Lotus Notes
opens up with the attachment but here is where the problem appears. When we
send to one particular supervisor the attachment is not in Rich Text format;
it is in Excel format. When it is in Excel format there is nothing but
garbage (formatting, etc.) in the first cell of the spreadsheet. When we
send a similar query to another supervisor the attachment is in Rich Text
Format as it should be.
I have gone so far as to delete the non-working queries, get out of Access,
get back in to Access, and create new queries but this same problem appears
immediately.
The queries have been checked many times to make sure they are the same with
the exception of the supervisor’s and QC Tech’s names.
One last thing…A change was made to the table that these queries access.
This change was the addition of 4 text fields of 255 characters each. This
change has been removed. It is at this point that the Rich Text format
problems arose.
I have no idea why this is happening or how to resolve the situation. Any
help is greatly appreciated!
Dave