Brief summary:
I have a main form to hold employee info and a working hours subform. Each
employee has many records.
I would like to add a new record for each of the permanent employees while,

I have a small database with a switchboard.  I have successfully written a
macro to close the switchboard to the query tab of the database window.  What
I really want to do is exit access enitirely when I click on the exit button
of the switchboard or at the very minimum close ...

Hi-  What I desire to do is fairly simple.  I want to create a simple voting
form which will require a macro.  The form will contain two objects:  a
numerical field to be entered by the user and a button.  
First the user enter's a number on a voting form, which selects the ...

Hello All Database (Access) Guru's,
I am a novice when it comes to databases and I know enough to get
simple information for my needs.  With that said, I was given an
opportunity for improvement a database.  

I have a main form bound to a parent table and a sub form bound to a child
table. THe child table has a combo box that the user can enter only items
already in the table. I have created a form to add items to this table. I
have created a command button to go to this 'add to' form ...

Access does not support the method "DisplayAlert", then how can I
disable the pop-up msg in Access?

From within a VBA MsAccess application I:
- open a Visio document,
- selectAll objects,
- copy to clipboard

I have created a database that has an AutoExec to Hide the DB Files and run a
macro.  At the end of the AutoExec, I added an Exit command.  Now I can't
stop the database to work on it, put it into Design Mode.  How do I open the
DB in

In a macro, is it possible to set the answer to always be YES?, when you get
the prompt "The file 'C:\[filename].xls' already exists. Do you want to
replace the existing file?"?
Like you can with "SetWarnings", is it possible to do the same with file

I am trying to write a macro that will bring up an error message if the data
entered on a form does not match the data already entered into the database.  
I know I have to use the MsgBox arguement, but I am having trouble with the
condition.

How to read Macro Action and Agrument from VBA???
Thanx!

I have a form with various unbound  tick boxes & combo boxes. I want to build
a macro which runs a different SQL query depending on what state the tick
boxes and combo boxes are in.
The various combinations of tick boxes and selections in the combo boxes is

when i use DisplayAlert = False, can i change the default respond to
other choice rather than the default choice by Excel?

I created a macro to set the value for a form's data entry to No.  The error
message returned says "The object you referenced in the Visual Basic
procedure as an OLE object isn't an OLE object". I've successfully used this
very same macro in another database.

Can anyone  assist me in designing the following macro?
I have a (continuous) form in which each record has a checkbox field which
the user manually clicks yes or no.  I have a macro which performs certain
functions depending on whether or not the checkbox is clicked to yes.  I ...