Results 1 to 7 of 7
  1. #1
    Reda2 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2015
    Posts
    3

    Form locks up when opening file in bound object frame

    I have a form that the user uses to enter the customer details such as Name, address, etc. One of those fields are an ID scan, now when they have scanned the image I want the user to be able to insert it into the form, so I used a bound object frame in the form and the user can copy and paste the file into that, that works perfectly and the icon of it shows on the bound object frame.



    The problem I'm having is when the user double clicks the bound object frame to view the scanned image, it opens but then when you close the image the form is locked, it does not respond to any mouse clicks or anything, the bound object frame just has diagonal lines across it. View image below to see what I mean, the image below shows how it ends up and I can't for example press on textboxes or even press buttons.




    Does any of you know why this is happening and how I can fix it?
    Any help is appreciated, thanks.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    I was not aware that Access allowed copy/paste into Object Frame. Exactly what is being copy/pasted - the file from Windows Explorer? This Object Frame is bound to OLEObject field? I tested all this and yes, get the behavior you describe. However, I am able to X close the form. I check the table and doesn't show anything in the OLEObject field. I reopen the form and nothing shows in the Object Frame. I don't think really can use copy/paste. Right click on the Object Frame > Insert Object > Create from file > navigate to file.
    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
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    alternatively don't store the image in the db, just the path to it in a text field then set the controlsource to your image control be the field which contains the path

  4. #4
    Reda2 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2015
    Posts
    3
    Quote Originally Posted by Ajax View Post
    alternatively don't store the image in the db, just the path to it in a text field then set the controlsource to your image control be the field which contains the path
    How can I do that?

  5. #5
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    as stated - store the path (e.g. C:\images\someinage.jpg) in a text field e.g. call it imagepath (as opposed to an image in an OLE Object field)

    then bind your image control to the text field (by setting the controlsource to the text field - e.g. imagepath)

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    I've never used OLEObject field or Object Frame control. Suggested options:

    1. store image in Attachment type field

    2. store in text type field, file path to external image

    In both cases, bind Image control to the field. See post 6 in https://www.accessforums.net/forms/c...tos-55375.html
    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. #7
    Reda2 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2015
    Posts
    3
    Quote Originally Posted by June7 View Post
    I've never used OLEObject field or Object Frame control. Suggested options:

    1. store image in Attachment type field

    2. store in text type field, file path to external image

    In both cases, bind Image control to the field. See post 6 in https://www.accessforums.net/forms/c...tos-55375.html

    Thank you very much, I could not have asked for a better solution, again thank you.

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

Similar Threads

  1. Bound Object Frame
    By bigguy in forum Forms
    Replies: 4
    Last Post: 04-15-2015, 03:14 PM
  2. Replies: 1
    Last Post: 05-30-2012, 03:51 PM
  3. Bound Object Frame Combo sorted Results
    By kevsim in forum Programming
    Replies: 7
    Last Post: 01-08-2011, 06:30 PM
  4. Replies: 2
    Last Post: 10-18-2010, 07:53 AM
  5. Replies: 1
    Last Post: 08-05-2010, 12:11 PM

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