I would like to assign a field name to a variable when a user enters into the
field.  SO if the cursor enters a field named txtLName, I want to asign
"txtLName" to a variable.  Any assistance will be apreciated.

I have a check on a form that prompts the user with an error message if a
field called OrderTotal is higher than the customer's credit limit, called
CreditLimit.
However I don't want this check to apply if their status is proforma, how do

Basically,
I'm writing a database that records answers of different questions (staff
performance monitoring sessions, to be exact!)
I have 8 tables:

Hi....i have a check box on one of my forms. This form is for invoices.
And when an invoice has been completed, the user clicks the check box,it
inserts the completed date, and disbales all the controls associated with
adding any new orders to that invoice.  The problem i am having ...

Until recently I had only used Access to manage data for my personal use.
Thanks very much to the knowledge gained here I have successfully designed
my first multi-user Access application. It's almost too successful.
It's pretty simple, a backend with a single table that contains ...

I use one switchboard that has many levels (on button is for entering
the reports page, the other for opening forms etc.)
I would like to create another switchboard called Reports and whenever
I press the button for Reports, this switchboard would open. Is that

In access 2002 I get "invalid procedure call" from this microsoft code:
Const ForReading = 1, ForWriting = 2, ForAppending = 3
   Dim fs, f
   Set fs = CreateObject("Scripting.FileSystemObject")

I have a form with two option groups, a list box and a bunch of text boxes.  
I have two AfterUpdate event procedures - one populates the listbox based on
the option groups - opt_Date_AfterUpdate - and one finds the record you pick
on the listbox -lst_Deviation_AfterUpdate.  The ...

On my form, I have a tab control with two tabs and on the second, I'm trying
to refer to data thats stored on the first.
All I get is the error message 'Method or data member not found'. Where have
I gone wrong in this line of code ?

I have added a button on my form to do a spell check, with this code behind it:
DoCmd.RunCommand acCmdSpelling
The problem is this will only spell check the text boxes in the parent form.
I need the code behind the built-in toolbar 'abc' icon, which will spell

I have linked an Excel file to my application and it works well with DAO
recordset coding.  However, I'd like the user to be able to click a button
on a form and bring up Excel.  And, I'd like Excel to automatically display
a specific .xls file.  This code solves part of the problem ...

Hello everyone, Here's my problem:
I have a columnar subform, that's a child to a main Form. The subform is
based from a query that has certain criteria and the matches appear on my
subform. That all works like a charm, however here's where things get

1. Is there a way to set a detail text box control source
programmatically?
2. I have a table of Contacts with several fields for different phone
numbers, e.g. office phone, office fax, home phone, home fax, cell phone,

I have set the default AllowEdits property to No in the forms properties. I
then have a button that has the following line of code:
Forms!reqfrmRequests.AllowEdits = True
This line seems to work OK.

Does anyone have step by step on how to setup up user security using the
ULS Wizard?
I tried several times and it keeps giving me the error that "it experienced
an unexpected error and unable to create the security".