Dear reader,
How to stop a VBA procedure after a form is set open with:
DoCmd.OpenForm ("FormName").
After this instruction the VBA procedure is running further.

The Access 2003 / SQL Server 2008 Express app I've created performs
well over a VPN, except for the main form which has uses tabs, with
multiple subforms and combos within them. It's very very slow. I've
been looking at the tracesqlmode and can see that the form in question

The form Chooser has worked without problems for about a year.
 It suddenly stopped working in November.
 It was written for Access2003, but I don't spend much time at the
 facility where it's used, so I took it over to the local university

Okay, one more for you guys. How could I go about checking a check
box based on a value chosen in a combo box on the same form? For
example, if the user chooses black, white, or red in the combo box,
the check box is checked automatically. If the user chooses green,

Forms, Reports, Combo Boxes, List Boxes
Is it better to use a saved query as the RecordSource / RowSource or an SQL
statement
Discuss ( as the teacher would say)

I have a linked table, the file it is linked to is a .csv file.  I
want to browse to a location and then link to the selected file
(another .csv), I have the code that allows me to browse but I am
having trouble getting the syntax correct for refreshing the linked

Hi.  I have a database that handles score records for dogs that compete
in Obedience.  There are 3 different classes that a dog may compete in
(Novice, Open, Utility).  I tried to create a report of TOP 20 Scores
for each class in a particular year.  The final report was supposed to

Something I don't understand about the literature and discussion about
ACCESS.
It appears as if 80-90% of the work done with this software is done by the
developer mainly because there is little information about user-friendly

I have various links to a SQL Server that is producing pivot/crosstab
recordsets. While it is possible to launch these in access as a table,
they are very ugly, and there is nowhere for me to put various support
controls like filtering or printing or outputing to excel.

I've got 2 tables and a report I could use a hand with. Table 1
contains a number and a name associated with that number. Talbe 2
contains the same number, but with different fields. What I'm trying
to do is simply display the fields in Table 2, but instead of the

I want to put a condition like:
IIF(Condition1=True,>0,0)
But apparently, we can not use >0 inside a if statement?  How to get
around with that?

I am looking for a way to "call" or "parse" whatever the value of any
of the text boxes in a continuous form.  Meaning that when a user
clicks a command button the system filters on whatever value, is in
whatever textbox the cusor is in.  Is this possible?

Typically i just create multiple queries and combine them into one
query at the end but thought maybe there was a more efficient
(cleaner) way.  If i have the following data:
Resource       Hrs     Job

Does anyone know how to convert an MS Access 2000 database file to Open
Office Base 3.0? I understand that SQL can be used but I don't know how
well it works or which programs can be used to accomplish it. Any help
will be appreciated.

I have a form that includes fields for three different tables. When I
click on submit I want it to add the information in the fields in the
respective tables.  This is all fine and is working.  However, right
now it is executing three insert statements consecutively.  If one has