Limiting Continuous Form Records

[andy_25]

Hi all,

I have a database with a continuous form based on a query. The problem I have is that the database includes images and therefore the continuous form is loading very slowly.

What I would like to do is limit the view of results so that I only see 5 records at a time and have a button to see the next 5 which will allow me to click through all the records.

Does anyone know how this can be done? I am really struggling with it at the moment and have searched for information but cannot find any. If someone could help I would be really grateful.

Thanks.

 

[gemma-the-husky]

why not refrain from showing the image - but make a single image available to a click on a relevant textbox/label placeholder.

offhand, i cant think how i would make a continuous form behave in the way you suggest

 

[andy_25]

Thanks for your input dave. Yes the clicking idea would speed it up and has been suggested however the user is not happy with that approach.

The only way I can think of doing it at the moment is to add 5 subforms, move to the appropriate record on load and then have a button which makes the subform recordset +5 each time.

Any other ideas? I'm not sure what you make of that approach but I can only think of fudging it at the moment.

 

[scalextric59]

What is the size of the pictures? Reducing the picture dimensions does not reduce the picture size. Try to have the pic size as small as possible, probably around 20k. That should speed up the display

 

[dcb]

I love challenges like this:
Have a look at the attached

Note query behind the forms data
Have a look at the code behind form_open
Module that indexes the records to create the limit

I have commented the code in the module as much as my little fingers would allow, however let me try and explain the mindset

The records behind a form are not limited therefore if we have a column in the table that does this like a FK it would give us a means to limit the data coming in (I called this SubNumber):

Table
ID | Data | Data | SubNumber
1 | | | 1
2 | | | 1
3 | | | 1
4 | | | 2
5 | | | 2

To create this I have a function that loops through and sets the SubNumber it then returns the highest set

In the form query i link a unbound txtBox to SubNumber

Then shift this number in the txtBox up and down with a requery on each move - Of course you could make this a ComboBox of page Numbers - Would give a really pro feel to it....

Enjoy

 

[andy_25]

scalextric59 - The user was copying a pasting images from Excel which were inserted from a digital camera (thankfully not a very good one). The source files were just over 1MB therefore I presume it was copying the full image into the database with some bloat. It was this that was causing it to scroll very slowly. Optimising them in Excel 2007 and reinserting them has made things a lot quicker. No support for image optimisation in Access? I can't find any.

dcb - Thanks a lot for your effort, I may be calling upon this if the user encounters anymore problems. They have got another 1000 records plus to add so it may be required. I will enjoy having a play around with it.

 

[Simon_MT]

Andy,

If these are OLE bitmap objects they are going to be bloated. Office 2007 does store them images in their native formats i.e. jpeg. I have 16,500 images averaging 40KB.

I don't use continous forms with images but I concur with Dave use a Click or Double Click on the Record and the image is displayed - I use a pop-up.

Simon