Results 1 to 12 of 12
  1. #1
    Join Date
    Apr 2008
    Posts
    189

    Question Unanswered: How to insert a picture in a Form via VBA?

    Hello,
    I'm looking for a way to insert a picture (to emmbed will be better than linking) a picture to a Form and also to an output Excel.

    Any ideas how to make the "picture insert"?

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Posts
    214

    ...

    On_Open
    Me.Form.Picture =

    Not sure how to stretch or embed the pic though.
    Also,not sure what you meant on the second part about excel?
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  3. #3
    Join Date
    Apr 2008
    Posts
    189
    Mm, thanks, but I need to embed the picture.

    Also and most important, I need to embed the picture into an Excel output.
    What I mean, is: I have created an Excel file where I populate with some data and I need to add to this Excel file a picture.

    Any ideas how?

  4. #4
    Join Date
    Feb 2004
    Posts
    214

    ...

    Are you wanting a picture for each record (OLE object) or just a picture for the form like a logo or something?
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  5. #5
    Join Date
    Apr 2008
    Posts
    189
    2nd option: like a logo. Actually, is a logo.

  6. #6
    Join Date
    Feb 2004
    Posts
    214

    ...

    I am unaware of a way to export that pic to excel. You can only export a table, query or a report to excel. Only a report can hold a pic and when you export to excel, it just exports the data.
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  7. #7
    Join Date
    Apr 2008
    Posts
    189
    OK, but maybe I can do some Me.Picture inside the Excel.

    Ideas?

  8. #8
    Join Date
    Feb 2004
    Posts
    214

    ...

    I am not sure if and how to add vb code to excel.
    There is an excel forum here you try and post a ? to

    Good luck
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    To put logos on forms and reports, you can just paste them there.

    I tend to put the image in a table and have a form that shows it. That form can be placed on other forms. Doing that means a smaller file size because there is only one picture.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  10. #10
    Join Date
    Apr 2008
    Posts
    189
    And have you got any ideas how to place that logo in an Excel file from the Access?

  11. #11
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    how often does the logo change
    are you pulling it from a file

    it may be better to ask your question ont he Excel thread rather thant he Access thread, as it seems the problem is in the Excel spreadsheet rather than the Access db
    I'd rather be riding on the Tiger 800 or the Norton

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by pepemosca
    And have you got any ideas how to place that logo in an Excel file from the Access?
    Nup.

    I very very rarely ever resort to using Excel.

    I'd assume you could just paste it there. Perhaps write a macro in Excel to do it and then call the macro from Access?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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