i work on access as my tool for lots reports:
when i made a form and create the birthdate and year area for input data,
the age get calculate fine: But: age dosnt show on my main table from which i
will make my reports: How i fix this? Age data its a must for reports i have

I have a report that OnClose the following code is set to run.  Its purpose
is to check to see if the field "Print" is checked or not.  If it is, I want
it unchecked.  The code works fine, but takes forever as it has 5000 plus
records to loop through and that number will only ...

I am an XP user with Access 2003.  I recently created a Macro for a
client that will run certain queries and create newly exported tables.
Everything works great, but I do not want the prompts that tell me I'm
about to delete a table, etc...  I've gone into Tools-->Options and

What is the easiest way to display the number of records in a report footer?
I tried using RecordsetClone.Count like I do in forms but apparently that is
not available to you in the report world.  I tried =Count([myIDfield]) and
got #Error.

I have a report which contains a subreport.  The subreport returns a
complete list of Career History information for all employees.
When the report opens, it only opens for a single Employee, and the
subreport opens containing correctly all the Career History for that

This really is quite annoying.
Have produced a report based on a query that is perfectly displayed in every
way on the print preview. However, when I press the print button, all that is
produced is a blank page. Can you help?

DoCmd.OpenReport stDocName, acPreview, , "[ORDERID] =
Forms![OrderForm].[ORDERID]"
On access 2003 only the orderid selected on the form shown on the
report. on access 2007, all the records shows on the report. it ignore

I display a recordon the screen and if the user wants to print the record,
there is a field I do not want to show on the printout (it's ok for the user
to see it but I don't want it passed around to others).
Is there some 'property' attached to the field that will allow it to be

Im currently in the process of moving a couple of databases over from
office2000 on win2k to office2003 on winXP. I've moved a couple with few
problems (mainly dao2535.tlb) but now I've been trying to move my IT
inventory db over and am having difficulties.

Howdy Folks,
I have an Access report and I would like to make certain records bold
based on their value. Here's my problem. If a record has a less than
sign in it (<), I want it to be left alone. Anything that doesn't have a

I'm really new to Access 2000 and would appreciate any help with a
problem I am facing.
I have created a form which displays Employee Details.  On this form I
have a button which launches a Report.

When i try to use the Sum(abs) in a report it works great on my system on the
network But on some when it prints some totals are correcr but the grand
total displays an #error in the field Other computers on same network works
ok Prints all totals with out an error message Grand ...

I have a query selecting account name, account #, # of deliveries, and time
of delivery.  I've built a report on this query as well.  However, I notice
on the report that the multiple account numbers and time of delivery (AM/PM)
do not display.  It appears that the report is ...

I have two tables with data. The first has all my employees with their info,
and the second has my computer hardware and one field that refers back to the
SSN on the employee table
I want to create a report that shows all my computer hardware with the

I'd like to print a page of Avery 5264 labels of the a single record.  Can
someone help me?  I have Access 2003.
Thanks in advance,
Ellen