The report looks good and works fine. However, when I try
to print the report it once again asks me for the queue
information. This is annoying.
I would like to use a macro to just run the report and

I had a query ("qry_student_mks") which had many
calculated fields including one named "Student_rank" for
calculation students rank/positions within their class
according to average marks. It used Dlookup to do this but

Is there a way to specify how much a control can grow? For
example I have a comment field that I want to appear in a
report but if there are more than x characters, print only
that many followed by ... Thanks for the help.

I am exporting a report to adobe acrobat to turn them
into PDF files so we can email them to clients.
My question is; Can I name this exported report
automatically instead of the default name being the

I am using Access 2000.
I created an address label.  The label is 2 columns wide
and 3 long on an 8-1/2 x 11" sheet of paper.  We want to
print the address labels by calling up a telephone

Hi
can anyone help with securing the database so that the
users cannot access the background data. All I want them
to be able to do is use the the forms

I have a report with three subreports on it.  All of them
run off queries with
a 'Form.frmPrintDialogueBox.txtBeginningDate'
and 'Form.frmPrintDialogueBox.txtEndingDate'to give them

I have an Access 2003 database with names and addresses,
dates etc...  I have form letters as template files that
were written in Microsoft Word and saved as temp01.doc
files.  I want to be able to run query using Access

I want to send a report as an attachment to an e-mail
using the above method.  However, I want the report to be
attached to the e-mail in both RTF ans SNP format.  At
the moment I can have one or the other, not both.  Help

can anyone tell me how to reduce the size of an access
database?
we've created one here and it only contains approximately
400 observations, but does have a lot of reasonably

I need to create a report using something like the
crosstab query except I am using A2K .adp and there is no
cross tab query. I need a report with columns similar to
an excel page.

Im making report in Microsoft Access 2000. Im using a
control("Microsoft Rich Textbox 6.0 (SP4)").
Problem:
I can see the control in design mode, but when I make a

I have some users running an Access 2002 runtime app.  
When they try and print reports, they default to Letter &
manual tray.  The user tries to reset to A4 & Auto but
the settings are lost each time the report is opened.

What's wrong with this expression?  It looks fine to me, and it
definitely has the same number of '(' and ')' characters, yet Access
tells me it has an extra ')'.
IIf ( IsNull ( [Types] ) , Null , "[" & [Types] & "]" )

I have a report that displays a list of Sites and
associated information for each site.  I want to add a
drop down list box to the report that lists all of the
sites.  What I want the list box to do is filter the