I have a script that was written over 5 years ago in version 8 that has only required minimal tweaking over the years. I am upgrading to version 12 and I'm now using win7 and MS Office 2010.
Obviously, my old script needs to be upgraded but I can't figure out how to address a table in MS Access in Office 2010.
First, there are no window titles so I don't know what to enter to use WaitWindowOpen. I tried recording my keystrokes and playing that recorded macro but I get an error saying the window is not open and the window doesn't open even if I have it already open and sitting minimized.
Can someone tell me how to find the window name to use?
MS Office 2010
Moderators: Dorian (MJT support), JRL
hello
Sorry. Spent time working on possible solutions. Thought I had one, made this post, then realized not really.
edit....
I installed Office 2010 and ran Access. Then I used getwindowlist and it showed a window name of "Microsoft Access" What window has no-name?
edit....
I installed Office 2010 and ran Access. Then I used getwindowlist and it showed a window name of "Microsoft Access" What window has no-name?
Windows 7
PepsiHog. Yep! I drink LOTS of Pepsi (still..in 2024) AND enjoy programming. (That's my little piece of heaven!)
The immensity of the scope of possibilities within Macro Scheduler pushes the user beyond just macros!
PepsiHog. Yep! I drink LOTS of Pepsi (still..in 2024) AND enjoy programming. (That's my little piece of heaven!)
The immensity of the scope of possibilities within Macro Scheduler pushes the user beyond just macros!
Thanks for trying...
I got some clues from support and finally got my script working again today. For those of you trying to work with Access 2010, here's what I discovered...
Access allows you to name your database. That will be the name you will use to address the window.
The easiest way I found to load a table is to make a macro in access and then create a shortcut on your desktop or make a hotkey. The script calls the shortcut or the hotkey.
You must setfocus on the database and then setfocus on the window (table)you want to use each time you want to use the table. I found that even accessing the clipboard required me to refocus on the database and table windows.
Hope that helps someone else...
I got some clues from support and finally got my script working again today. For those of you trying to work with Access 2010, here's what I discovered...
Access allows you to name your database. That will be the name you will use to address the window.
The easiest way I found to load a table is to make a macro in access and then create a shortcut on your desktop or make a hotkey. The script calls the shortcut or the hotkey.
You must setfocus on the database and then setfocus on the window (table)you want to use each time you want to use the table. I found that even accessing the clipboard required me to refocus on the database and table windows.
Hope that helps someone else...
