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 ?