• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

Show Student Records with Picture in Grid format on Form

Dear Experts,

I know this question has surfaced here a couple of times and the answer is a bit over my head. But my users 'really' want to all students displayed in a table grid format on the form at one time. Right now I have the students display on a continuous form like in the sample database I uploaded here. When I do this only the top three students show up each time. I would really like to create a form that displays 'all' the students at the same time with a button that can click to a student details form (like in the sample I provided). The initial display form does not have to have any data entry. It only needs to display student record data. The data entry can happen in the details form.

Given the sample database that I provided is it possible? and how would I go about doing it. Thank you!
test-DB.accdb
0
shogun5
Asked:
shogun5
  • 3
  • 3
1 Solution
 
als315Commented:
Look at my article Images on continuous forms
I have tested this solution with 20 images
0
 
shogun5Author Commented:
Thanks but this article shows how to display images on a continuous form. I am already doing this in my test db above. What I need to do is to display the images in Grid format like this:
student grid
0
 
als315Commented:
There are no standard meand in Access to create such form. You can try to use 3-rd party tools like grid controls or use subforms.
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
shogun5Author Commented:
How could I do this in subforms? Is there a reference on the web I can learn from or can you post here?
0
 
als315Commented:
Test this sample (unpack all to any folder and run). IDs should be sequental and It is fixed to 4 columns. Image file name is: ID.jpg
ImagesGrid.zip
0
 
shogun5Author Commented:
Awesome! Thanks! I can work with this.

Cheers!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now