I have created my report based on the crosstab query, with the layout is as
follows:
Prj No.    Prj. name              Euro,       Rp          usd   Yen.
xxxxx      xxxxxxxxxxx           2000        500       1000    5000

I have created a purchase order form for use in my office.  What I need is to
create a command button that will open and print a report of just the current
record.  I can get the command button to open a print preview of the report,
but it brings up the entire report (ALL ...

Is there a way to print out a copy of the design view of the report  - i.e.
with the field names listed where the data would usually be printed out?

I have seen the response to this questions but I need more help. I am learing
Access on my own and need an explanation on how to do this exactly, please
help
Example:

I have a computer asset database for which I am trying to sort by the last
three digits in an alphanumeric text field.  I am trying to do this within a
report that already sorts by department name.
Here's what I'm looking for.  The computer names (for which I am trying to

A subreport that shows fine on the Access2003 machines does not show on the
Access2007 machine.
I had an identical issue resolved when I had some vb in the main report's
OnFormat that should have been in the subreport's OnFormat.  When I changed

I'm having a hard time printing ONE copy of a report w/data.  My scenario is:
I am filling out a form, I save the data to my table, and then I wish to
print ONE copy of that data onto a report that I have formatted into a memo.  
What I'm trying to do is provide a hardcopy to a ...

I have a report to print a Purchase Order. The report have a subreport
(OrderDetails). I would like to print this report with a maximum of 15
records(lines) per page. For example, if i have an order with 30 items i
would like the report to print 15 items in page 1 and the resting 15 ...

I have a report that gives a value in the report footer. The value needs to
be in euros, numbers and words. I can calculate the numbers okay, but as far
as I am aware there is no function to convert numbers into words in Dutch.
Thus, I need to have a fill-in field for the value ...

I'm really tired of the Access 2003 Report Wizard designs.  Does anyone know
of any new, creative, innovative designs out there that I can download?  
Already searched Microsoft's site.  I'm working on a Project database.

I am trying to have a report that when the preview is closed (On Close) the
report prints.  Ideally, it would be nice if it prompted the user on close if
they wanted to print (bonus points for that).  I would be most appreciative
of some code that I can "borrow" to get this done.

Hi;
In my reort I have one text box which is autamatically calculated if the
present date is greater than or equal to specified that. I used the following
expression in control source to calculate it

I am trying to print a second report when the user prints the first using
Access 2000. I tried using OnPrint() but it prints when the second report
even when the first report is only previewed. According to the microsoft
description of the OnPrint event this is correct as OnPrint ...

Could someone help me with a problem.
We are trying to cut down on Faxing and printing our Job Sheets to our Techs
so I setup a report that has an option to output each job to PDF and then
email it, but it is so slow, about 2 mins per PDF.

I have a report with a company logo at the top as an OLE Unbound Object. The
properties are set to visible, but when the report is printed the Logo does
not print, all other items on the report print as normal
any suggestions