Best Approach???

[dynamictiger]

I am not sure whether to post this in Queries or in Modules.

My application has a situation where we generate an email or printed quote (for faxing). The quote includes stock, and labour. Some of the stock may have an extended description that is sales blurb type information.

I can return this information in a query.

The question then becomes how do I transfer this information to my code for inclusion in the email or fax?

I could use dlookup to return the appropriate fields.

Or could I use an ADO construct (of some sort) to return fields instead?

Or some approach I have not considered.

 

[AndyP]

Access has a control to email reports. You could create a report based on your query and select the command button from the object toolbox. Under "Report Operations" there is the option "Mail Report". I use this in an application, it gives you the option to email the report as an Excel spreadsheet. HTML, text file etc. You can add the code to create the query to the button also before the SendObject action is carried out.

Does this answer your question??

Cheers,

AndyP

 

[dynamictiger]

Thanks, but this has to be done in code. A report won't work for this at all.