Is there a way to have Access convert and save an access report as a PDF
file in a specific folder using VBA code.
The PC has Acrobat 6 Professional.
I have spent so much time on this problem it's causing me so much grief - so

How can I get a report sent as the messagel "body" of the email.  I need to
send copies of reports embedded as the email, which may bave pictures in the
report image.  Even using the send as attachment function doesnt work
properly, often displaying the report image incorrectly.

Using Access 2000 database project with Sql Server 2000 Back end.
Issue:
A drafting firm has 60 boxes divided into 36 - 2" squares - 6 across and 6
down for storing architectural / engineering plans.  The Access Project

I have a forum with 2 subforms containing information about external
examiners, fees, expenses and the course and college they are responsible for.
There are a number of standard letters which have to be sent out to each
external, for example confirmation that the exam report has ...

Currently utilizing 100 Access 97 reports but must upgrade application to
Access 2002.  Will Access 97 reports run in Access 2002 or is a conversion
required?  If so, is a converter available?  Thanks.

I have created a report based on a query.
To get the sums I need for the report my query contains
parameters for the date ie Between [Start Date] And [End
Date]

if there's somebody out there who can help me in solving
the following problem, I'd be very grateful.
I need to open a report from several forms and, once the
report is closed to go back to the calling form. The form

I can't view any print dialog boxes within Access 2003
(print preview, print, etc) so therefore can't print at
all.  Other applications print fine (word, excell, etc).
Does anyone have a solution/suggestion?

I am using Access 2003 and would like to filter records within a group.  I
have a series of part numbers that may have a new record added daily.  I want
to run a report that lists only the most recent record for each part number.

I have a drop down list and want those items in the drop down to be
associated with certain values. How can I achieve this? For example: drop
down = walk to store - time value would be 1.5 hours.

I use the following code to export my report to RTF format
report, so the user can open it in word.
DoCmd.OutputTo acOutputReport, "rptAll",
acFormatRTF, "Report.rtf", False

Using access 2000 how do I get alternate line shading in a report?

After I print to a network printer (I'm running Windows
XP Pro) I can no longer open any of my reports in Access
2003.  They won't open in Design or Print Preview. Any
suggestions?

in an access report, when a field has no data in it, how do you "slide the
fields up"?  For instance, if an address has the company, name, address,
city, state, zip for fields, and the contact has no "company", how do you
keep the printout from looking like this:

I'm running Access2002 and have this:
=IIf([Test1 Complete Date]=Null,"Test1 Incomplete","x")
in the Control Source of a Text Box.  Why won't it work?  
It's pulling from a Query that has all my tests'