I have inherited an access database that is designed to work as a tech
workorder system. IE unscheduled and scheduled workorders are generated and
then stored in a master WorkT table. Each time a new workorder is generated,
the WorkID field is incremented by 1. This all works ...

I have got to be the worst programmer ever.  Truthfully I'm not a programmer
at all, but I have to do this anyway and I need help. :(
The following code is supposed to create a new user and add that user to the
"Users" group:

Okay, stupid question.  I've got the following code.  I sort of ripped it off
a code snippet I found in an Outlook programming book.  I've modified it to
apply to my situation.  I'd like to run it by all of you out there to see if
I've missed anything.  One problem I have is that ...

This subject is abundant if typed in Google, but I keep getting a mistake,
I have created a Form Called "Edit Aircraft". I want this form to be opened
by another form. I inserted the Sample code found in the help-file:
Private Sub Form_Open(Cancel As Integer)

When I use a "Type" statement in VBA's class module, I get an error.  Is
there any way to get around this problem?
Thanks,
Eddie

Can anybody help
I have a text field use to store both names and towns. It has been inputted
into the table using this format
Name (Town)

I am using the following code to select which subform appears based on the
type of record displayed (there are three classes of objects in the database,
each with the same core data set and three separate sub-tables of data).
Private Sub Form_Load()

I get this error when I run the code or compile. The Loop DOES have  a Do.  
The only thing I can think of is that I have too much in the Do/Loop. Is
there a limit?  I can't figure out why I get this error. Everything is where
it should be. The code ran before, then I added some ...

I have created a form called frmModify that is based on tblModify. Within the
form I have subform(called frmExisting).  On the the form Modify, I have a
list box where users can pick a conveyor to modify.  The only problem is that
the table Modify has many conveyors with the same ...

How do I find the full path name to a database. Linked or
otherwise. Using Access 2000 form open event.

I have a FrontEnd DB on several users. I'd like to create a function that
compares the queries, forms, macros, etc, of the frontend and the database i
use for development and imports the objects that doesn't exist in the
frontend.

I have a table were I need the information of the record above.
It is a table were de information of two records actually always represent
one record.
But on the second line there is no customernumber anymore. It is blank.  

Hi I have an array, created by a recordset, and I want to pass it to a
function along with the value.  the function will check if the value is in
the array and return YES / NO
I'm getting a comile error of TypeMismatch: Array

I have problem with this error:
9. Subscript out of range on line
Set rst = PlaningDB.OpenRecordset(SQL)
Dim rst As Recordset

I would like to validate data in certain fields on a form using a validation
rule (or any other method) so the error message appears when the field loses
the focus, rather than waiting for the referential integrity of the
relationship to catch the error when attempting to add the ...