Ask Experts Questions for FREE Help !
Ask
    pamuka's Avatar
    pamuka Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Apr 8, 2009, 08:58 AM
    How to get a package object to open immediately w/o clicking on it?
    Hi
    I designed a database in Access 2007 and created a form.
    The field that concerns me contains a (.jpg) package object which opens in Paint.
    I would like this field to open immediately when I go to this record without clicking in the field. Is there a macro or anything else that would allow this to happen?
    Thanks:)
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Apr 8, 2009, 11:12 AM

    First I do NOT recommend using OLE Objects as they can cause bloating. Instead I recommend that you store the path to the image file in a text field. You can then use an unbound Image control and set the Picture property of that control to the path to display the image.

    But if you prefer opening the image in whatever is the default image editor/viewer, or a specific image editor/viewer then its simple. In the On Current event of your form use code like:

    Application.FollowHyperlink Me.txtImagepath

    Where txtImagepath is the name of the control bound to the text field. If you prefer to specify the Image editor, then you would first name the image editor exe and then the patch top the image. This may vary depending on the image editor.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Right clicking My Computer shows garbage for OPEN [ 3 Answers ]

Please advise. When I open My Computer, and right click on C drive, where OPEN should be at the top is foreign gibberish. It doesn't work. Nor does attempting to open the C drive by clicking on it: it asks what application I want to use to do this. I scanned with Norton Internet Security deep...

My drives are not opening by double clicking, and asking open with [ 2 Answers ]

My drives are not opening by double clicking, Instead of asking for open with

BMP file Inserts as Package instead of Linked OLE Object [ 5 Answers ]

I am trying to insert a bmp file as a linked OLE object. However, It gets inserted as a Packaged Object instead of as a Linked file. I am using Word 2003. Can Anybody Help?

ALWAYS open new window max in ie7 after clicking link [ 3 Answers ]

I don't mean F11 - fullscreen, I just want it to open as large as it can. I have tried to open a window, resize it to large then close it and reopen. Setting muse not be saved or something. Tried Tweak UI but could not find an answer. Dave

Access loads a bitmap into a OLE object as a package [ 2 Answers ]

My client has 3 aging Access 97 dbs that run the production floor of a large plastic manufacturing plant. These are in the process of being replaced by much more robust, professional grade manufacturing control systems. The client is investing millions in the new systems, so redesign at this point...

View more questions Search