Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    islandboy is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    63

    How to Display Images in a Form or in a Report Without Storing the Images in a Table

    Hi guys,

    i have a problem linking a picture without needind to bound it into the database.

    i got some VBA codes but i can't get it to display the picture.

    hope i get it solved thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Larry has three approaches demonstrated in his download. Perhaps they will give you some ideas.

  3. #3
    islandboy is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    63
    thanks for the quick reply, but can you assist me with adding the as external files? because as you know am not that good with the codes.

    tell me which one is better to have the pictures external or embedded in the DB?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I prefer my pictures external to the db.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by islandboy View Post
    ...because as you know am not that good with the codes.
    The only way to get better with code is to use it as much as possible. You have no external pictures with your sample db. Are they already internal?

  6. #6
    islandboy is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    63
    no i don't have any pictures added yet..i was only testing the db OLE but i don't like it the way it works.

    can you could add some sample pictures and check it for me.

    thanks in advance

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you looked at the Employee form in the Northwind sample db? It displays pictures as well.

  8. #8
    islandboy is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    63
    Quote Originally Posted by RuralGuy View Post
    Have you looked at the Employee form in the Northwind sample db? It displays pictures as well.
    i check the db, but this db is using the attach option on my db doesn't give me that option.

    have you check my db and see if i can use something to display the picture?

    thanks mate.

  9. #9
    islandboy is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    63
    Quote Originally Posted by RuralGuy View Post
    Have you looked at the Employee form in the Northwind sample db? It displays pictures as well.


    RG you can't help me on that one?

  10. #10
    islandboy is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    63
    RC thanks for the help but it seems i didn't link the link with the Image option on Access 2007. now that i linked it works.

    The only problem that i get now is that after inserting a picture it takes you to the first record..how can i prevent that???

    thanks.

  11. #11
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Good, you are making progress. What are you doing to "insert a picture"?

  12. #12
    islandboy is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    63
    Quote Originally Posted by RuralGuy View Post
    Good, you are making progress. What are you doing to "insert a picture"?

    If you have download mt db you will see the "Add Image" button that i have on the Employee Table form.

    I think i have a problem there when it adds the picture...but i can't see where.

    hope is that what you asking.

  13. #13
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    A Requery takes the RecordSet back to the 1st record. I see no reason for the Requery anyway.

  14. #14
    islandboy is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    63
    Quote Originally Posted by RuralGuy View Post
    A Requery takes the RecordSet back to the 1st record. I see no reason for the Requery anyway.

    ok..but can you tell me where i can remove that request?

  15. #15
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    From your "Add Image" button code.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Newb- Trying to use images and such.
    By TriAdX in forum Access
    Replies: 3
    Last Post: 08-18-2009, 10:07 AM
  2. Images per record, database form OCX
    By lochie360 in forum Forms
    Replies: 3
    Last Post: 07-26-2009, 03:50 AM
  3. Images in report
    By rudyp in forum Reports
    Replies: 1
    Last Post: 03-24-2009, 09:51 PM
  4. Access Report and embedded images
    By joypanattil in forum Reports
    Replies: 0
    Last Post: 11-22-2008, 03:50 AM

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