I see a lot of posts here about combo boxes, but have not quite found my
problem yet...  I swear I have seen this before, and I may even have used
this before, but cannot for the life of me find it!!!!
I have a combo box that fills according to a row source UNION query so that

Hi All - I have created a form to capture customer details. When an end user
tries to add the data and put the phone number, I want my application to
first find if the record exists. If it does then it should display the
record. If the record doesn't exist then it should allow ...

I have a combobox that grabs a list of distinct items in a table where the
item begins with "10" (10 is a unique designation for us). The table has
about 50,000 records (roughly 1000 of those begin with 10) and the field for
the combobox is indexed. The combobox takes 25-30 seconds ...

I have a form that I need to place the id# and idName at the top of the form.
the id# is based off the idtable and the number is unique to the idname and
the id# is an autonumber.  I'd like the number to increase everytime the
idName is entered.

Hi, we have applications that are in more than one version of Access (from 97
through to 2002). These applicatons use the same Calendar control version 8
(regardless of the version of MS Access that is installed on the user's PC).
The problem is that on one pc the calendar will ...

I've got a db with lots of combo boxes and I'd like the user to be able to
scroll through the list items using the up/down arrow keys.  I'm currently
using the KeyPress event and looking for keycode = 40 to enable dropdown on
the combo box.  However, this seems cumbersome as I ...

When I try to run the following code on a button's click event, I get the
above 3634 error:
Dim db As DAO.Database
   Dim rs As DAO.Recordset

I need to be able create a survey database that the user can create their own
set  of survey questions.  Does anyone have any examples?
Thanks,
Larry

Hi all -
Can anyone tell me how to set up a popup reminder when a user moves off a
record as they use my form to inpout data?
I want to reinforce a few specific fields to them, which I would like ensure

This question concerns an Access 2003 Data Project.
I have a list box on a form that my end user is going to use to navigate to
a selected employees record.  The end user selects a name from the list and
clicks on a button to navigate to that employee's detail form>  Here is the

I have write this code for populate one access form , i m working with
access XP,
Private Sub Form_Load()
DoCmd.Maximize

I am trying to write a VBA module to access the values I have stored i
combo boxes. I have several combo boxes on the form with multipl
fields in each combo box, but display a list of only one field in each
The user then selects a value for each combo box. After he is done h

Does anyone know how one might be able to change the colour of the message
box title to a colour other than the standard "blue" bar?? I have been asked
if I can display it in "red" when it is a critical error....
Thanks,

I've created a form for entering data. On the form I have a text box which
the user types in an account number. I've set the 'OnExit' event to check if
there is data in the filed and to requery the next field which is a list box.
The list box field has the row source set up to ...

I have a form that has a combo box for shippers/consignees.
The combo box brings up the shipper/consignee name,
address, phone and misc info.  I'd like to change this to
be a combo box for the shipper/consignee name only and