I am looking to have an entry field where numbers will be scanned in via a
barcode scanner, and when the number is scanned into the field, an onUpdate
event will launch, updating a table.  Is there a way this field can retain
the focus and not have it move to another field?  That ...

I am looking to update a record in a table, but before the update is done, I
want to check the record to make sure certain criteria are met before it
updates.  Is my only option using a DLookup?  I ask as this has some lag time
going through the process of looking up the record.

I have a vendor table.  I also have several forms.  The first Vendor form
contains the vendor name, address, etc.  The second vendor form contains
product information, and the third vendor form contains pricing information.  
All the information from all three forms is stored in ...

Hi,
I'm getting a "operation must use an updateable query" error on the
following Update  statement:
UPDATE tblBomMult LEFT JOIN qryWIP ON (tblBomMult.WONum = qryWIP.WONumber)

Does anyone know how to toggle between a form and a subform using the Option
Group.  I have a form, wherein when you select the option button "A" it
enables a control source on the subform to become active, and if you select
the other option "B" button a control source on the ...

My function is MyCalledFunction(Formname as string)
I have no idea how to requery the form within the function using Formname. I
assume it would be something like
Me!&Formname&.Form.Requery

It's a quick question, but what's the difference if I put a line of VBA
script in the Open handler or the Load handler?  I assume Load waits for all
the form stuff first?  So if I were to do something short - for instance
DoCmd.Close, I'm assuming it would show all the fields, ...

I'm trying use the Ledger template from Access 2003.
In the Accounts form, the "Account Balance" field contain the following
error: "#Name?". Why?
The control source is

Is it possible to move the focus on a form to nowhere? ie so the cursor isn't
in a textbox or on a button etc
Thanks!

I have a form based on a select criteria, and would like to limit the amount
of data available to the form.  The query returns multiple records, and I
need to limit the number returned based on the output of one of the fields, a
Ship To Address.  I need to pass only those records ...

I created a form bound to ADO recordset containing data from DB2
database, but the form is readonly. How can I make the form editable?
Steps:
--Create a form with 4 labels, and 4 text boxes: label 1, label2,

I have a button which opens an email and enters information from selected
fields in the body of the email and all works fine. My questions is this:
I want one of the fields to be "Bold". Also, I would like to change the
color as well.

Good morning to all,
I have a form that with a subform. The main form has Customer Information,
but the sub form has Specialist information.
There are Validation that need to be established so that there is no

I have a text field that could be “Approve”, Reject, and/or “Pending” in a
subform that was build with a table as the source. I have a main form that
talks to the subform and what I need is to set the control source for the
above text to show “Approve”, “Reject”, and Pending but ...

I have a form with a field called BSCB.
The fields data is a combination of 4 fields and data is displayd as follows.
H-A-1001-01
H-A-1001-02