Conditional Macro, Check for Lock on Table or Query
Thu, 16 Oct 2008 15:00:15 -0700
I have a macro that updates tables which are used to run a report.
I want to make sure none of the tables I am about to update are locked by
other users at the time I run the macro.
I thought of checking the directory for an ldb file, but my being in the
database creates the file - so that wouldn't work.
...
|
Open another database from the database I'm in
Thu, 16 Oct 2008 10:35:02 -0700
Hi all - I have two databases. I want to create a command button in the form
of one database that takes you to the other database, and vice versa. is
this possible? ...
|
SetValue for a Toggle Button on a subform
Thu, 16 Oct 2008 08:50:13 -0700
Is there anyway to have a subform closed when opening the primary form when
using the setvalue toggle botton?
Currently, when opening the primary form, the subform is showing, I wish to
have it closed until I click on the macro (toggle) to show the form.
I've set up the SetValue correctly but don't know ho ...
|
Macro that works in Access 2003 does not work in Access 2007
Wed, 15 Oct 2008 12:58:19 -0500
Hello, I have a simple program that manages people in a database. It uses
macros, in which the user can just click a button, and it opens up the
corresponding form. This program works fine in Access 2003, but not in
Access 2007. I have added it to the Trusted folder, and enabled all macros
in the settings, but w ...
|
SendObject to DL in MS Outlook
Tue, 14 Oct 2008 15:44:31 -0700 (PDT)
I created a Macro with a single action - SendObject
The "To" field is limited in how many email addresses that can be
entered.
I created a distribution list in MS Outlook.
When I type the DL name in the "To" field, it is not recognized in the
email editor after running the macro.
Can I reference the Di ...
|
Controlling flow of actions
Tue, 14 Oct 2008 14:33:01 -0700
Hello,
I'm having trouble getting my macro to perform actions in the correct order.
Here's what I wrote:
OpenForm: Form requires user to select a City from combo box
OpenQuery: Append query uses City from above Form
OpenQuery: Append query #2 uses same City as above
When I run the macro it opens the For ...
|
F4 expand Combo Box
Tue, 14 Oct 2008 13:05:01 -0700
Microsoft Access short cut key F4 opens a combo box to show the available
list - I'm looking for code upon entry into the field (If it is Null) to
automatically do the equivalant of F4 - any help would be appreciated -
Thanks in advance ...
|
|
|
GOTO RECORD ON CLOSE OF MODULAR FORM
Tue, 14 Oct 2008 11:45:01 -0700
I need to goto a combo box on a master form after closing a modular form.
What event do I attach my goto control macro? I have tried On Close, On
Unload, On Deactivate. None of them work. It appears that the form doesn't
actually close before these macros begin working.
Thanks! ...
|
Macro in MS Access 2000
Tue, 14 Oct 2008 10:09:03 -0700
Using OutputTo Action Macro: is there a way to send the data to a specific
worksheet in an Excel Workbook and then have Pivot Tables set up to draw off
that data> ...
|
Print Macro Definitions dialog box
Mon, 13 Oct 2008 14:43:01 -0700
Is there a way to stop the Print Macro Definitions dialog box from coming up
or printing the definitions page when you run a Macro with a PrintOut action?
--
julostarr ...
|
