Synchronise 2 Continous forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zoran_K - 30 May 2007 16:41 GMT

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.

Reply to this Message

Peter Hibbs - 30 May 2007 18:45 GMT

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

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20D
emo.mdb'

for some examples.

Peter Hibbs.

>I hope someone can help me.
>
[quoted text clipped - 12 lines]
>Any idea I can link these 2 forms to synchronise vertical scrolling.
>Any kind of help is greatly appreciated.

Reply to this Message

Zoran_K - 31 May 2007 14:23 GMT

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.

> A Flex Grid Control will probably do what you want. Have a look at -
>
[quoted text clipped - 20 lines]
> >Any idea I can link these 2 forms to synchronise vertical scrolling.
> >Any kind of help is greatly appreciated.

Reply to this Message

Peter Hibbs - 31 May 2007 16:29 GMT

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.

>Hello Peter,
>Thanks for your reply. I'm having trouble opening this syte, always have
[quoted text clipped - 29 lines]
>> >Any idea I can link these 2 forms to synchronise vertical scrolling.
>> >Any kind of help is greatly appreciated.

Reply to this Message