[AccessD] Word form to Access form

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



More information about the AccessD mailing list