I would like to create a macro that auto populates a check box based on a
selection from a drop down list in another field on the same form.
The field is called 'Status' and when I select 'Resolved' from a drop down
list (the list is based on a table) I would like the check box to ...

In previous versions of Access I used RunApp from the drop down list of
macro options on the macros builder form.
In Office 2007 it seems to be missing although the docs imply it's there.
As it isn't for me I'm assuming that's because it's filtered out by nanny

I have a master data sheet that i enter data on in excel, I want to have it
auto copy the data to another workbook automatic. Can you help ??  the data
is a combo of words and numbers.

Is there a way to define the actual server name in the file name field when
using a macro that imports a file?
I have a macro that imports a file from z:\a_temp but every one in the
office has this drive mapped different rather than go to everyone in the

I have a macro that calls a function with 2 arguments:
 Import (file path, state)
This function is importing excel files into an access database.  I
have to import a file for all 50 states.  Is there a way to set

I would like to set up a button that when pressed, would open the
coresponding Excel spreadsheet. The speadsheet file name would be that same
thing each time but would have the coresponding date added to it. Example
file names:

AddFromOutlook I was using the button inside a new database with the code
AddFromOutlook from the nortwind database as was working great, then all of a
sudden it stopped working so must have changed something to make it stopped,
but cannot find any information on this command, can ...

I haven't converted my 2003 database to 2007 as we have half an half users in
the office.
Problem:  2007 Users keep getting error msgs about having too many tables
open.  We are using the switchboard with alot of Macros involved and forms

Hello,
I have Access 97 and need to change the formats of an import specification.
How can I change and how do I develop a new format.
Also is there an easy way to import excel spreadsheets into the database

I am using a macro (ApplyFilter) on a button to search in the database for
records the match the search details entered.
I wrote in:
Filter Name: select * from Out

I have added a new data element to the Issue Tracker access database.  All
the functionality of the program works with this new data element (Issue
Type), except the search form.  It seems to ignore the fact that there is a
option to select records based on Issue Type and returns ...

"On Change" of in a certain field - I need other fields auto-grayed out.  For
example, on assessment inventory - once "distributed" it is either
"destroyed" OR returned to stock but not both.
So...if I enter data into the "returned to stock" fields - then the

I have a button on a sub-form which resets three user controls on that sub-
form.
I would like the sub-form to be generic, so that I can use it with more than
one parent.

I guess this question is a combination of Exporting data/Reports/Macros....
I have used Access to write a Check Printing application. I now have a
report where the user will enter a set of date ranges and the report will
pull all the checks wrote within that date range. It will ...

In MS Access, I have written a some VB code in a macro and named it as
"AutoExec" so that when ever the Access file is opened, this code will be
executed automatically. At the end of VB code, I included "DoCmd.Quit"
expecting that my application will quit. I open this Access file ...