Hi Ken, I'm not sure what you mean about the reloading of a .set file has been a problem in MS Access for years? You can get around this, if you need to, by replacing the access .set file with your own, or by hooking the event which tells you when a set file is loaded, and then reloading yours if it's the right window. Mostly though, others make changes in their apps to the individual settings of the current set file, and set the scope of these changes to be local so they don't accidentally end up being saved as part of the default global .set file if the user should save a change. There was a scripting class which covered the scope feature of settings in a set file which should help you do this. just like the loading of a set file though, you'd have to hook the event which tells you when a set file is being loaded, so you can make these changes again if it's the right window to do so. Or I guess you could save the .set file after you make your changes once (I haven't looked into whether that's possible or not to do). hth, Chip
_____ From: Scott, Ken [mailto:[email protected]] Sent: Friday, October 07, 2011 2:31 PM To: '[email protected]' Subject: RE: loading a set file; was Scott's question Chip, Thanks again. I did check the developers reference but missed the section that you noted. I think that the overlap or top level requirement is going to kill my original idea. I am aware of the multiple loading of the same set situation. This has been a problem in MSAccess for years. Ken From: Chip Orange [mailto:[email protected]] Sent: Thursday, October 06, 2011 6:50 PM To: [email protected] Subject: loading a set file; was Scott's question Hi again Scott, check the developer's reference manual, in the window object, in it's methods, and you'll find a method named LoadSet which loads a set file. It says it's only usable for overlap (or top level application windows), so it may not work for your situation; and if the window becomes inactive (say, a user changes windows for a minute), then your set file won't be loaded when they return to the window, so you'll need to load the set file each time this window becomes active. hth, Chip _____ From: Scott, Ken [mailto:[email protected]] Sent: Wednesday, October 05, 2011 1:10 PM To: '[email protected]' Subject: Three Issues/Questions for Scripting Window-Eyes with Microsoft Access 2010 Database Program Hi gw-scripting list members, I am attempting to improve the usability of the Microsoft Access 2010 database program with Window-Eyes. I am not a programmer of any kind let alone an object oriented one. I have done some analysis of the Access 2010 and Window-Eyes combination. I also listened to all of the podcasts and read all of the documentation that I thought applied to what I am trying to do. I am left with three issues/questions. One thing that I am trying to do is to automatically maximized the Access 2010 windows. The problem is that I am getting two object.classnames for what appear to be the same object depending on what analytical tool or approach that I use. If I use, Gw Micro's Window Manager to check on classnames for objects, I get one result. If I use the Object Browser in Chip Orange's Microsoft Word based development environment, I get another Classname. For example, in Window Manager there is a OTable classname, whereas, in the Object Browser, there is a table classname. Can anyone suggest which version of the object classname that I should try first when scripting to maximize the windows? The second problem that I am having is determining the syntax to load set files based on off screen events. I plan to use the presence of Access window objects plus view button status to load set files. My first issue. What is the property/method to load a specified set file? I did write GW Micro Support asking about this situation. I was told about the window.loadset object. Unfortunately when I check the Window-Eyes developer reference, this object appears to tell if a set file is loaded and not to load a set file. Second, what is the syntax for using an accessible string as part of an operation. I can find a long string that gives the name of a view button and its pressed verses unpressed status in my analysis. I do not know how to write this into an operation. My tentative idea for a syntax is something like: If window.classname = OTable and Datasheet view status = pressed then loadset.TableDatasheetView. If anyone can suggest how precisely the above hypothetical operation should be written I will be forever in your debt. The third area of trouble is in reclassing a custom control. If I understood the Window-Eyes developer reference correctly, I need to use the type object to reclass the object. I will need to first use the retrieve property to place the custom control into my script. I then need to use the set property plus the type to reclass the custom control. If the custom control is okttbx and need to be reclassed to an editbox, what would these operations look like? If I have confused you, please send me any follow up questions that you have. Regards, Ken Scott
