Is it possible to create a 'Continuation Form' (not a continuous f

[efandango]

At the moment, I have a simple form Continuous Form with 3 fields per line.
My problem is that the form (due to size restrictions) can only show 8 rows.
But I want it to show at least twice the amount, or more if possible; so is
there any way I can have a 'Continuation Form' where the first 8 records
appear on form 1 and the next 8 records appear on form 2, and so on...

like this:

Form1 Form 2
Record Data Date Record Data Date
1 info blah 9 info blah
2 info blah 10 info blah
3 info blah 11 info blah
4 info blah 12 info blah
5 info blah 13 info blah
6 info blah 14 info blah
7 info blah 15 info blah
8 info blah 16 info blah

does anyone know if this is possible, and how one could go about creating
them?, or would it be too much hassle maintaining integrity, if I were to
delete a record for example.




microsoft.public.access.forms

microsoft.public.access.formscoding

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.

 

[Mike Painter]

You will be far better off scrolling a continuos form.

 

[efandango]

I hear you Mike, the problem is that I need to see all the information
without having to scroll everytime I look at a new page of master records.

 

[efandango]

Peter,

I copied the 'MSFLXGRD.OCX' file to \Windows\System32 folder, but when I try
and use your form/s, i get error: Object doesn't support this property or
method.

any idea what's going wrong?

 

[efandango]

Peter,

it's ok, I forgot to actually register the OCX.

I will let you know how i got on with your app.

regards

Eric

 

[Dirk Goldgar]

At the moment, I have a simple form Continuous Form with 3 fields per
line.
My problem is that the form (due to size restrictions) can only show 8
rows.
But I want it to show at least twice the amount, or more if possible; so
is
there any way I can have a 'Continuation Form' where the first 8 records
appear on form 1 and the next 8 records appear on form 2, and so on...

like this:

Form1 Form 2
Record Data Date Record Data Date
1 info blah 9 info blah
2 info blah 10 info blah
3 info blah 11 info blah
4 info blah 12 info blah
5 info blah 13 info blah
6 info blah 14 info blah
7 info blah 15 info blah
8 info blah 16 info blah

does anyone know if this is possible, and how one could go about creating
them?, or would it be too much hassle maintaining integrity, if I were to
delete a record for example.

Are you talking about having thes two forms open side by side? I can
imagine doing it as two subforms on a single main form, with some moderately
complicated logic to ensure (1) that neither subform form shows more than 8
records (or some fixed number) and (2) that the second subform does not show
any record that is shown on the first subform. To accomplish this, it may
be necessary to create a query that numbers the records sequentially, since
you can't rely on autonumber fields to have no gaps in the sequence.

All of this would be non-trivial, but I bet it *could* be done. Is it worth
it?