I know you can attatch multiple items to each record but (example for my use Pictures) however it only shows one of the attatchments
I would like to know how to go about displaying or navigating all the photos (main pic then left and right buttons to scroll through attatchments)
The Database I am trying to create is to organize my 100's of Hot Iron Transfers (one part of my DB) and my 100's of Sewing Patterns and in future thousands of Embroidery files.
however, for instance, my Sewing patterns i would like to include many views of the pattern (the front, back, and if available finished items) now some have only 3 pictures and others may have upto 10 pictures maybe more. It would be nice if i could scroll through or view each picture some how without having to open the dialog box if i were to add several different attatchment fields then the pcitures would be too small to be useful .....
or is there some way that i coulld maybe have several thumbnails that when clicked show in the main attatchment (a larger) field ?
again will mention that i am kinda new to access since the last time i took access was in 1997 using Office 95 in college and i haven't used it since then so am really foggy on how it all works anymore ..... I am also using Access 2007 so there is a 12 yr gap between builds haha so am sure things have also changed since i last used access haha
i've tried searching online for video tutorials for what i want to do but have come up blank (mind you after searching googles 10th page and not finding what i want i give up and try a new search word lol ) been seraching for hours and am getting frustrated ... I really want to figure this out .... I am usually a fast learner but for some reason there is so much confusing info out there that after searching i end up more confused than before i started searching haha
Any help /ideas very appreciated
Below is what i have now .... but there are 6 pictures to this pattern alone and it would be nice if maybe to the left of the large photo that i could have thumbnails where if i click it would expand to the larger frame... or a set of navigation buttons so i can scroll through the photos in the one large frame
![]()