I have a subform datasheet view connected to a form by an ID.  The tab order
is set correctly in the subform and works 90% of the time when people tab
from one form into another.  However, occasionally once they arrive in the
subform datasheet it skips a couple fields and they ...

Hi, I Have a form with text box with 2 field - fDesc; aDesc.  fdesc is the
bound column and displays in the text box.  But I also want to store aDesc in
the table.  How can I also have the second column bound?

For some reason that I just can't explain, a text box on a form associated
with a single primary key field behaves unexpectedly when I do a
filter-by-form.  Instead of listing all of the records from the source table
as choices in combo box mode, I only see "Is Null" and "Is Not ...

I have a Form with several sub forms.  Sometimes when you move the mouse
across the screen or such it blinks.  We have tried it out on several
computers and it does the same thing.  Any Idea?

I have a form that I would like to simplify. This form is created to allow
for data to be entered for inventory checks. There are two feilds that very
often repeat. The name of the store and the date of the report. Is there a
simple yet elegant way of facilitating this?

I've allowed users to access my database and there has been a problem with
one of these users not being able to save after entering information into a
form.  The error message says "Can't save design changes..." when the user
hasn't altered the design.  The issue seemed to ...

I am trying to test for no data, so I can display an appropriate message when
there is no data.  Also, I am currently getting an error, because I am trying
to set a variable, but there is no data.

I am trying to create a form in which the operator will enter a date that
will be the default date for several sub-reports.  I was instructed to creat
an unbound form and add a command button.  I was also instructed to code the
click event on this command button to, "Me ...

I am really new to VBA,
currently I have one form were I create meetings, than another one were the
individual is inputted(frmAttendance = qryAttendan = tblAttend)  I am opening
a form(frmTravel = qryTravel = tblTravel) from  a button with in

Hi every body! I'm from Vietnam and know only a little English.
I'm studing MS Access 2002 and there's a problem that I can't understand:
The option "Dynaset (Inconsistent Update)" of the Recordset Type property is
described that different to the option "Dynaset"; but I think they ...

in an unbound subform, i have a combobox which is populated (in
subform.onopen)  via the following statement where tCtl is the correct
combobox control.
               Set tCtl.Recordset = currentData.Users.Clone

Access 03
I have a sales quote form with line item numbers. I have a macro that
increments the item number (using dcount) when a new item is added. It's tied
to the After Insert event of the form.

I have a datasheet view sub form with a dropdown for inventory transaction
type and a dropdown for inventory item.  Both the transaction type ID and
Inventory Item ID are required in the tblInvTransactions.  The problem I am
having is capturing the error that occurs when the user ...

I have a datasheet that is a subform, I can use the conditional format to
change the format based on the value, however I cannot just shade the
background color of the fields.  I want to shade the fields that will be
locked to the users.  When I am in design view I click on the ...

I have (2) back-end SQL Server tables that I've linked to a front-end ACCESS
db.  One table contains Overall (summarized) data associated with a Product
Order, and the other contains Specific data associated with the order.  Both
tables have Customer Number as a Primary Key -- ...