Button on switchboard runs a macro that opens a query. Query prompts for
parameter value with default OK or CANCEL buttons in param value dialog box.
If value IsNull and OK is clicked - datasheet view opens with resultset of no
records - OK so far. If value IsNull and CANCEL is ...

Is there some expression I can use in a macro that indicates that a
particular form is open?  I am trying to get a command button on a form to do
different things depending on what form is open in the application at the
moment.  

Am using a form with a combo box listing various peoples names and
want someone using this to be forced to use a name from the pull down
list versus enter anything else.  Is there a way I can set form
properties to disallow any input other than a name on the pull down

I have created macros in Act!, but don't understand how to in Access. I did
go the Access sample databases and studied the Help macro w/out success.
I want to
Filter by form 2 fields: field1:labeled Cases Open. Options: Yes or No.  I

Is there a way of designing a macro that would pull from an excel spreadsheet
to populate a meeting on my calendar?

from xp, with windows scheduler on my local and my database on a network; I
cannot get a macro to execute.(run a query and export to a text file using
"TransferText")
when I run the schedule, it opens up access but the macro does run.

Good afternoon
I have been using the vba code supplied in Microsoft's kb article
199066 in order to retrieve the path for linked OLE objects. This
always worked fine in Acc2000.

?

When I was trying to record a macro in my personal macro workbook, I got the
error that the personal workbook is not open and I should have it open. How
do I resolve this?

Does macro support flow control like "if" statement?
I would like to have my macro have if statement to run different query
depends on the condition.
Is it possible to have macro like this?

In the TransferSpreadsheet Action, I want to export a query to an existing
Excel spreadsheet to a specific sheet.  In addition, I want the data in the
first cell / column in the query to be exported to a specific cell in the
sheet (not A1).

I have an access 2k project which extracts selected
information from a 3rd party system using odbc. The whole
reason for this project is to avoid paying the 3rd party
developers mucho moola to code the needed reports directly.

How do I make a cell (required data) before saving work sheet?

I need a little help with Access macros if possible?
Basically, I need a form with a number of drop down menus.  The first menu will have static content, however I need the second, third etc to be dynamic, ie based on what the user selects from the one before it.
Is this best done ...

whem constructing a macro one should give the different instructions
(keystrokes) which must be executed by the macro instruction. A combination
of "shift" or "alt" plus other letters, is replaced by "%" or "^".
eg Alt+N will become "%N"