I have a table/form that holds my technician information (contact
information, skill set, certifications, tools, etc.).  I need a way
for them to list all the zip codes that they can cover.  I set up a
table/subform called "sub_Coverage".  I linked it to the techs ID

I have setup a button with an event procedure behind it.  I need to
edit the vba code so it will ask me which email address to use if
there is more than one email field filled.  The email fields to pick
from would be: serviceremail or serviceremail2

I need to import two excel file into a table of access by click button, is
these possible and do you let me know how to do that. I try to use the
following code to test, it will be conflicted and prompt up error.
Private Sub Command0_Click()

hope you can help me!
i'm trying to change Allen Browne's code to open multiple reports.
the problem i have is that the name of the report may not always be the same
the line:

Can I pull data from two databases at once?
I need to run a query where some information is in one database and some
info is in another. How would I do this.
Thanks

Or am I doing it wrong way from the very beginnig?
I've got a table called 'Invoices' which holds 1700 invoices together
with InvoiceIDs (being integer numbers)
I've got a Form called 'Jobs' (based on 'Jobs' table) with a Subform

I am trying to create an access database that will allow to import
excel spreadsheets at the click of the button on a switchboard.
I have been trying for hours to create a module in access that will
import excel spreadsheets that contains a table with 12 columns and a

I'm trying to code a data entry form where the user selects an option from a
drop down list and depending on the value the cursor moves to the area
pertaining to this.
e.g. Choosing from animal, vegetable or mineral.

I have a query called qryMain that is the data source for a form.  Currently
it is made of a table (tblAssociates) and a query (qryMaxDate).  The
qryMaxDate is used to filter the associate list so that only the active
people (most recently downloaded) show up in the form.  Now I ...

I ahve a form which allows me to selecta day of the week and as a result two
other controls are greyed out.
Private Sub Performance_AfterUpdate()
If Me!Performance = "Tuesday" Then

I have a text box where I want to allow the user to enter at most 5 digits
to the left of the decimal and 3 to the right. I'd normally mask this as
follows:
99999.999

I have a form (frmProjectDetails) which I'd like to open w/all fields
blank. I added the following code:
Sub ShowNewRecord()
   DoCmd.OpenForm "frmProjectDetails", acNormal

I have a combo box in my child form which accepts 2 values issue and receipt.
I have to ensure that the user selects any one option when he enters values
against receiving or issuing the item.
Right now if the combo box value is not selected it affects the QOH does not

I have: A form with FieldA as an autonumber.
I want: When a new record is created, FieldB will be populated with a
3-character text equivalent of the autonumber. (e.g., 5 -> 005, 12 -> 012,
136 -> 136).

I did what I thought would be a very simple after update procedure to record
the current user:
Me.Update_By = CurrentUser()
However, I get the "Another user has changed this data..." message box