I have create code to delete the record in the subform as follow:
Dim Msg, Style, Title, Help, Ctxt, Response, MyString
   Msg = "you are about to IRREVERSIBLY DELETE *ALL*INFORMATION CONCERNING
THIS MAIN EQUIPMENT FROM THE DATABASE!?"    ' Define message.

Hi guys, I'm updating an old report from Access 97. I have two fields which I
want to hide if the values are null or I want to display a certain way if
they contain data.
The code on the original Access 97 form applied to each text box is:

What is the best way to have a control print a certain color if certain
conditions are met.
Example if the field is less than zero or it is null I would like it to
print red.

I have previously put this to the group, but I think I was not able to
express well what I needed.
I have a columnar Report( but not a normal columnar report in a subform. The
subreport consists of aboout 14 data fields grouped together into one nice

I have create a database for equipment list with a unique equipment number.
some main equipment also has subequipments store in a different tables.
can anyone help me to create a report to include all the equipment and their
subequipment?

I have an application that I need to be able to print a report to a pdf file
or to a network printer in Access 2003.  The application does so in Access
2000 but in the newer version it doesn't change the default printer.
How do I do this in VB code?

We have a report with lab results that have to be sorted in ascending order.
The problem is that the results can look like 0.001 or 0.001U for example.
The result with the U has to come first, but obviously it doesn't cause
Access treats it as a larger number.  Any "easy" solutions. ...

I have a group header that shows the managers name and displays a summary of
the type of hours worked by the manager's employees, for example:
Manager|__|sick hours|__|vacation|__|Holiday|
-----------------------------------------------------------------------

Is it possible to insert a cover page into an Access report?
I have a 30 page report of songs listing various data. I'd like to insert a
cover page showing a list of the titles within that report. Sort of an
index. I tried dropping a subreport into the report header section an ...

We need to export some reports from Access to MS Word, but we are losing some
lines and boxes.  Is there a method to accomplish this (e.g., import to
Powerpoint and manipulate the file)?

When I got to print my report the secound record automatically prints on a
new page. How do I stop thus

I currently have a text box on a form that I have set to as a Memo to get
around the 255 max char problem. I am trying to get the text box to default
to a canned entry such as:
Name: XXXXX

I am trying to use the count function for a group of records in Access 2000.  
For example:
101
101

We generate a report offering 4 different sort options by option group.  The
sort options are listed identically in 2 option groups - 4 each - allowing 2
levels of sort.
I would like the result to display in a stepped format, the way the wizard

Access 2003 I have separate tables set up for different enrollment
specialists. I successfully created reports to total contacts, enrollments,
etc. How do I create a report to get totals from all the different
specialists to show totals for the whole department?