I want to have a text box that shows the starting date of employees who were
hired since 2001, but only "Before 2001" for those who came earlier.
I have used this in the control sourse of the form but it keeps coming up
with #Error

I have a report in a letter format.  It prints the date above the address.  I
am using the date() function.  It prints the Day before the Month Day, Year.
How do I print the Month Day, Year without printing the Day?
As always, thanks for your help.

Could someone please help? I am using the 'defaultprt.zip' tool
provided by Ken Getz to change the default printer via VBA code (code
below). My problem is that once the default printer has been changed,
Access 2003 still directs the report to the former default printer.

Report out of sequence
I have an auto number report which form is working properly, but the report
shows the last 4 entries first then start at 1.  I ran "compact and repair
data base" but did not work.

I have a contract report that has combination of label and bound text, plus
there are several bold characters which is not possible in access report. Is
there a way to overcome this?
SF

I have postal adresses that the input is as follow :
PO Box 770, Durban, 9000
Is there a way to change the format, to
PO Box 770

I've been watching with some interest the postings regarding sending an
Access report to PDF. What I need to do is similar, but instead of sending
the report to PDF, I siimply need to send it to a Word (RTF) document.
Theoretically, I could use an OutputTo Method, instead of the ...

I would like to add some kind of counter to keep track of how many
times a report is used. I work for a company that has a ton of reports
in MS Access, and only about 10% are used at one time...but no one will
confess as to which reports are important.

I'm trying to modify a set of reports that use lots and lots of subforms. The
one I'm concerned with has a single set of records going down the page - in
Design mode, it looks like:
[period]

I've done an extensive search for this, and found similar problems, but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate ID and Time
. There is no primary key.

I've taken over a project that has several reports presenting the same fields
based on different queries.  So, depending on the criteria, adifferent copy
of the report is used.  Is there a way to dynamically associate a record
source with a single report?

I have a report having 15 sub-reports and need to print each sub-report on
separate page. I’ve considered using the grouping feature, but MS Access
allows no more than 10 groups. Any other idea?
Also, does anyone have experience developing report having variable group

When I print a report it starts  printing at record 19 and gives a page # of
1.  How do I get it tostart at record 1?

I am working on a database that reviews and reports shipping performance
issues.  A report run via selected date range will show all orders that are
considered late, according to specific criteria.  A subreport will show the
percentage of late vs. on time.  The goal of course is ...

I am using the rather technique shown in:
The Knowledge Base Article ID : 95806
How to Skip Used Mailing Labels and Print Duplicates
Which works a treat.