473,406 Members | 2,312 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Save OLE object from within Access as .otm File

78
I have a new project that I am working on. Actually just more advanced within the same project.

I have the need to carry a .OTM file along with my program in order to have access email through outlook properly in Access 2003 systems.

My intention, and the way I have it setup now is the I have a hidden OLE object on my form (Which is the .OTM file). I now have it set up to make visible then copy...

Here is the problem. I can not get it to copy to the folder. I know which folder, how to call it, etc.

What I really want to do is export the .OTM (without opening it...Since this seems to make it not work properly.) to the proper folder as the proper name. I have it packaged and opening package manager the save as...Works without a problem. ALso, manually copy and pasting the object from Access to the correct folder works as well. HOW DO I AUTOMATE IT??

Any help is greatly appreciated as always. If anyone wants to see the code I have please just ask. I didnt feel it useful since the steps I need I have no code for.

Thanks Again.

Nick
Sep 17 '08 #1
5 2398
FishVal
2,653 Expert 2GB
Hello, Nick.

What about storing the files as BLOBs.

Regards,
Fish
Sep 17 '08 #2
nspader
78
Hello, Nick.

What about storing the files as BLOBs.

Regards,
Fish
Fish,

It is not an image...Will it still work? The file is from Outlook vba. It is VbaProject.OTM, Basically a .txt file but not quite. DO you think this would still work?

Thanks,
Nick
Sep 17 '08 #3
FishVal
2,653 Expert 2GB
Fish,

It is not an image...Will it still work? The file is from Outlook vba. It is VbaProject.OTM, Basically a .txt file but not quite. DO you think this would still work?

Thanks,
Nick
Nick.

BLOB (aka OLE in Access) field simply stores a large array of bytes.
No matter the way array was obtained and what it does contain.

BLOBing files (no matter what they are) is so common procedure that ADO lib from version somewhat about 2.5 (don't know exactly) supports Stream object to make it as easy as possible.

As for the article - it was mostly all about rendering stored images on form which is far more tricky task then simple file uploading/downloading.

Regards,
Fish
Sep 17 '08 #4
nspader
78
Nick.

BLOB (aka OLE in Access) field simply stores a large array of bytes.
No matter the way array was obtained and what it does contain.

BLOBing files (no matter what they are) is so common procedure that ADO lib from version somewhat about 2.5 (don't know exactly) supports Stream object to make it as easy as possible.

As for the article - it was mostly all about rendering stored images on form which is far more tricky task then simple file uploading/downloading.

Regards,
Fish
Sorry for the late reply. That worked perfectly. Thank you for your assistance with this issue.

Nick
Oct 1 '08 #5
FishVal
2,653 Expert 2GB
You are welcome, Nick.

Best regards,
Fish
Oct 1 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Colleyville Alan | last post by:
I have been working on an Access app that takes info from a file and writes it to a spreadsheet on a form, simultaneously saving the spreadsheet to Excel. I got the idea that the same concept...
0
by: beau | last post by:
Please help me ! Anybody can help me with a code to embed an ms word file into an access table ? I have ms word templates with bookmarks in my hard disk. So far I can open the template...
2
by: Greg | last post by:
looking for an easy way for users to browse for a file on their local drive, and then have access automatically make a copy of that file (files will most likely be images) and save it under a new...
4
by: Carl Williams | last post by:
Hope someone can help with this... I have looked at all the newsgroup articles and put into practice all the suggestions but to no good. I am pretty new to CSharp and .Net so any help would be...
8
by: david.lindsay.green | last post by:
Hello all, I am quite new a web scripting and making web pages in general and I have stumbled across a problem I have as yet been unable to solve. I am trying to take the contents of a textarea box...
6
by: Josetta | last post by:
Access 2003 I've been experiencing some problems with my "monster" database the last couple of days. I imported all objects into a new database yesterday, which pretty much stopped the crashing...
3
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this...
3
by: evenlater | last post by:
I have an Access application on a terminal server. Sometimes my users need to export reports to pdf, rtf or xls files and save them to their own client device hard drives. They can do that right...
2
by: cleary1981 | last post by:
Hi, I have created a script in PHP thats generates an SVG image. Want I want to do is have PHP save this as example.svg. Can this be done? Heres my code <?php require "config.php"; $proj_id =...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.