Is there a way to take an existing table and run a macro
that will change the names of the fields?  Or do I have to
do this by programming a module.  The field names will be
consistent all the time.  What I am doing is pulling data

I am using a Switchboard menu to run a macro that will initialize my
database. I am trying to add a MSGBOX that will give the user the
option to back out when the answer "NO" is selected and return back to
Switchboard menu and if "Yes" continue through the macro.I even tried

I have just started doing some VBA programming in Access.  
I am pretty skilled using VBA in Excel, Word and Outlook.  
My problem is pretty basic.  Access does not seem to
recognize many VB functions during compile/execute.  For

I'm using Access 2000 and am trying to come up with a formula that calculates the Present Value of a sum invested at say x% that provides a series of cash flows at say y% for fixed term of  N years.
For example - how could I express: the amount  I would need to invest at 5% today ...

What is me! or me. ?
example
me!EmpIDControl

I have a log-in form with a lab code as the primary key.
I'm using a Yes/No checkbox in this form and my query is
based on this box. The user fills in the form and checks
the Yes/No box in front of the new lab code. The user then

I have about 100 append queries and I wanted to put them in a macro.  The only way I can think of doing that is to tile the windows vertically and then select and drag each append query one by one into the macro.
Is there an easier way of doing this?  Any way of selecting more ...

I am trying to use a button from an Access form with the use of a macros to
open an Excel spreadsheet and automatically open the Find control
simultaniously. Can anyone shed some light on this?

I have a very simple database.  I am building the
database so the user can upload files to existing tables
and run reports all using forms.
The table where the file is uploaded has 20 fields.  The

We have 5 networked computers, all using Access97.  Each
computer has the same .mdb program installed on it and are
all linked to a common database.  One of the functions I
put in it is to use SendObject to start an e-mail.  This

I'm getting an error on the first line of code on a macro.
Dim myDB as Database
Anyone know what I can use?
thanks

Hi, Is it possible to append a new column to a table using
an Access macro?
CopyObject/Table is fine, but then I have to change the
table structure to accomodate a new field on a user input

I need to import Excel into Access, overwriting the
existing table, but keeping the same structure.  I DO NOT
want to append, which is what tranfer does.  Any thoughts?
Also, can import a CSV without having to convert it first

I've written a simple Macro to apply a filter to a subform. When I ope
the subform directly (i.e. not via another form) the filter run
perfectly. However, when I open it as an object within another form
and run the filter, nothing happens.

Is there a way in MS ACCESS to create a custom message box that will display certain variable data instead of jus
fixed text? I want to be able to display back to a user a confirmation message similar to this
"You are about to ship SN#123 to location ABC. Are you sure you want to ...