I have a tblInvoice with 2 fields: invTransactionCode and invPaymentCode.  I
built frmInvoice from tblInvoice.
Subsequently I renamed these 2 fields in tblInvoice.  The new names are:
invTransactionType and invPaymentType.

Is there any way to zoom in on a report or form when in design mode?  I have
looked around 'View' and 'Window' on the tool bar, but could not find
anything.  It would be nice to be able to zoom in when working on the little
details of a large form or report.

I have a order details subform opened as a datasheet.  The first column is
the product id that I display using a combo box that actually displays the
product name.  The next column is the product size column.  I only want this
to display the sizes available for the product that ...

I have a main form frmAdmin with a subform "sContacts" on it.  I need to
change the subform object to bring in another subform name 'sfrmProfile"  But
it's not changing.  I'm not linking anything because I'm bringing in ALL the
records.  

My SQL code keeps stopping it says that it wants a semi-colon at the
end.  I tried but I can't seem to find where it wants it!
Could it be the [UsageDate] = Date().  I need the usage date to equal
the current date.

Access 2002
The problem I am about to describe can be worked around (via On Error
Goto), but I would still like to understand why this does not work or
how I can do I what want to do without resorting to On Error Goto

What is the way of switching the keyboard layout from English to, lets say,
Russian, when a certain field in the data entry form gets the focus? My
operators sometimes
complain that they have to switch the layout manually in order to be able to

I have a form with radio buttons on it and one subform at the bottom of the
form.  I want to be able to click on the radio button and have the subform
source object change to populate with a new subform.
For example, if I click on MAResults radio button the subform populates with

I'm working with a subform on a main form, and was wondering if there is a
HasData property (or something similar) that I can use in the code to figure
out if the subform has any records or not.  The subform is a bound form,
linked to the main form. I can use Count, but if there ...

I have a list of department using combo dropdown.  I want to add "All
Departments" on top of few departments on the list.  When I want to select
"All Departments", it will give me all departments.  If I want to select one
department, then give me one department on the report.

A2002, I have a subform (continuous form) with parent child link to main
form.  I have a button on the subform to delete the selected subform record.  
When user clicks button, it asks to confirm deletion (default access message,
not my doing).

using the code below as rowsource - is there a way to control the order of
selections with ORDERBY in this SQL?
I tried creating a sorted query for the cbo but still didn't change the
order in the cbo?

I'm using Access 2K and W2K.
I have a combo box (Combo0) that allows the selection of a last name. I
have the following lines of code to see if it is empty when I process
the data:

I have the following lines as part of an Event Procedure:
   Forms![Physician].AllowDeletions = False
   stDocName = "Physician"
   stLinkCriteria = "[Physician_ID]=" & "'" &

I have a form that displays all the Purchase Orders for a given Vendor.  
Among the columns are VendorNum and PONum.  I would like to be able to have
the user select one of the records, then click a button that would pull up
the details of the PO on the selected record.  Is ...