Synchronise 2 Continous forms

[Zoran_K]

I hope someone can help me.

I'm building continuous form with about 30 columns displaying some store
information and performance.

Form is too long and I would like to freeze Store column so that Store
column always stay visible on left hand side when I scroll horizontally. I
know I can do this using Datasheet view, but I would like to display data in
Continuous view, because all field’s headings are actually buttons that user
can sort application on that particular column.
I tried with 2 continuous forms inside main form, on one form I have just
Store Name and on other form all other columns, and it is working like charm
horizontally but when I scroll down vertically (There are almost 200 stores)
it is not working at all, it is not connected
Any idea I can link these 2 forms to synchronise vertical scrolling.
Any kind of help is greatly appreciated.

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

 

[Zoran_K]

Hello Peter,
Thanks for your reply. I'm having trouble opening this syte, always have
kind of error message.

In the Toolbar I found "Microsoft FlexGrid Control, version 6.0" but when I
try to place it on the form I have message that I don't have licence
required to use this ActiveX control.
Anyway, once again thanks for your help.

 

[Peter Hibbs]

Hi Zoran

If you can find a copy of Visual Studio 6 or Visual Basic 6 and
install that then you will automatically get the License.

Alternatively, try importing one of the forms from the demo database
into your project and then modifying the form and code to do what you
want. Make a back up first though, just in case.

HTH

Peter Hibbs.