Query vs Form vs Report Question

[JNana]

I posted this yesterday. However, I do not see it in the newsgroup, so I am
reposting.



What is the best way to handle the following:

I have a query that needs to be sent via email. The emailed FORM transmits
via email as desired with the exception of:
1. I need to total some of the fields.
Can this be done?
2. I need to lock some of the fields so that there is no data entry
allowed on the transmitted form.
Can this be done?
3. I need to have background color on the unlocked fields.
Can this be done?

The emailed REPORT can handle all of the above with the exception of
emailing, which of course will not work for me since the format is lost.

The emailed QUERY emails in good format and is much easier to handle.
However, I have the same questions as listed under the form above. My query
has 50 fields - and yes, it must be on one query without any subqueries so
that when I email this it transmits as an excel worksheet.

Thanks in advance,
JR

 

[Guest]

Get a tool like PDF995 to turn the reports into PDF files. Then email them.
The PDF files can't readily be modified and will keep all the formatting of
the reports.

BTW: The next version of Office will have PDF creation capabilities built in
.... if you can wait a year or so for it to come out.

 

[Guest]

Hi JR,

I posted this yesterday. However, I do not see it in the newsgroup, so I am
reposting.

Try using this link. Here, you should see that your original posting
received a couple of answers, including one by Pat Hartman (MVP):

http://groups.google.com/group/micr...read/fc160dcac2c87109/0f74cb46b7a3dfa8?lnk=st


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Hi Jerry,

There's no need to wait for the next version of Access to have the
capability of outputting reports to PDF. You can use Stephen Leban's
ReportToPDF:

http://www.lebans.com/reporttopdf.htm


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________