I have searched and searched on this topic and can't find a resource that
addresses specifically what I need.  I need to filter a form using 4 conbo
boxes. I need them to filter records on the fly, that is, as the values are
selected in them. I have found many posts that explain ...

I have two tables that are linked by a customer code. I have two forms one
for each table. On the first form Ihave a button that links me to the second.
The problem that I have is that I need the second form to open up on the
corresoponding record. aat the moment if i go to ...

I have created a after_update event on a Yes/No CheckBox which searches
through a recordset clone of the form and updates related records. When I run
the code below, which works, I get the message: "Another user has made
changes to the record. Do you wsh to save changes, drop or ...

I need to find out to which table a bound field belongs. Is there an easy way
to do this?
My current approach involves "parsing" the recordsource property to find
out. However, this doesn't work when the recordsource is just the name of a

I need to click on a button and open a form. When I type in the form name and
the. I get no "Show".
What am I doing Wrong

I've looked all over access for help on this but could not find the perfect
fit. I’ve read everything I could find on cascading but that’s not exactly
what I want. Here goes.
I have a combo box that contains test names, and based on the test name

Quick question really to which I can't seem to find an answer.
I have a msgbox that appears upon the clicking of a field, the message is
quite long winded and would be better spaced out into seperate paragraphs,
but how the hell do I insert line breaks into the middle of text on a ...

Is it possible in the code of a main form to call a function that is coded on
a subform that belongs to the main form?  Reason being that conditions need
to be checked from both places, possibly several times in the subform and
once when exiting the main form.

Trying to build an expression for a field within a form. The form has a
source table. For one of the fields in the form I am trying to develop an
expression that will create a default value (input data from a field from
another table).  Make sense?

I have an application installed onto 50 machines (all supposedly same
build).  On one of the machines I get the following error
             Category      Remote OLE Automation error
             Source        ADODB.Connection (remote)

request for access example form sourcecode

In a certain function, I am trying to process data I expect to be a date.
But, as with all things, I have to prepare for the worst: the String given
to me does not translate into a date.
What is the natural progression? Raise an error/exception! But wait, I can

I have two text boxes - let's call them txtBox1 and txtBox2 -- on a
form that both have a fairly complex DLookup function as their
controlsource.
I want the back color on txtBox2 to be pale yellow when it has a higher

Hiya
I've got a form like this:
ExpenseType (Combo) - Bound to T-ExpenseReports
DollarAmount (Text) - Unbound

I seem to have a mental block for querying in code.
I'm trying to do the following:
Private Sub Command72_Click()
   Dim mydb As DAO.Database