Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

Making an mde in VBA

Hi,
When I use the function docmd.runcommand acCmdMakeMdeFile
Access97 askes me a name and a location for the new mde-file.
Is it possible to pass this information with parameters?
0
depauw
Asked:
depauw
1 Solution
 
BigJCommented:
Try using the SendKeys command to automatically "type" the information into the dialog box.

Check Access help for details as the timing of this with dialog boxes can be tricky.

You can use this action to enter information in a dialog box, particularly if you don't want to interrupt the macro to respond manually to the dialog box. Some Microsoft Access actions, such as PrintOut and FindRecord, automatically select the options in certain frequently used dialog boxes. You can use the SendKeys action to select the options in less commonly used dialog boxes.

Because the dialog box suspends the macro, you must put the SendKeys action before the action that causes the dialog box to open and set the Wait argument to No.

0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now