 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / September 2006Use VBA to create a graphic from a picture in a table
I have a table with a field defined as "OLE Object" which is populated by .JPEG images that were pasted into the database, rather than a link to an external file. My question is if there is a way I can write code to take that image in the OLE field, and create a .JPEG file, name it and create a directory file. > I have a table with a field defined as "OLE Object" which is > populated by .JPEG images that were pasted into the database, rather [quoted text clipped - 3 lines] > in the OLE field, and create a .JPEG file, name it and create a > directory file. Have a look at this : http://www.lebans.com/oletodisk.htm It looks to me like it probably does what you want. If not, there's bound to be another sample on Stephen's site that does.  SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Thank you. I will have to study this. This DB is doing what I want, but I notice that he uses a .DLL. I haven't traced the code through, so I don't know what the .DLL does, if it's necessary for this to work, or not. I hate to use a .dll that I don't know about, and that I haven't had permission to use. I'll get back when I've had more of a chance to study this. It's amazing what you've remembered! > > I have a table with a field defined as "OLE Object" which is > > populated by .JPEG images that were pasted into the database, rather [quoted text clipped - 10 lines] > It looks to me like it probably does what you want. If not, there's > bound to be another sample on Stephen's site that does. The DLL in question contains my routines for handling Structured Storage. It is very difficult to work directly with Structured Storage from VB but straightforward from C++, hence the DLL. A quick GoogleGroups search on my last name will show you that: 1) I'm a Microsoft MVP 2) I have been posting to theses NG's for the last 7 years 3) Thousands of people use my code every day SignatureHTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. > Thank you. I will have to study this. > [quoted text clipped - 23 lines] >> It looks to me like it probably does what you want. If not, there's >> bound to be another sample on Stephen's site that does. I wasn't questioning whether it was safe for me to use your code, I just wasn't sure if it was proper to do so without permission, I'm working on a project for hire. I can see where my response could be misinterpreted. It was late at night, and my usual terseness was not tempered by normal civility. Thank you for your website, and for all your help. > The DLL in question contains my routines for handling Structured Storage. It > is very difficult to work directly with Structured Storage from VB but [quoted text clipped - 32 lines] > >> It looks to me like it probably does what you want. If not, there's > >> bound to be another sample on Stephen's site that does. Hi Margaret, all of my example source code, and the main Web page on my site state that you are able to use my source code in your own apps, whether personal or commercial, without cost or aknowledgement. SignatureHTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. >I wasn't questioning whether it was safe for me to use your code, I just > wasn't sure if it was proper to do so without permission, I'm working on [quoted text clipped - 45 lines] >> >> It looks to me like it probably does what you want. If not, there's >> >> bound to be another sample on Stephen's site that does. Stephen: Margaret's concern may be that some companies (such as mine...) do not allow DLLs to be added unless they know the source. Unfortunately, I doubt very much that I'd be able to convince our company to use one of your DLLs: it's pretty much a standard policy that they don't allow freeware! SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Hi Margaret, > all of my example source code, and the main Web page on my site state that [quoted text clipped - 52 lines] >>> >> It looks to me like it probably does what you want. If not, there's >>> >> bound to be another sample on Stephen's site that does. Hi Doug, I've made the source code available to several organizations exactly because of "security concerns" including a couple of banks and NASA of all places. But I don't release the source code as a rule. SignatureHTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. > Stephen: Margaret's concern may be that some companies (such as mine...) > do not allow DLLs to be added unless they know the source. Unfortunately, [quoted text clipped - 58 lines] >>>> >> It looks to me like it probably does what you want. If not, there's >>>> >> bound to be another sample on Stephen's site that does. It's a moot point where I work, Stephen. Releasing source code wouldn't make any difference to them (although I suppose I could get away with it if I "created" the DLL myself as part of an application). I don't blame you for not releasing the source code. You need some magic, don't you? <g> SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Hi Doug, > I've made the source code available to several organizations exactly [quoted text clipped - 6 lines] >> your DLLs: it's pretty much a standard policy that they don't allow >> freeware! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.