Query designer window object

  • Thread starter Thread starter R Avery
  • Start date Start date
R

R Avery

Access 97.

I have the following problem: I design many queries by example, and
resizing the query design form and resetting the form's splitter is very
frustrating. Is there any VBA object that represents the designer which
I can manipulate to accomplish these mundane tasks programmatically?

Any help would be most appreciated. Thanks.
 
Is it sufficient to get your example query correct in terms of size and
layout, then save it ? New queries based on that saved query will have the
same layout.

The size and layout is probably stored in one of the system tables, and I
suppose you could manipulate that, but you might have to do some searching
to find the right tables and fields.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
I believe I found it in the MSysObjects table. There is an LvProp
field. There are also an Lv and LvExtra field. But they only say "Long
Binary data". What is inside these fields? Even after I get all the
hex codes out of there, how do I then set the particular properties I
want, given that many of the characters will be non-printable?
 
If its binary data, I would say you might as well forget that approach. It
could be encoded in any of a trillion ways.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top