I have been able to set up a query and associated report that will print
only for the person specified by user.
However, is it possible that a search can be made across several non-related
tables for that same name?  

Is their a way to convert SNP files to PDF files?
Thanks

Is there a routine or method by which an Access report can be written to an
Adobe Acrobat (via Snapshot formatting)?  I'm familiar with the way to use
DoCmd.OutputTo to send to the various standard formats; any way to do this
with Acrobat (assuming the Writer/Instiller is installed) ...

Is there a way, through VBA or some setting in Access, to force the landscape
and margin settings for a report?  I have set the page setup to Landscape,
however, the report keeps going back to Portrait  when it is on a network
printer with several people using it.

I am not real good at the chart wizard in access. I want to make a chart
that creates a bar chart for occurances by the Day of the week. However
there are 7 days in a week and the chart wizard says I can only use 6
fields. How can I get by that?

Two reports, to display invoices in English and Japanese. The only difference
is the "boiler plate" labels. However one subreport displays the data and the
other doesn't. They both feed from the same query and the data sheet view
shows the right information. Is this some strange ...

Hi, hope you can help
One of my users has an error msg "Invalid ordinal" when trying to export the
results of a report from preview to Word.  I thought about re-installing
Office, but we have XP and don't have admin rights to our own machines, so it

I have created a report with multiple text boxes
Some times, words are missing the end character
have adjusted margins / removed borders etc all to no avail
anyone having the same problem

sHi! i wanted to create a report (with report fields) with a bar chart based
on the parameters entered.
the report that i did so far worked, but when i added the bar chart (that
uses the same query as the report fields) ..did not work. i cant seem to

I have controls in my report based on calculations and need to get the total
of the line items in the report footer. I don't seem to be able to refer to a
calculated control using the SUM function as I would normally, i.e.
=SUM([Calculated Field]) is there a way of doing this or ...

I'm about to go NUTS! All I want to do is to add photos, that are listed by
their direectory path as a text file (for example,
c:/database/images/image1.jpg) in a query.
NOTHING I try will add them. I've looked in every Access book I own and

How do I force groups to print on different pages?

   I have a report based on a query that contains a text box
(textboxA)which displays a numeric value (1 - 3). What I would like to do is
place another  text box (textboxB) on the report that gives a  text string
dependant on the value of the numeric valuein textboxA.

Can I print the design view of a report?
Right now I am making a screen shot and pasting it ito a Word Doc.

This is probably a fairly simple question.  I have a word processing
operator worklog in Access 2002.  The worklog is simple - the date, the
operator's name, job number, and a list of tasks, each of which has a
checkbox (Yes/No datatype).