I keep getting errors on the WHERE part of my query. I'm sure it's something
simple.
I don't know if you will need the whole code to see what the problem is. It
is lengthy, so I will start with just where the problem is.

Is it possible to display different ControlTipText depending on which row in
a listbox is selected?

I have two forms named Form1 and Form2. Form1 contains a sub-form subform1.
How can I refer a control on the Form2 from subform1? Thanks

Hello.  This is going to be a peculiar issue but the db was done long ago by
someone else on a dark and drury night and this is a request from the users.  
I have a form with a txtbox that has zip codes entered into it.  On the same
form there is a cbo that has a query for a ...

Happy New Year Groupies!!
I hope 2008 is exciting and prosperous for everybody.
Today's problem, I have two very similar pieces of code on two different
forms. The issue is that one always works, the other does not

Dear programmer I don't understand the array can any one give very easy
example to understand the types of array ( I can use command button and text
box)
Example

I have a code that I had some help putting together.  I would like to modify
it to allow me to search 2 fields and not just the one its searches now.  
Brief overview is that it currently searches for a WORD in a field called
[Definition].  I would also like it to look in a field ...

Is there a way to programatically have a form update to the underlying tables?
What I mean is... As a user types into a form, Access doesn't seem to
actually send that data to the table (and thereby create autonumbers) until
user moves on to another record.

I have an Excel program to retrieve data from Access.
Recently, I moved the applciation  from Office 2000 to Office 2003.
The MS Access 2003 always popup message to open Access which does not prompt
in Access 2000.

I've got a form (frmPersonExcuse) which has two combo boxes (cmbExcusalReason
and cmbStage).  cmbStage is tied to tblMainEvent.Stage and displays values
from tblStage.Stage.  cmbStage is also set .visible=False. (I've got it
invisible because I don't want the user to see it or ...

If then
If then
End if
End if

I need to be able to have the database not auto save when entering in new
information on a form.  I would like for there to be a prompt for them to
save the information.  As of now when you enter in new information and close
the form it auto saves, and this is what I am trying to ...

I am familiar with Access 2003 and new to Access 2007.  I am using
Access 2007.
I have created a form and the size seems to be stuck at Maximized
(within the tab),  I can live with tabs if I have no alternative, but

I have tried following several (what seem to be obviously simple) ways
to display dynamic images on my form that will change as the records
are changed, but NOTHING seems to work. I have a form designed that
has interlocked combo boxes (change any one, and the rest change to

I'm creating a concatenated field to use as a id number for reference when
talking to other colleagues about the particular record.  I Use an autonumber
field as a unique id.  In the issues table, the autonumber format is set to
IS000000. For a Questions table it would be Q000000 ...