Take a look at this loaded question.
I have frmEventRegistration which is based on tblevents. I would like to
create two buttons on the form. One would automatically register all contacts
from tblLeaders where LPosition is 2. The other button would automatically

I have a form with a subform. Main form (frmProd) takes 3 criteria via
combo boxes and is bound to tblProduction. The subform (sfmProdOp) is
bound to tblProdOp and contains the details for each instance in
tblProduction.

I have an ad hoc tool that i have built for our sales people.   I creates a
new access database and puts the data they requested into 4 tables.   Here's
the code I use to create the database and to create one of the tables
' This section Creates the database.

I need to be able to do something and I'm not sure if it's possble.  I need
to be able to enter several item like the following:
ProductID   Product   Discription
87765        Ball         Baseball

I have an Access 2002 application that I have been running on Windows XP SP2
without issue.
I just installed the application (running in Access Runtime) on a Windows
Vista Home Premium machine.  Now, anywhere I used the =Date() function, it

I mistakenly posted this in the reports forum so I thought I'd better post it
here in the right forum!
I've tried to populate a combo box before but never got it right. I'm
wondering if anyone out there could help me out?

I am using one form for two slightly different purposes.  I want to be able
to have one txt box have 2 different Data control source's.
1 = existing customer 2 =new customer
So something like "on open event"

Does Docmd.DoMenuItem support to run Close command on File menu?
I tried to close MS Access application using VBA in the AutoExec macro.
Is it possible to do this?
Your information is great appreciated,

I have an application which works fine on my machine, but it has performanace
issue on my user machine.
Our machines just sit side by side and connect to the same network.
Aything I need consider klike defragment HD?

I am creating a questionnaire in access for children with disabilities
and I am trying to make it as friendly as possible.
I am making it so with some questions there are three options for a
choice, and they will simply be a sad face, an ok face and a happy

I am using VBA to run a query that is connected to a command button in a form.
The query over writes an existing table with new data.
Each time the query runs, Access shows two dialogue boxes.
The first message is …

dears,
in access 2000 format while programing on the forms i used dd/mm/yy date
format
( that is my system date format)

Hello Access Community,
We have A2003 and have been using the calendar control forever without any
problem.  All of a sudden whenever the calendar is opened, we get the
following error:

I am trying to get a command button's caption to display some text
along with the value of a textbox control for each record in a
continuous form... I took this approach but it displays only the value
of the first record's control on the button for every subsequent

I have the following code:
With Me
       .Filter = "[Status] = 'Open' AND [Source] <> 'SE Meeting'"
       .FilterOn = True