I have a form that contains several combo boxes and a listbox.  The listbox
is populated by a query that counts the number of entries in a table and
works fine.  This number (ID number)is in turn used as an identifier for a
log of records.  After all the fields are completed, I ...

Access 2000.
I have a form with two dozen command buttons that will all perform similar
routines. Now, I can have two dozen VBA click events--one for each
button--but I'd like to avoid that clutter. I could define a macro that calls

In Access 2002, I'm trying to use the RunMacro action within a macro.  It is
going to the first record, performing some actions.  Then, going to the Next
record and performing some actions.  It should repeat (Repeat Expression)
until the table is at the End of File.  Is there a ...

Does anyone know of a macro that will extract cell data from all the
files saved in a directory?
Here is a little more explanation:
I have a large number of budget spreadsheets.  The actual excel file

I need to create a Macro that changes the color of text in a report based on
the criteria I set.  Can anyone help?  I know it's possible to do, but I
cannot find anything on that in my materials?  I am using Access 2003.
Thank you!

Hello...I have a macro that directs a command button to return to the
switchboard. I would like to have the macro not only return to the
switchboard, but actully make a selection on the switchboard. I have been
able to get to the main switchboard by using "SelectObject" and have ...

I have a form which the user enters their UserName in an unbound text box
and Password in another unbound text box.  I want the macro to verify what
was entered in these two text boxes against information in the user table.  
If the UserName and Password match, then the database ...

I want to automatically view (sort) certain records based upon 2-3 criteria
which exist in specific fields within a form.  I have been using a command
button with various macro attempts, but with no success.  The problem is
getting the procedure to automatically use the specific ...

How do I open excel and run a macro from access.  I knoe to use the RunApp
action but not sure of the command line to include the excel macro.  The
Excel macro name is copycells.  Below opens the excel file but does not
excecute the macro

I have an application in which a user chooses values from combo boxes in a
dialog form say Frm1. These values then open the appropriate report and pass
the criteria to the queries underlying these reports. I have used macros to
hide certain  sections in a report say Rpt1 by ...

I am doing something similar to neeraj in the question of 8/3/2005.  I am
using a form to list possible reports to print.  My question is, how can I
check to see if a report exists prior to opening it?  I figured out how to
deal with an error if they didn't select a report, but ...

I read in a previous posting to use Tools > Options > General tab to set a
database to compact and repair on closing.  If I set this up on a database
with multiple users, will it affect any entries that are being made by one
user when another user closes the database?  Any help ...

I am writing a macro that I run with schedular to output a QUERY as an Excel
document.  I want this to be automated and not prompt anyone about
overwriting the existing file
Thanks a mil

Hi, I am fairly new to Access.  Am working on my third database in Access
2003.  This one is used to analyze huge data files for error conditions.  I
hve a group of users who are not very technical and they need to clear out
the data table and import new data on a daily basis.

I have a macro which opens a form based on the username and password that the
user enters on a Login form.  After the user enters their name and password,
I would like to have a specific form open based on the users level.  In the
user table I have fields UserName, Password, ...