Showing Multiple Records on a Single Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello people.

I've got a small problem i can't think of a solution, and i got no real
answer on any forum i posted.

So, the situation is the following:

I need to show ten records on a single form, at once. Let's assume each
record is an Image. I'd like to show ten of these on the form, and, when i
click the 'next record' button, it shows the next ten records. Can i do this
in access? How?

thanks for the replies.
 
Mr C,
I take it you're referring to a "main" form, rather than a subform.
Make the main form "continuous" with a height that will show ten recs per screen.
Create your own Next and Previous Buttons that use the Offset argument to move the
recordset +/-10 at at a time rather than just one.
ex. DoCmd.GoToRecord , , acNext, 10
DoCmd.GoToRecord , , acPrevious, 10
 
COntinious forms are ugly, and won't work in this case. Suppose I want to
show the images like this:

X X X X

X X X X

X X X X

each 'X' is an image, which has a different record. How do i do that?
 
Not that I'm aware of.
Forms (unlike reports or "printed" forms) are unable to display "columns."
The only way to display the setup you require (one one form) would to have Pic1 thru
Pic12 fields included in one record.
 
Create a fixed grid of image controls.
Get the data using an ADO recordset in code.
Load the image data into the image controls in code.
Use 'paging' to limit the number of records to the number of image controls on your form, and page through
with 'prev'/'next' buttons.

You can see examples of this in the samples below, along with code listings. These illustrate the approach
using our own image control, but the same technique should be possible with the built-in Access controls.


The technique is illustrated in this sample:
http://www.ammara.com/support/samples/showsam084d.html

A more full-featured implementation is available in this one:
http://www.ammara.com/support/samples/showsamf3bc.html

(note that a version of the above which stores the images in external files, rather than in tables, is
available on request).

--
_______________________________________________________
DBPix 2.0: Add pictures to Access, Easily & Efficiently
http://www.ammara.com/dbpix/access.html
 
Back
Top