Resizing or scrolling in Query Wizard screen

rbuser

Any plans to add resizing to this wizard form or at least horizontal scroll
boxes on the table and field list boxes. My end users complain bitterly that
they can not see the full name of fields in the wizard. My only suggestion
at this stage is to use the Query Designer instead. Is there anything I
could do to implement resizing in the short term?

Regards,

Jarrod.

rbuser

Build your own Query Wizard form and register it via ppRegisterForm. Most
likely somebody at D-M has a demo you can use to get started. Pretty much
all windows in report builder can be replaced with custom ones. There is a
tech-tip on the tech-tip newsgroup under the category General called
Replacing Built-in Dialogs/Forms in ReportBuilder that will help you.

Jim [Not Team DM or anything else official]

nicocizik

Hi Jarrod,

I happened to create a demo of this earlier this week. This is a custom
query wizard that has horizontal scroll bars for the list boxes. Hope this
helps. Simply unzip the file, add it to your project and rebuild.

http://www.digital-metaphors.com/tips/CustomQueryWizard.zip

--

rbuser

Thanx to all for your responses.
Greatly appreciated.

J.

rbuser

This solves one problem, but creates another. I would be willing to
lose the Multiselect features of the listboxes, that is not a very big
deal. But by having to turn off the Listbox.Style being equal to
lbOwnerDrawFixed, one loses the 'graying' out of tables that are not
eligible for joining if the autojoins feature is turned on (a great
feature).

Sigh. Looks like I might spend some weekend time looking at the
geometry of this form and trying to make it physically bigger.

Also, it looks like the label for the Available List and the Selected
List is always 'Available Tables', for both listboxes and for all pages
(fields, group by, etc). A user pointed this out to me recently, and I
was really surprised that I had not noticed this.

--
Bob McClintock

nardmoseley

I received your corrections - thanks for sending them along.

There is actually an existing patch available for the issue related to the
captions. This is something that was formerly working and was broken when
mods were added to fix issues related to XP theme support.

--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com