If have a parenet form with a subform.
When I enter data into the subform I need it to add the data into the table
but I am not sure how to do this.
Do I use a docmd to create a new record and if so how do I get the button to

i have declared one global varibale named VAR1 in form module and
another defined in sub proecdure with the same name (VAR1) in the
same
form module . if i use VAR1 then local variable will be

i have two table in one table
name              group
AA                   1
BB                   2

I have a database with two tables - a Work Order table and a Preventive
Maintenance (PM) schedule table. I am also using the Access Switchboard when
the database is opened.
In the normal Database view, I created an update query (PMCreateOrders) that

Can any one give me some help on the SendObject command:
I get the error message:
The Command or Action "SendObject" isn't available now"
Thanks,

I have a form that keeps track of updates made to another table. However
what I would like is to update the other table with the changes.
Example
I have 1 table called IP Data and 1 called IPCData

Using vba, I need to open a 256 color bmp file in Microsoft paint, then save
it as a 24-bit image.  I have a large number of files and have already
developed a way to programatically loop through the files.
Thanks very much for your help!

I am looking for sample code that allows me to extract e-mails from outlook
and save them in a folder on my disc. I also want to get the details of the
mail - like sender, title, to etc.

I am trying to create a query using the GetElapsedDays to get business days
that an employee is out of the office.  When I use the GetElapsedDays() on
its own it works fine but when I try to drill down futher by having the query
/7*5 it Errors out and when I try to use and ...

I'm not a programmer so apologies if this is a really silly question.
I'm using VBA with Access for a piece of work.
Is it possible to create an executable file that will run without the user
seeing that Access is used.

How do I  get this to insert into multiple fields, instead of just one.
strSQL = "Insert Into tblVendors ([Vendors]) " & _
                "values ('" & nvendor & "');"
-Thanks!!!!!!!!

After a delete query that deletes all the data in a table, I also need the
autonumber (key) reset to zero.  It just keeps counting up forever.  After it
gets in the 6 digit numbers it messes up my code that uses that field as part
of a file name format 0000.

I have two text boxes in Access 2002-2003 that contain a date/time and I am
trying to apply a an IIf statement through their control source, but for some
reason they are not giving me the desired result. I can change the order of
my arguments, but usually only the first two work.

I've got an Access2k app that exports sales data to an excel2k ss. I've got
the data sorted up ok but now I want to have subtotals generated. Can anyone
help me make that happen?
Thanks, Bear

Hola  todos:
Tengo el siguiente código de Access 2003 que no funciona en Access 2000
(lamebntablemente la BD ha de ser en 2000), el cual copio a continuación:
Function apEnableShift()