Friends,
How can one update an Inventory Quan field on a DataSheet or Tabular Form?
Thank you,
Paul

I have a large table of data with a form built onto it. To filter the data I
have another form with a combobox that is populated from a SQL statement
(which is a concatentation of three keyword fields in the underlying table).
After selecting an option in the combobox and ...

I want to fill a listbox with items in a continuous form. Each row has
different data. I thought about storing the data in the table in the form of
a value list, such as:
"John Smith";"123 Main Street"

I have tried many times but still can't get it.
I have 2 tables, named tblrisk with a field name Program_Area and another
table named tblrisktypeArea with fields name Program_Area and Risk_Type.
The form name is shortmenuerisk, with controlname of cborisk, it is a combo

When my tabbed Form opens its position does not show the Tabs unless I scroll
up, is there a way to have the Form open scrolled to the top automatically?
Any help would be greatly appreciated

Good Morning all,
I am finishing up a 2003 application and I have come across a small
problem...
I decided to add an autonumber primary key to one of my tables and for

I use the vbYesNo in a msgbox, like:
MsgBox ("Are you sure ?", vbYesNo, "Confirm")
How do i retrieve the answer then? What is the reference name to retrieve
the selected yes or no?

Why can't I just disable a button within a form, in the same way I do with
other controls like text boxes?
I use the command:
Command129.Enabled = False

1) How I made form (data entry) all fields mandatory to fill the data. If any
one  try to pass any field without filling the data, cursor not move to next
data field till not filled previous fields. Even clicking by mouse in next
field.

I execute the following code that will append data into 2 related tables:
Private Sub Command129_Click()
       DoCmd.OpenQuery "Quotation-to-Invoice Query", , acAdd
       DoCmd.OpenQuery "Quotation-To-Invoice(Details)", , acAdd

I am making a billing program in access 2000.  I have formulas in my forms to
calculate prices.  I have my base prices in a table and sum them with a
query.  I can't make the query work in my formula.

Hi, everyone!
I know this may sound silly,but is it possible to assign to start a
countdown. I have a form where I have a box whee when user enters a
time the counter starts. but I want a button to start the counter

Generally OE is ok but when I first sync it is taking 30 seconds or so for
the dialogue that tells you what is going on to populate with all the tasks
it has to do.
My Outlook Express folder (under local settings) is now over 1GB in size and

How can I make a field inside a form, or better from within the table
directly to read the last Invoice number from the table and assign a default
value an increment of 1 to the last value?
The current field type is text masked with the INV____ prefix but inside the

I call an append query from a form using code:
DoCmd.OpenQuery "Quotation-to-Invoice Query", , acAdd
How can I skip the 2 confirmation dialogs that follow? (only for this
execution, not globally)