I have a combo box on my form with the row source as: SELECT
tblEmployees.lngEmployeeID, tblEmployees.strFirstName FROM tblEmployees; to
choose which employee creates a new invoice.  After the form is "Continued"
(which updates the inventory table, customer table, etc.) it will ...

I'm doing some tent cards in Access.  I have the field set to display the
result of "=Trim([Name_First] & " " & [Name_Last])" and through the
properties window have set it to be centered horizontally.
How do I get it to center vertically as well?  In FileMaker Pro text has

Access 2003 running on XP Home with SP2 installed.
Regardless of what boxes I check during report wizard, or
what page orientation I set, the report always comes out
Portrait with the fields not adjusted to fit onto the

I have a problem with blank controls in a simple report. I have 3 controls
one underneath the other in the detail section for Address_1, Address_2, and
Address_3.
WHen there is no text in the Address_2 or Address_3 fields I want to salvage

I have a report where I have one group header and group footer. The group
footer consists of signature and title. The detail sections consists
LineNumber and Comments fields. When I run the report depending on the length
of data in the detail section, the signature and title ...

I have one line in the detail section of my report set to be able to grow as
needed. There is a line immediately below that line. If I put the two lines
one right under the other, if the first line "grows," the second line
overlaps it, writing both lines info on the same line. If ...

I am using A97 and I would like to be able to send reports directly to a fax.
My computer has the fax attached.  any ideas?
Thanks

When I request grouping in a report in access. Instead of print the value of
what is being grouped it looks like it is printing an index number. Any Ideas

IS there some reason why vba doesnt work? My code is
If Me.renupgrd <> "r" Then
   Me.txtrenupgrdas = "Upgraded to:"
   Me.txttitle = Me.mg & " Upgrade"

I have a report that prints duplicate pages for every record in the
recordset. I just want one page to print.

To make a report, a query is used. When trying to show the
report for 1 specific customernumber, i get a blank page,
and when trying to close it I get the message "the current
code will be set to interruption mode due to this action"

I have been attempting to create a report with sources from multiple
tables.  I have created a form to choose which project to base the
report on.  This form is linked to a query that has all of the fields
I would like in the report.  However, when I run the report, it does

This happens when there are multiple subgrants. A sample query output could
be described as:
 SubgrantId                 LineNumber     Comments                     Year
    x1                             1               Furnish document        

In access 2000 the reports run as they should.  The same report in 2003 just
hangs and have to close the program down.
What is going wrong?  How do I correct it?

Hi All: Trying to have a footer field that will only total top 2 values of
grouped data above. For example : I have a reprt that shows 2 people
grouped, and each person can have multiple scores: 21, 22, 25 etc. I want
its footer to add just the 22 & 25 for that person and the ...