Is there a way in Access to store more than one value in a field that has
been selected from a combo box?
For example, if a combo box had three values that you can select, "One",
"Two", and "Three". How do you drop down the list and select a first value

I am trying to find out what the best approach is to creating an Access
database with over 255 fileds in a table. I work for an accounting firm
and they have an Interview questionnaire that they would like ported to
Access (it is currently in Word). The Word form has well over 255 ...

I just imported 62000 rows twice from Excel. In my import routine, I create a
holding table and then validate the data prior to committing to the main
table. The holding table is created in the front end. All other tables are in
the backend.

Hi Gang
I used the Option Group wizard to create a group of radio buttons on a
form.  It created it with three options and it looks fine.  However
when I run the form the first option is checked but I can't click on

I'm trying to figure out how to migrate all my access database
information over to a new database that has been created.  The new one
is almost identical to the old database, except it uses a different
schema.  Is there anyway to do this automatically or will I have to

"The following unexpected error occurred in Sub CopyMySQLbttn_Click,
line #250, CBF on frmVehicleChooserform. 2465: "Can't find the field
'forms' referred to in your expression. You may have misspelled the
field name, or the field may have been renamed or deleted."

i have a (hopefully) small problem.  i have created a system where a user
enters customer information into a table through a form.  this table has no
primary key.  there are 9 fields on the form to be filled in, one of which is
a date field.  right now, i've been using this db ...

I'm having trouble trying to email a report via access...
I get a Outlook message stating 'a program is trying to automatically
send e-mail on your behalf. Do you want allow this?
This report will be emailed in the early hours of the morning when no

This is the code under a command button -
Dim ctl As Control
For Each ctl In Me.Controls
   If ctl.BackColor <> RGB(255, 255, 255) Then

I built a number of Microsoft Access programs in Access 2000.  We are
trying to use them now in Access 2003.
I have split the programs and configured them as SHARED in edit mode.
I have tried no locks and edit modes.

Can I have some feedback on the best way to access data held in an mdb on a
separate server over a LAN (and WAN for that matter). I currently use DoCmd
to bring in the relevant tables linked to the external mdb & (tdf.delete to
remove 'em when I'm done). I then use standard ...

I have a form with a subform in datasheet view. Now, I want to trigger a
procedure (P1) each time the user selects an entire column (by clicking in
the heading) in the subform. The procedure (P1) I want to trigger needs to
be called with the selected column as a parameter.

If I have a form open, what is the code that is equivalent to using the
File->Print menu with select record(s) option to print the form with the
currently displayed record values?
Thanks

I have an if then statement coded as an after update event procedure on
a data entry form.  It works perfectly on an Access 2000 database, but
when I try the same query on an Access 2002 database I get a "variable
not found" message.  I have verified that the field names are correct

I currently have a spreadsheet with customer\delivery\cost etc. a snapshot
of which can be viewed at
http://members.lycos.co.uk/moriman/dda-web.jpg
I am trying to construct a database to store this information.