Solved

Show Student Records with Picture in Grid format on Form

Posted on 2016-08-29
6
34 Views
Last Modified: 2016-08-30
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
Comment
Question by:shogun5
  • 3
  • 3
6 Comments
 
LVL 39

Expert Comment

by:als315
ID: 41775065
Look at my article Images on continuous forms
I have tested this solution with 20 images
0
 

Author Comment

by:shogun5
ID: 41775500
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
 
LVL 39

Expert Comment

by:als315
ID: 41775751
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:shogun5
ID: 41775753
How could I do this in subforms? Is there a reference on the web I can learn from or can you post here?
0
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 41775811
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
 

Author Closing Comment

by:shogun5
ID: 41777262
Awesome! Thanks! I can work with this.

Cheers!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now