Results 1 to 2 of 2
  1. #1
    trevor40's Avatar
    trevor40 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    407

    Picture location using vba only

    Hi All,
    I have a minor issue with pictures, currently I'm using vba to set all pictures throughout my db,


    All pictures are set to (none) & Linked prior to opening the db
    This all works fine as shown below

    'OnOpen Me.Page1.Picture = DbPath & "DbIcons\jeep.ico"
    'OnChange Me.image_company_selected.Picture = DbPath & Me.selected_company + " logo.bmp"

    While going in/out of design mode, I see that the picture location actually updates to the file location and this is then saved with the form.
    E.G. Me.Page1.Picture = G:\my company name logo.bmp

    The same thing happens with option button captions.
    Me.option1.caption = Me.selected_company

    It does work ok until I change the location of the db. Then it can't find the pictures, because the location is now an actual location and when the form opens it says it can't find them.

    I guess if I have to that when I finish my design I have to set them all back to none.
    But will they revert back any other way?

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    well I definitely do not understand this phrase: "....because the location is now an actual location ...." but stepping back to the conceptual ; the path must be universal to any front end location on the LAN....you probably know that already, but it strikes me as essentially the issue at hand..... seems like it is presuming everyone maps G: drive the same....

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

Similar Threads

  1. Hyperlink Location
    By Mahendra1000 in forum Access
    Replies: 1
    Last Post: 09-26-2013, 09:00 AM
  2. Current Location Flag
    By mhankins in forum Access
    Replies: 2
    Last Post: 07-03-2013, 02:02 PM
  3. multiple location problem
    By gregd in forum Access
    Replies: 5
    Last Post: 04-10-2013, 09:35 AM
  4. Hyperlink with full location
    By desk4tbc in forum Access
    Replies: 0
    Last Post: 06-27-2011, 05:18 PM
  5. File Location
    By Mitch87 in forum Programming
    Replies: 1
    Last Post: 02-19-2010, 11:12 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