Arthur Fuller
fuller.artful at gmail.com
Fri May 25 14:59:00 CDT 2007
I am working on an app wherein a Word form exists, all nicely laid out as the client wishes to see it and print it. I don't think that it is a real Word form but rather a mockup. The central problem is, the form is in landscape mode and if I duplicated it identically in Access, it would end up with a vertical scrollbar. I don't like this. One click too many is one click too many, IMO. So I am trying to rationalize their Word-portrait form against my Access portrait form -- the latter requiring a vertical scrollbar. I don't like this aspect of the scenario. Second: Given Word form xyz with field locations bla bla bla, is there any way to conveniently reproduce said form in Access, other than measure the distances and duplicate them in Access? It would be so nice to point to said Word file and grab the control locations and re-create said form in Access. I don't think that this can be done. Oh Well. The alternative is to print out the Word form and begin measuring the x,y distance of every control and go from there. There ought to be an automated way to re-create the Word form in Access, given that the Object model is identical from both perspectives, but so far I cannot see my way from A to B. This problem generalizes in a problematic but very cool way. There is an editor in which you can write a line such as "x = CreateObject(" ADODB.something)" and said editor automatically grabs all the attributes and methods of said library. I would love to have a script that prints out the classes, nested classes, and so on unto the leaves for the selected library. For example, I create a FileSystemObject called fso. In several editors I can then IntelliSense the methods and attributes, but there is no readily apparent way to dump said (nested) list to a text file or XL sheet or whatever. I want to point at an arbitrary DLL that exposes methods and attributes, and grab all its internal dox into an Excel or Word file. Anyone got any guesses how to do this? TIA Arthur