Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2011
    Posts
    11

    Unanswered: Drag and Drop an image to a form

    I hava a DB that handels orders I receive by soft-fax.
    Then I enter all the data from fax order to my DB and I need to have also the link of the fax that is stored as an image .tif in a folder on C:/ so when i need to check I will be able to open the fax.
    I will appricaite your help.
    Just to make my self clear I am working in two different monitors.
    One is displaying the fax image from which I am entering the data and at the other one I have my access form.
    I need to drag and drop the image on that form and save the path as a link in my DB.
    Here attached an example of what I am doing.
    I can D&D an image to a text box and save it as a hyper link.
    The only problem is that I can't preview it in the form, I can only clik it and open it as an image.
    Last edited by john_gringo; 01-20-13 at 07:49.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    Are you useing msaccess as the data entry
    To do what you want will beover you head in coding

    Think u need to keep it simple first.

    I would do something like

    Store the tif in a folder c:\faxfiles
    Then have a feild in the database that hold the tif name as we know the tif folder name
    Then you can use a loadpicture c:\faxfiles\[feildnameindatabase]
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Nov 2011
    Posts
    11
    Just to make my self clear I am working in two different monitors.
    One is displaying the fax image from which I am entering the data and at the other one I have my access form.
    I need to drag and drop the image on that form and save the path as a link in my DB.
    Here attached an example of what I am doing.
    I can D&D an image to a text box and save it as a hyper link.
    The only problem is that I can't preview it in the form, I can only clik it and open it as an image.
    Attached Files Attached Files

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Drag and drop isn't something that is in built as a standard behaviour in Access
    As Myle has already suggested it can be done but isn't straightforward
    YOu may well be better off using VB which does support drag and drop nativley and store the data in, say a Jet database
    https://www.google.co.uk/#hl=en&tbo=...w=1511&bih=916
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Nov 2011
    Posts
    11
    Quote Originally Posted by healdem View Post
    Drag and drop isn't something that is in built as a standard behaviour in Access
    As Myle has already suggested it can be done but isn't straightforward
    YOu may well be better off using VB which does support drag and drop nativley and store the data in, say a Jet database
    https://www.google.co.uk/#hl=en&tbo=...w=1511&bih=916
    Don't know if you see my example.
    I manage to D&D the simple way, but it stored as a hyper link.
    My issue is that as I try to add a Preview box as in northwind the hyper link is not working.

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    sorry I don't use macros, so Im nto going to spend time looking at what you are doing
    but my impression is that you highlight a FaxLink column, then presws a button to open up a child form Fax

    what I think you need to do is use an image control instead of a text control in Fax
    set the image source to the URL to the required image from Form1!FaxLink
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Nov 2011
    Posts
    11
    Quote Originally Posted by healdem View Post
    sorry I don't use macros, so Im nto going to spend time looking at what you are doing
    but my impression is that you highlight a FaxLink column, then presws a button to open up a child form Fax

    what I think you need to do is use an image control instead of a text control in Fax
    set the image source to the URL to the required image from Form1!FaxLink
    Am I using macros?
    Don't know I am new to access
    Thanx for the reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •