ID# is the primary key.  I have a form where you can enter an ID and the
Command button finds the record that is equal to the ID.  This uses
stLinkCriteria (through the wizard).  What I really want is for all the
records beginning with the ID entered to be available on the form.  ...

I have a Main table where I store Country, State, County and Locality codes.  
I have another Codes table where I store the names for these sets of codes.  
I originally tried to use the same codes in the Codes table and made the set
of 4 fields the primary key.  But then I ...

In my reading, I came to believe that once you opened a connection (in this
case in an access 2000 form) the connection remained open until the form was
closed. The code below gives me an error in the click event indicating that
there is no open connection. Thank you.

Is there any way the you can use Code to cause a form to do page up and page
down.  I have a Long form that some of the information that is at the bottom
of the form is out of view and only use by certain people.
How can I have a botton on click go page down to the bottom and ...

I swear as I get older, I get more forgetful. I've done this before, but its
been about five years since I used the code.
I have a lookup box on  a form to choose a record. Howver when I use the
navigation arrows I want the the name in the combo to change when the record

I have a form with a very large number of controls.  I place and size these
via code at runtime.  Not only does this enable more precise placement but it
lets me keep the mass of controls physically organized as small objects on
the screen at design time.  Here's the problem:

The code below has worked for years until my client updated their software to
2007. Now the mail merge part is broken. Any ideas?
Set myWord = New Word.Application
   myWord.Visible = True

Is there a way in Access to automatically close or hide the find and replace
dialog box after a match is located, instead of having to click the close
button or hit the escape key?
Thanks,

How do you stop the Access message when you delete a record.  I want to
create my own but can't figure out how to stop the Access delete confirmation
message.

Hello and thanks in advance.
I have an SQL string that doesnt seem to be working for whatever reason.  
The SQL (as checked in the immediate window):
SELECT tblPrograms.Program, tblPrograms.Part, tblPrograms.prgClass,

I am very new to using VBA to build forms and am having a problem.  I
trying to embed a query within a public sub routine.  The goal of this
query is to use an alphanumeric code entered into a combo box on the
form to retrieve an associated ID within a table. The bound column of

I have an access 2000 database that has numerous links to other tables in a
Teradata database far away. When I or my users use the database, they press
two buttons sequentially to perform two major functions.
Function 1 is to manipulate the data in the linked tables and create ...

I'am wanting to create a form with a browse button to find a specific
filename on a disk,folder and save the location to a tablie linked by a key
from another table. ie Ref No From table one linked and saved to results from
browse button (table2).

I use some code in a form's current event to format some controls and to null
some controls depending on other control's values .  I also have some code in
the form's before update event that checks to see if the form is dirty, and
if it is, it prompts whether to save the changes ...

Background:
Using Access 2003. Database is split. Front End is on six office PC’s. One
field is a combo box used to look up apartment numbers. (This is the general
point of reference for our work.)  When the correct apartment is located and