The Access 2002 code behind my maintenance form loops through a recordset of
serialized items to be fixed and writes maintenance records for those items
using action queries (like INSERT...).  Sometimes the dates for all or some
maintenance/configuration information is Null: For ...

I have a subform within a subform within a subform (yes thats right 3 levels
deep)
From my first form I wish to reference the subform at third level down.
So for arguement sake we will call the first form "Form1" the second form

I have database that is public access but needs some features accessed only
by certain people.
I have created a table (called tblApprovalTable) which has the following
fields, as well as others.

I have included a stop button on a form to exit a database. The code for
this is
Private Sub QuitApplication_Click()
On Error GoTo Err_QuitApplication_Click

i have a database and i want to be able to luanch at the click of a button
into a powerpoint slide show i have tried the following code:
Private Sub Command12_Click()
Shell """C:\Program Files\Microsoft Office\OFFICE11\Powerpnt.exe"" " & _

Good day,
I have a simple search form, and a result subform. The form is a text field
(keyword) and a search button. The subform is a query whose WHERE criteria is
the keyword field in the search form. The search button on the form requeries

I got two forms
1)"Products And Price"
2)Invoice
In Invoice Form, I got fields ( Products , Measurements and Price)

Help! I'm going around in circles in this one. Its apparent I'm missing
something about how VBA handles if/then/else statements.  Debugging it shows
that always performing the "otherwise" code even if it already populated it
with the plastic field. WHICH I WOULD EXPECT since ...

I have taken over the development of a new Access applicaiton from a
programmer. (my area is database design, not programming)
In order to salvage the application when the file became corrupted earlier,
I created a blank database and imported all of my objects into it. After

I intermittantly get an error message after running a VBA function that has
DoCmd.Quit acSave at the end.  The message states that I can't exit access
now becasue there is a VB session open.  From all my checks, I have closed
all objects and set recordsets/dbs to nothing.  Is ...

Hi, I hope you are doing well.
I need to know if there is a function or whatever I can use to copy field
data from the right or left of the field up to the first blank or comma or
whatever.

How can I build a string variable and use its name to run a sub-routine.
For Exapample:
strProcess = "Run_Process_" & strDB
strDB = DB2

I have code at the end of the Before_Update event of an option group that
forces the user, by means of a MsgBox, to confirm his selection in the
option group. It works just fine, except that after canceling the update,
the record shows the little pencil up in the record selector, ...

Hi, my problem is that when I try to use the working days function from here:
http://www.mvps.org/access/datetime/date0006.htm, I get an error message.  
The error message is "Undefined Function 'Working Days' in Expression".  I'm
running Access 2002.  Any help would be ...

I am new to VBA
Question: what is the code to replace a value in a field.
eg
Let the field name to be "Fruit"