I know how to iterate over CurrentDb.Containers("Tables").Documents to
get a list of all the table/query names in a database.  How can I
determine which is a table and which is a query?  How can I determine
the type of a table (linked or local) or the type of a query (local,

I'm trying to set the allowadditons property of a form using a macro and
setvalue. However, this returns an error message:
"The object you referenced in the Visual Basic Procedure as an OLE object
isn't an OLE object."

I am using the transferdatabase action in a macro. I will be importing
several dozen files that only vary by a single name. How can I use a variable
in the database name argument that prompts the user for a parameter?

I've got a button on my main form that leads to a form that I would like to
limit access to. I recall that there is a way to password protect a button. I
believe that I saw this done with code a few years ago. If your suggestion
involves coding could you please supply the code ...

When I am in a field property and go to build an event, it asks me if I want
"Expression Builder", "Code Builder", or "Macro Builder".  I thought I would
do code builder and this is the code that I built:
Private Sub MethodofPaymentID_AfterUpdate()

When you select run command in a macro, does anyone know where you can find
exactly what each choice will do?  Preferably something that you can print
out instead of selecting an option, then seeing a short description.

I have a column with a drop down menu of Yes or No in my table.  If a user
selects Yes when entering their data into the table I want a message to pop
up that says please enter Comments.  I have a Macro built but how do I
incorporate it into the table or can I?  Please help.  ...

I have a macro that opens a query, then opens Excel, then uses
transferspreadsheet to export the data to Excel. I'm having trouble when
defining the "table name". When the macro runs all is well up to the export.
I keep receiving a message that tells me the table name is invalid. ...

Okay, I have a problem that may or may not be simple, so hopefully somebody
can help me out.   I am helping some coworkers with a problem with their
custom database application.   The person who originally made this
application has passed away and now they are having problems ...

I created a macro to call a form and later on I deleted both the macro and
the form. However, Access keeps sending an error message whenever I start it.
The message says "the form name XXX is misspelled or refers to a form that
doesn't exist."

I have split my db into a application db and data db utilizing table links.  
I want to be able to run a macro in the data db (which updates the tables)
from the application db.  

Regarding the SendObject macro. I need t see if there is any way that I can
get it to put more than one attachment on an e-mail.
Thank you,
Robert

I'm trying to develop a warehouse inventory application, in Access 2003, that
will run a macro to display a warning by MsgBox whenever a user attempts to
issue a larger quantity of a product from the warehouse than is currently in
inventory. I've tried creating such a macro that ...

I have a MS Access database which has some 3000 records.
This is road segment database. Each record is a road segment with a length
in km. Length is given in a field [LONG]. I want to do a chainage for the
entire data base. So that each record get another field as [Chainage] which ...

I have used "Set Warnings" to No so that I can overwrite regular
reports and thus delete the older version.
I have just built a macro which outputs four reports in the same way
as above.