I have taken over an Access 2000 MDB that has linked tables to a SQL-Server
database, and there are a bunch of "DoCmd.RunSQL" and "CurrentDb.Execute"
statements throughout the VBA code.  I wanted to clean this up and have more
consistency throughout.

I'm using an estimating form with a combo box for inventory.
I want to open the inventory form if there's not an inventory item in the
combo box of the estimating form, enter the inventory info, close the form
and continue with the estimating form.

Good night,
               I am doing a database that is designed to do three main
things:
(1) Accept input of personal information of the members of a church and

Hello.
I am using Access 2000 and I am creating a report and I need to create a
running sum hidden field in the details section. I need to create an autosum
that will count all of the "SB" in field [Office] and that have a date in the

Any reason a make table query that will run succesfully when double-clicked
will generate a 3061 too few parameters error?
The thing that gets me is that this has been working for ages and I just
made a very minor tweak in the query and suddenly it stopped working. I can

Is there a way to turn off the text box display until the results are ready
to be shown. For various reasons I requery the data and this causes the first
record to display for a brief second, then my programming causes it to jump
back to the record you were on when you caused the ...

I have a form  which is intended to display one record according the
parameter set on entry. At the foot of the form I have a button which, when
clicked, returns the user to the main menu. However, I have noticed that if a
user presses the tab key when this button has the focus ...

Is there a way to change the Access window size when I open my database. I
have a small form, with very little data entry in this case. I would like for
the application to open to a specific size.
Thank You

Sorry, the previous post escaped from me.
I execute a SQL statement in code and would like to look at the recordset
returned in order to debug. How do I display the recordset? I prefer to do
this from the VBA screen, but anything will do.

I am having a bit of trouble getting a Form to change the RecordSource.
I have 2 Forms -- one is a Login Form, and the other is an Admin form for
administering data.
The user clicks on their respective name in the Login form (no pwd

Is it possible to use a button to open a form, but set that form's parameters
in the event properties of the button. For example, I may wish to use a
different query as Record Source for that form depending upon which button
was used to open it. Or, I may wish to have different ...

Can anyone tell me how to programatically reset the autonumber count in a
table in Access?  I want to run a delete query to remove all rows, then
append rows and have the autonumber field begin counting at 1.  I don't want
to make a new table with a new autonumber field, because ...

The program is using the regional settings for Brazil. Using these regional
setting. the currency is as such: R $ 100,00.
they use a comma instead of a full stop to denote decimals.
This now causes an issue when sent as a parameter value as Access does not

I am using MS Access 2002 (10.4302.4219) SP2 but guess this problem is not
Limited to access VBA
I am trying to get the path of a file with the office open or the file picker
dialogue using VBA. The file is a lotus notes database shortcut .shb

I am trying to run a pop-up calendar in Access (I am a SQL girl... not
familiar with VB code) and I can't seem to figure out why I keep getting this
error:
Run-time error '91':