By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 2,064 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

Send Keys

P: n/a
My program in Access (Office 97/2000/XP/2003) opens a database (MAIN
MENU) with a listing of all databases in a directory. User selects
what database wants to open, and program opens it. I am not just
reading data from it, I open/run it and forms created in it, can be
used by user (MAIN MENU closes).

From MAIN MENU I have the following for opening a specific database:

SendKeys "%F{DOWN}" 'ALT F
SendKeys "{ENTER}" 'Open Window opens
SendKeys "c:\test\Ipd.MDE" 'send in FILE NAME
SendKeys "{ENTER}"

From the specific database, user can return to MAIN MENU with the
following commands:

SendKeys "%F{DOWN}" 'ALT F
SendKeys "{ENTER}" 'select Open database
SendKeys "C:\test\sample.mde" 'send in FILE NAME
SendKeys "{TAB 2}" 'set focus the OPEN button
SendKeys "{DOWN}" 'drop down the OPEN button menu
SendKeys "{UP 2}" 'select OPEN EXCLUSIVE
SendKeys "{ENTER}" 'press enter

Both parts of code work without any problem in different Windows
versions & languages. As soon as "C:\test\sample.mde" is send to FILE
NAME and tab is pressed the field FILES OF TYPE (in open window) from
"All Files *.*" changes to "MDE files".

On my Russian testing machines there was no problem. I have a problem
with some client machines with Russian Windows & Russian Office 2000 &
XP. The FILES OF TYPE does not change to "MDE files" with a result
OPEN window to remains open without opening the database.

Is there any solution ?
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.