Results 1 to 2 of 2
  1. #1
    Xeonni is offline Novice
    Windows 8 Access 2007
    Join Date
    Apr 2017
    Posts
    4

    Question about adding and viewing multiple attatchments per record

    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
    Click image for larger version. 

Name:	sewpatexample form.jpg 
Views:	12 
Size:	173.9 KB 
ID:	28265

  2. #2
    Xeonni is offline Novice
    Windows 8 Access 2007
    Join Date
    Apr 2017
    Posts
    4
    OH and i know that pcis i've posted are not the greatest ..... I am working on funtionality of the database right now not the visual part of it ... I will be messing around with the way everything looks AFTER i get it working the way i want while i was learning how to make the Preview Report button i had deleted and redid the form many times haha after the first 2 times of making it look nice and pretty i gave up and decided to just get things working first then worry about beautifying it lol

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 12-16-2016, 04:31 PM
  2. Multiple entries to one record without adding new field?
    By Yamilet in forum Database Design
    Replies: 7
    Last Post: 06-01-2013, 04:22 PM
  3. Replies: 34
    Last Post: 09-20-2012, 07:02 AM
  4. Show all attatchments in report
    By white2golf in forum Reports
    Replies: 3
    Last Post: 07-30-2012, 12:25 PM
  5. Replies: 6
    Last Post: 07-02-2012, 02:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums