MS Office 2010

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
dseibold
Newbie
Posts: 15
Joined: Mon Mar 06, 2006 7:13 pm
Location: Stockton, CA
Contact:

MS Office 2010

Post by dseibold » Tue Sep 27, 2011 3:25 pm

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?

User avatar
PepsiHog
Automation Wizard
Posts: 517
Joined: Wed Apr 08, 2009 4:19 pm
Location: Florida

hello

Post by PepsiHog » Sat Oct 01, 2011 8:36 pm

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?
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!

dseibold
Newbie
Posts: 15
Joined: Mon Mar 06, 2006 7:13 pm
Location: Stockton, CA
Contact:

Post by dseibold » Mon Oct 03, 2011 8:39 pm

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...

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts