Does anyone know how I can create code to give me the names of all procedures
in a database (from all types of modules)? Is there something similar to
getting the names for other types of objects, ie tables, queries,
modules,etc.?

I have a MDB front end which contain sall the forms/queries/macros and which
links to another MDB which contains all the tables. Nothing very clever.
I update the front end on my laptop quite frequently and need to then copy
it to the server. I have a backend on my laptop as well ...

In order to have a complete database, the information that is used in Outlook
and Business Contact Manager must be duplicated in the Access Database
(Names, Addresses, E-mail, etc.).  It would be helpful to be able to query
the tables for Outlook to eliminate the need of entering ...

I have a y/n text (ynGift) on a form.  There is another text box txtCost on
the same form.
Here's the logic I want to implement:
If the user "checks" the box, I want to set txtCost.Enabled = False;

First off I apologise because this is not a true access question, BUT I know
with all the experts here someone can help, if not oh well
I am trying to run a vbs script to place a shortcut on the desktop. the
problem is that the script blows up.

Hi, I have created a form with my own defined fields but cannot find a way to
drag them into access, all others work I just do not know how to refernce
correctly. Any help greatly appreciated
dave

I can't remember the correct object references to loop through a
table/recordset in VBA using the ForEach <Record>In <RecordSet>...Next Loop.
Of course, it is easy if there is an AutoNumber field, but I'm looking for
the correct references to do it on tables that do not have an ...

I have a problem with users not updating the front end on their PC when I
release a new version of the data base.
Each version of the front end that I release would either fix code problems
or release enhanced features.

My Access database is linked to many tables in our MAS90 database system.  I
have many Make Table queries that are executed by a command button on my main
form.  When I click the command button, I am prompted by MAS90 for my odbc
login.  I need a line of code that will ...

I have a table imported from a text file.
The format of the file has a record that relates to rows below it. but is
not shown against all lines
In excell I use the following

Help says that the FilterName argument is "A string expression that's the valid
name of a query in the current database."
I'm wondering if it *has* to be a named query or can one use an SQL statement
for that argument?

I have as Access 2003 application that uses the calendar so that a user can
choose a date from a form.  The front end is installed on about 20 computers
and on only one computer the Calendar starts on Monday rather than Sunday.  
When the user clicks the "Today" form button the ...

Does anyone know how to do a make table using vb? I am running SQL in one of
my functions and need to create a table.

I am creating a Bill of Materials application using a table that stores
parent/child relationships.
tblBOM (tableName)
Relationship_Key

I would to remove dashes from 111-22-5555.
I am importing text file and some of the numbers have dashes and some
don't
Thanks