When I use the edit/find feature in my forms it always offers the form name
in the "Look In" box and I have to select the field name to search in, can I
change the default, the field name is firstin the list.

I need some help, please...
I have constructed a series of dynamic queries (query by form) to
identify specific records in my one-to-many-to-many database. The
sequential queries successfully eliminate duplicates and I can display

I have a query which I have added Criteria to what data is presented when it
opens.  Example... I am lookin g for John Smith in a particular field.  John
Smith does not exist in the query.  I have a Form attached to this query... I
want to stop the form from being opened if ...

This is truly bizarre but the Access 2003 Toolbox has completely
dispappeared. I cannot find it in either Form or Report design. The Toolbox
icon is in the toolbar and I can click it on and/or off as a toggle box, but
the actual toolbox does NOT show up in Form or Report Design. ...

Is it possible to send a form via email and have the information from the
response loaded into a current access database?

I have a Form that is comes from a query. the query comes from two tables
that share a relationship. I have a button on my form that opens a word
document. I linked the query to the word document, when I first made the form,
i would open the form find the record i want to merge, ...

I included a Microsoft Chart on the main form of my access 2000
database. I included the chart using Access 2003 on my pc at home,
however when I open the database on my pc at work using access 2000 I
get an error which states "undefined function " format" in

I am trying to use the following statement in VBA in order to change
information in all records of a database.
RunCommand acCmdRecordsGoToNext
On random occasions, I get the following message

Hi, I'm having a problem where when I go to a subform that has a
default view of continuous forms, it locks up the main form and other
sub forms and will not go to the next record either.  It will only
allow changes to the first entry...can anyone help?

I have inserted a series of check boxes on my form.  However, they do not
reset themselves when I go to the next record.  If I check box #1 on record
#1, it remains checked on record #2.  Setting up a technical drawing review
database.  Check boxes denote those who have reviewed ...

When using the right-click "Filter by Selection," "Filter Excluding
Selection," etc., where are the filter criteria stored? I would like to be
able to store the filter criteria as a variable and use it later.
Thanks.

This can not be that hard, but I seem to be stuck. I am trying to close
multiple form is an MS Access pp, after a report is generated in preview. I
am trying to hook the close into the report's Close method.
All of the forms ion question are opened as acDialog and hidden. I can

I have a number of fields in a column with their labels in a column to the
left of them, but they are too close together.
In Design View I want to move the whole column of fields to the right a
little, so that there is more space between the fields and the labels.

Hi Folks - I know this topic has been discussed before, but I have a little
twist.
I have two combo boxes. The first combo box has four entries. Let's call
them test1, test2, test3, test4.

Hi,
I have the following code for combo box on entry form:
Private Sub ContactNameCombo_NotInList(NewData As String, Response As
Integer)