Results 1 to 7 of 7
  1. #1
    TMCgames is offline Novice
    Windows 8 Access 2013
    Join Date
    Dec 2014
    Location
    Belgium
    Posts
    4

    Talking Access insert image "spam"


    Every time I change the picture of an image using vba, the image gets saved in the tab "Insert Image". So every time I want to click on Insert Image, it takes 30 seconds before it loads all the images. As example, I have an image called Potato and I change his image frequently. Whenever I open Insert Images, it starts with 1_Potato going to 250_Potato. Is there any way to stop this "spam"?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Changing the image where? In an Image control? I am confused, if you are changing image with VBA, why is manual "Insert Image" involved?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    TMCgames is offline Novice
    Windows 8 Access 2013
    Join Date
    Dec 2014
    Location
    Belgium
    Posts
    4
    Well, whenever I want to add a new image to my form, it takes a while to load all the images that show up in the Insert Image menu. The problem is that the images are all just copies of one image... And I don't know why it is making copies.

  4. #4
    TMCgames is offline Novice
    Windows 8 Access 2013
    Join Date
    Dec 2014
    Location
    Belgium
    Posts
    4
    Click image for larger version. 

Name:	Help.png 
Views:	10 
Size:	117.1 KB 
ID:	19070This is the problem

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    I still don't know what you are doing. Why are you frequently changing or adding images to form?

    You can manually delete images from the gallery list.

    Or clear records from system table MSysResources.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    TMCgames is offline Novice
    Windows 8 Access 2013
    Join Date
    Dec 2014
    Location
    Belgium
    Posts
    4
    Maybe this is a better example. An arrow that changes direction when you click a button. The button makes the picture change to another picture. This causes alot of copies from that image in the "Insert Image" tab. I can delete them like you told me to (which works, thanks for that), but is there a way to stop this duplication? It isn't a problem in this example, but in my situation, I have around 6000 duplications. This slows the form down alot when it gets loaded. Thanks alot for helping me already
    Click image for larger version. 

Name:	Helpp.png 
Views:	8 
Size:	101.3 KB 
ID:	19072

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    AFAIK, none except don't BROWSE to the same image that is already in the gallery. But you say the images are being added because of the code?

    I've never used code to set Picture property. I use ControlSource property of Image Control.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 7
    Last Post: 11-08-2013, 08:28 PM
  2. Replies: 6
    Last Post: 10-17-2013, 03:47 PM
  3. Replies: 2
    Last Post: 11-14-2012, 04:47 PM
  4. Insert a ".mdf" database into Access
    By Philosophaie in forum Access
    Replies: 4
    Last Post: 08-28-2012, 01:11 AM

Tags for this Thread

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