I have a form which included fields [Manufacturer], [CatalogNo], data
and have inserted this code behind the CatalogNo update event
it is intended to insert into table: [additionalPages] in its field:
[catalogsheetlink]

I have a form embedded within a main form. The main form has a button to
show me selected records after onClick. I am having a problem targeting the
form as it keeps failing on this line:
Set rst = Forms!frmImp_Process_Client_STATUS.RecordsetClone

I am having trouble figuring out how this would be done, and would greatly
appreciate any help.
FYI this is on a switchboard gui. In Field A, someone can type in a specific
number. I would like Field B to autopopulate with information based on what

Is it correct that the Linked Table Manager is disabled when the user's login
does not have local machine administrative rights?  
If so, is there any alternatives to relink tables on non administrative
accounts?

Thanks for taking the time to read my question.
I have a label with a Hyperlink Address.  When the user clicks on it, the
web page opens.  The web page is a local file found on the users hard drive.  
If that file gets moved, and you click on the link, an error comes up saying

OK I know you all told me that I should do this diffently, but I got it to
work.  I am just having one problem.  Here is the thing.  When my form loads
I have a Event Run on the OnCurrent for each subform and this removes the
array for the previos form, so my array only has the data ...

What do I need to add to my button On Click so that the form will open to a
new record?
Private Sub OpenComplaints_Click()
On Error GoTo Err_OpenComplaints_Click

Got a database that does some back end processing. Client wants a screen to
show what it is doing. (Don't ask me why) Trying the following code,
essentially just trying to get a 4 second pause between the message changing
for testing. When I run it I get the hourglass, no change ...

This should be simple, but I can't find an answer in previous threads.
I have a form [Select a Patient] with a combobox [Combo10] from which a
patient record is selected.  [Combo10] gets it's information from a query to
display names and the patient [ID].  [ID] is the bound column.  ...

I'm using Access 2003.
I've created a database that has a front end and a back end. Two copies of
the front end is in use.
In the front end is a form that contains a text box that is bound to control

I am using Access 2003.
I have a form in which one of the fields ([size2]) should only be completed
when another field ([type]) says "multiple".   I want to stop anyone from
entering data into this field unless the the [type] field says "multiple".  

How to disable Textbox if is selected some value in Combo Box...
Example:
I have Combo1 with many values.
If select value "House" in this combo, Text1 must be disabled.

Good Morning,
I am finally creating that last part of app...what I am trying to do
is create a command button that will print a report for any record
that is older than six months. I am sure that this is an easy

How can I set up a combo box that allows multiple choices?  I assume I then
process the choices using code...

I'm new to Access and need to know if I can create a form that uses mulitple
combo boxes each based on a seperate table, to create a unique NEW record
that will be stored on yet another "record" table.
To explain the purpose of the form: