Page 2 of 2 FirstFirst 12
Results 16 to 23 of 23
  1. #16
    LadyL is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2015
    Posts
    32
    Yes I will fix the picture property once everything is working thanks .
    No it is in single form view.

  2. #17
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    What is it you intend to do to 'fix' the picture property? Why continue dealing with picture property?
    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. #18
    LadyL is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2015
    Posts
    32
    Well I will remove it once all of the code is working properly, I need to deal with one problem at a time since I'm not so great at coding

  4. #19
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Yes, but isn't it the Picture property that is keeping things from working? If just using ControlSource property resolves issue, why keep playing with Picture property?

    Yes, deal with one step at a time. Is the FileDialog code working? Can you navigate to file and save name into record? Get that working then deal with how to display the image.
    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.

  5. #20
    LadyL is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2015
    Posts
    32
    Well yes all of the code works, and it saves the path to the picture. However when I move the database to a different computer, including the file structure and the pictures (in the same folders) I get the error that it can't open the images.

  6. #21
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Step debug. Follow the code as it executes. Where does it fail? Is the GetPath function returning correct string?

    Refer to link at bottom of my post for debugging guidelines.
    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.

  7. #22
    LadyL is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2015
    Posts
    32
    Well it seems to return the correct string, it just does not update it when the form is opened. It will ask for the image in the old location. How do I update this when opening a form?
    Also it seems to ask for an image that is not even in the database! When you click on Skeletmateriaal or Sporen it will ask for pictures while the tables are completely empty! How can this be? I want to include my database but packed it is 2.1 MB and it won't let me upload....
    If you could help I'd really appreciate it!

  8. #23
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Make a copy and remove what is not needed for this issue. Include just a few records for testing.
    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.

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

Similar Threads

  1. Replies: 2
    Last Post: 03-11-2015, 07:13 AM
  2. Browse to import *.txt or *.xls files into table
    By Dirtpics in forum Import/Export Data
    Replies: 2
    Last Post: 06-18-2014, 10:25 AM
  3. Browse for excel files and append to Access table.
    By newbieX in forum Programming
    Replies: 5
    Last Post: 01-27-2014, 07:10 PM
  4. Button to Browse for File!
    By floyd in forum Forms
    Replies: 5
    Last Post: 08-23-2013, 09:09 AM
  5. Creating a Browse button to create a Hyperlink
    By detaylor1242 in forum Forms
    Replies: 5
    Last Post: 07-30-2013, 11:48 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