Access Tip: How to Use Images and OLE Objects in your Database
ฝัง
- เผยแพร่เมื่อ 6 มี.ค. 2010
- See my NEW video in IMAGES: 599cd.com/Images
How to work with images (pictures, graphics) in your database using OLE objects. Also, how to work with external images WITHOUT embedding or linking them into your database. This will save lots of space in your database. Learn more at www.599CD.com/?XY2WDR
![[TH] VCT Pacific Stage 2 - Playoffs Lower Bracket Final // PRX vs DRX](http://i.ytimg.com/vi/5HwO1bQyAx4/mqdefault.jpg)
It really baffles me, that people can be rude. Especially, that we are getting these tutorials for Zero cost.
These rude people should rather go pay for a course and then get there answers.
To you my Dear Sir, thank you for these video tutorials and the time and effort spent in providing us ungrateful people.
Thank you again - you are a life saver for me.
Yusuf
That's up to you. In my full ACCESS IMAGING SEMINAR, I show you how to set up a global variable in your database so you can tell the system where all of your images are, like in \\SERVER\Database\Images - that way if you want to move your images folder, you just change ONE variable. All you store in the table then is the filename without a path.
Thanks for the compliments. I don't recommend storing images (or other files) directly in your database just for this reason. That's why at about 2:20 in the video, I explain how you can store the images in a FOLDER on your computer (or server) and just save the FILENAME in your database.
Thanks so much for taking the time... I think this is going to having me up & running in no time!
This video rocks!!! Thanks so much for this workaround on keeping our database size in check with images. We are using this for our new Social Media approval workflow.
You are very welcome. Glad you enjoyed! Also see my new video: 599cd.com/Images
Thanks for your videos! May your life be long and blessed.
Thank you, you are very knowledgeable. Your classes must be worth it.
Great tutorial! I only use Access from time to time, this really helped me.
Thanks
What do you mean by the "On control?" As far as dealing with a large database goes, you have two options, SPLIT your database into smaller files, or EXPORT the images and other large attachments and deal with them as external files. I have lessons on my web site to deal with both of these issues.
Can you view the objects directly from the table?
You can have one image per FIELD. You could have multiple fields per record if you want (like if you know you need to store 3 images for an employee). I recommend making this a second, related table if it's more than 2 or 3. You can also use the ATTACHMENT field type to store as many images as you want, but I don't recommend storing too many images IN your database. It's better to store them on a server and store the path/filename.
Great videos, thanks for providing them. I am following this video in Access 2013 and am having no luck getting the pictures to appear. Off the top of your head do you know if there is anything different in Access 2013?
Don't let them bother you. You do a great job. Thanks.
Thats awesome. I just created a database and have included images but i could see how it was going to bloat the Db.
Lucky iI only just added this function so it's easily changed. Brilliant. Brilliant.
Hello,
I am a relatively new access user (I had been using filemaker previously). I was just wondering how I could add multiple pictures in this way using the code example you used in this video
Thanks
Thank YOU for the support. It looks like the poster of the original "complaint" removed his own comment. I'm very happy to help people with these free tutorials, and 99.9% of the feedback I get is very positive. But, yes, there are some people who are just never happy with anything... even if it's free.
Great videos, thanks for providing them. I am following this video in Access 2013 and am having no luck getting the pictures to appear. Off the top of your head do you know if there is anything different in Access 2013?
Disregard this. I can't believe it took me 3 days to figure out I wasn't putting the .jpg after the file name.
this is awesome. Thanks so much. You've made this so simple!
Great videos Richard, thank you so much. This may have been previously addressed, but will this set-up work as a webpage?
Great vids! Very clear and easy to understand. Can I ask a question - I have an old 97 db that I upgraded to 2010. The OLE fields in the table don't display anything (15,000 records). Is there a way to access these old objects in a form and still be able to add and view new images (pdfs)? Thanks in advance.
is there a way to use a online image via the image URL to then embed into the form picture? and would you store the URL in the table as a hyperlink or text
Thanks for these great videos!!! One question: if I leave the EmployeePicture field empty in the form of one of the employees I get an error message. Is there a way to leave this field empty in certain records without receiving the error message?
Hi. I'd like to do your second step but I wish to use relative paths. How do i do that?
Very good tutorial thanks. I have one question can I import same picture in excel from access. is it possible or any way out for this.
hi 599CD, thanks for your videos. I was able to create forms now with the pics. I tried the continuous form. Do you also have videos to print a form plus the picture. also, how do I copy a picture from linked object? Thanks in advance if you find time answering this.
I save in my database .zip file path and I want to write a query to retrieve it. What is the suitable type that I can use to retrieve .zip from my DB?
all thumbs up to the best Richard. thanks Richard
Very welcome
The CurDir function could get me my current location no? For example: CurDir ()&"/images"&image.jpg
Very nice lesson. My question is there any way to enlarge or reduce the picture on once on the form.
Also how do you handle pdf.
Thanx
Just what I was looking for - thanks very much!
Can you use c# code instead of vb?Thanks for this video.
Thank you for the tutorial. This really helped me wtih my church project database I was working on. Thank you again
Welcome
I like this i sorta could of saved me a little time, but i'm trying to do it for power point slides. i have 36 to 40 slides. is there a way you can help me out with this? i would be greatly appreciated.
hey thanks a lot. your tutoriols are really helpfullllllll...............may god bless you for doing this kind work.
Yes, I'm sure it's possible. Just save the picture from your Access field to a file and then import it into Excel. If you're looking for an AUTOMATED solution to do a bunch of them, that would require some VBA programming.
Hi, Thanx for the most helpful tutorial, very generous of you. I did this, and then I went to use it in a doc that I send ou email. The pics do not go with it as a PDF? I understand how this could happen, is there a way to do this also?
Appreciate your tutorials.
thanx
Steve
Thank you so much for your videos. They have been a LIFE SAVER for my team/company. I have one question though...
I have been linking many photos to the database using this method, and now my database is very large (30MB). Is there another way (and maybe you have a tutorial?) to link the photos rather than insert them? I need them linked to an excel spreadsheet. Thank you so much. I really appreciate the videos!!!
What if the 'On Current' tab is unavailable in Access 2010? What's its equivalent?
First, I would like to say thanks for all the information that you have put out on TH-cam! Also,everything that I have tried so far has not worked either but, I am not giving so easy and I definitely appreciate all the information you have displayed so far. I have Access 2003 with 2007 Upgrade. Using the embedded OLE option it only displays an icon of my image program on my "Forms". However, all my date is linked correctly and only way to view my image to double click on it and package in table
Thanks of your prompt Reply. If Picture in Access and MS SQL (OLE Type) and I want to import Picture and related data into excel. is it possible?. I'm using Adventurework sample data and I Want to import Product details data along with their pictures. Is it possible?
@biswajit6600 This is a little too complex to go into detail with here. I do cover how to do this, however, in my full Access Imaging Seminar.
Can you OLE or associate more than one picture per record? Can Access be told to look for more than one picture and then be smart enough to put as many pictures associated with that one record on the form or report?
thank you so much for your support and help .
Welcome
Dude...truely an awesome video. Thanks! I am having a problem with my database. I am trying to embed the pictures into a table instead of linking them from a server or local drive. For my data type, I created an OLE Object field in the table I want to embed the pictures in. When I try to embed the pictures, it says "Package" instead of "Bitmap Image", even though the files I'm trying to embed are .BMP files. Do you know of a way that this can be fixed? Thanks in advance.
i noticed that if the new record has no link attach i got error every time i scroll my form....please shed some idea how i rectified this error..
Thank you. I'd like to think they're worth it. I've priced them quite reasonably considering the amount of material I cover. :)
How do i store an image in Access 2010 and retrieve it netbeans?????
thanks alot man this help me out heaps at school :)
ton of thanks for this video
Do you have a video for how to link videos in Access 2016? It used to use the Windows Media Player ActiveX control, but that isn't even in the list. ..??
Personally I don't like trying to put videos in Access.
OnCurrent is not a tab. It's an EVENT that you can find in the PROPERTIES for the FORM.
Thanks for this video it's helped me out alot
Welcome
Hi Steve, Any chance you might have any tutorials on electronic signatures?
Nope. Sorry. Not yet.
use the "Web Browser Control" in the form control and set the url in the wizard to a text column in a table that has the URL for the image your after
i like this lesson it would have saved me a few burning the mid night oil's, but anyways how can i do this with power point slides? i have 36 - 40 of them. but the slides dont stay on there the while time because another set of slides get uploaded on there. like every week. these slides are only for there rest of my company to view. unless you can think of an easier way to do this. maybe save the slides as a picture but then if you save them as a picture then you have like 36 - 40 pictures.
Mr. Richard,
thanks a lot for the nice topic.
I have a question if you do not mind: I am using MS Office2016, and I would like to link the MS Access with MS Word in "mail merge".
I have a format in MS Word it is contain:
Employee ID: 1234, Mobile:1234657 and Employee "Signature".
I did so far all steps, but I stuck in Employee signature it shows "1234.jpg" instead of employee signature.
how can I solve this issue?
Still stuck? Feel free to submit your question at 599cd.com/TH
Hi Ad, can you show me how to input automatically employees images path with follow employees ID as employeespicture name. All picture of employees save in local/sever folders with name of images is EmployeesID, I don't know how to do it? Looking for answers son..
I cover this in my Access Imaging Seminar: 599cd.com/XRSHNZ
Great video and easy to understand. Can other users have access to the pictures as long as it is stored on the server? Database backend is SQL Server 2008
Sure. As long as they're in a shared folder. I show how in my Imaging Seminar: 599cd.com/Imaging
Do you know of any way to iterate through attachments of the attachment field for display in the attachment control. I have tried various vba methods and it seems the attachment collection is missing this functionality. I have an attachment field with a jpg and a pdf for each record. I tried to use the Attachment.FileType as a means to select the PDF from the field and send it to the control, but there doesn't seem to be a way to do it. I have not seen one article on the attachment field which covers iteration of values.
I can send attachment.FileData to the control, but it only displays the first attachment in the ARRAY? Collection? The MSDN information is almost useless except for how to add or delete an item from the field.
I get a ton of questions every day, and I don't have time to answer them all here on TH-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
I get a runtime 94 error when trying to do this.
Is there a way to do this for queries? I understand it only works for tables as I cant seem to this for my union query.
Do what?
Hi Richard its me again Ricky..why is it i got an error after i finish scroll my form till new record for my form the error is Run-time error 94 Invalid use to null..and the last photo from the record is still show even i make a new record already..
I have created a data entry form with Subject line (Text), Email Body (Text) and an Ole Object box in which I paste the screen shot. Now on save button click, data gets added to the table and also drafts an email with the same subject line and email Body.
***CONCERN I am facing with the ole object IMAGE, which I want automatically to be in the email body below the text. Is there any way to do so, if not then any alternative or suggestions?
This technique may work better. Haven't tried it with emails yet though: 599cd.com/Image
When I type the code I cannot get the .picture property. I type FIELDNAME then the dot but PICTURE is not displayed as a property. I am using Access 2010
See 599cd.com/Images
I am trying to create a database where one particular record has multiple picture documents. This example here- Will this work and maybe to just attachment multiple images in one record ? Im trying to create a receipt database where one vendor has multiple documents ... Can you help?
See 599cd.com/Images - that's a newer, better method
I works but everytime I try to open the form it gives me a Run-Time rror '94': Invalid us of Null, any ideas on how to solve this?
599cd.com/Trouble
Hi, I would like to insert an image in the FORM header .
I'm very sorry for taking so long to reply to your comment. I wasn't very good at keeping up with the comments 4 years ago, but I've been trying to make an effort to get back to everyone. If you still need help with this problem, please feel free to submit your question on my web site at 599cd.com/TH.
Hi, I can achieve this on a form but not in a report? Is it possible to achieve the same effect for a report in access 2013?
Greetings
Use this method: 599cd.com/Images
Can I insert multiple images (3-5) in one single field using a relationship from another table. So, that one table includes numerical values that correspond to different images from another table (relationship?).
No. You never put multiple anything in a single field.
Hello Sir, Thankyou so much for your educational videos.
I have a question, may please answer it.
I have a table with "ID" as "Autonumber", and "Img" as "attachment". I have a "textbox" in a report that contains "ID". I want to display "IMG" in the report corresponding to that "ID" in the table, is that possible?
Sure, but don't use attachments. See this: 599cd.com/Image
I would need to know more about how your database is set up, but this is not the appropriate place for such a conversation. Feel free to contact me privately or via my web site.
My images won't show up at all when I do this with any image type. It just says the image name and opens the image if I double click on it in the table. Why does it do this?
Hi , i am getting the icon instead of the picture in my form. Please advise? Thanks.
Watch newest video: 599cd.com/Images
So in this video you used the image control as unbound control requiring the code to assign it to the image control but in another video you use it as bound control using EmployeePicture as the data source. Which is more efficient?
See 599cd.com/Images
Thank you very much.
You're very welcome.
When I follow the instructions and then put the image into the OLE box all I get is a tiny notification of a jpg.
See 599cd.com/Images
I have Access 2013 and it is not working. I have to right click it in FormView and select "Insert Object" and do what you did. But when I click OK, there is no picture, only an icon (and it is not set to "set as icon" or "link"). What am I doing wrong or does 2013 not allow you to see the image for some reason? Thanks!
See newer video: 599cd.com/Images
@yan2292008 Sorry, no. Microsoft Office doesn't support C#, only VBA.
if i had a dollar for every pixel in the laptop picture i'd have 75 cents
Bahaha
Spent so much time trying to get this done and then i found your video. Thank you so much.
1 question, what do you do if you have a record without a picture?
I'm getting a Run time error '94' :
Invalid use of Null
I modified the VB code to be this and it seems to work:
If Not EmployeePicture = vbNullString Then
EmployeeImage.Picture = EmployeePicture
Else
EmployeeImage.Picture = (none)
End If
Proper way to do it is probably to check if the input is a valid path but I don't know enough about VB to write that.
I modified the VB code to this and it's working:
Dim TestStr As String
TestStr = ""
On Error Resume Next
TestStr = Dir(EmployeePicture)
On Error GoTo 0
If TestStr = "" Then
EmployeeImage.Picture = (none)
Else
EmployeeImage.Picture = EmployeePicture
End If
Source: Modified from the Test if File exist code @ www.rondebruin.nl/win/s9/win003.htm
599cd.com/Images
Hello! sir how can we instantly change the pic when i choose the different path of pic?
599cd.com/Images
I tried to enter the VB code exactly as shown in the Tutorial above. But I get Run Time Error 2220 - have checked the file path etc. what do I do?
See new video 599cd.com/Images
I cannot view anything regarding the pictures in the actual tables. No picture, no path...the field in the db shows absolutely nothing...I think the file names might be derived somehow. I figured out a way to derive them myself, but at this point I haven't figured out how to tie it all together! It's my first attempt at code.
Can I do this over a ShareList? I do not have a server location
Nope
anyone ?
i need help problem my newsystem... i can't display the picture in my report
See the updated video: 599cd.com/Images
With reference to the method not using OLE, can anyone please advise on how Windows long folder names should be written when putting them into the field eg c:\My Documents\fred.jpg - how do you include the space in My Documents?
Nothing special to it. In a field that is short text datatype the information entered is a string value and will be interpreted as though you wrote "C:\MyDocuments\fred.jgp" If you are grabbing it from a text box as in the video it is the same.
what he said
HOW CAN I ADD LOGO IN REPOT AS VARIANT THAT I ACOULD CHANGE
Change the control source of the image object.
This only works if you display one row at a time. If you using list format (multiple rows), then each row displays the image of the current row.
Right, that's what I just commented on. In continuous forms to see all the images you would need to use the image control bound to the field containing the image path. It depends on the application. In one of my databases I use a datasheet subform and on the current event I have it refresh the image box using code to match the record I am on. In this case the images take up too much space on the screen so I can display multiple records in the datasheet and only need to see the image on the record I am currently editing. Of course using it as a bound control you are covered all the way around.
See the new video: 599cd.com/Images
I can get the image to show up when i actually have an image in the folder. But if the field is blank because there is not an image i get this error message. Run-time error. Invalid use of Null.
Can you give me some advice?
The easiest way is to put a default picture in as a placeholder on the field properties of the Table. Otherwise you can add a line of code to the event ending the sub if the field is null. There is an example on the website for the advertised course.
See new video: 599cd.com/Images
id like to dysplay in webpage with mysql and access ole object
Looks like you need a MySQL tutorial. That ain't me. :)
Hi Richard great tutorials . I have tried to do what you show in this tutorial but for some reason it does not work . Im using 2007
See updated video: 599cd.com/Images - and upgrade to Access 365 :)
Which video covers the full images seminar on your website? The link is dead, search on your site did not find it and it looks like you have rolled up a lot of knowledge in the course I see.
I found it.
Here's a new one: 599cd.com/Images
@@599CD We ended up producing an access DB, here in LA for a secret facility that processes crime photos for abuse victims. Replaced a very old system. I am starting to build out something like it for Veterinary Practices for the same reason. Just to access old photos with a new computer. Super helpful buddy.
I followed your instruction to the T and i get an error 2220 can't open
Use this new technique instead: 599cd.com/Images
How do I get the picture to display in my form, there's just an icon symbolising there's an image. My form is based off a table.
hi, did you get an answer for this? i am also getting the same result. Thanks in advance!
See new video: 599cd.com/Images
@@599CD Wow, 8 years later, i moved on from college and earn a salary in IT now hahaha, thanks anyway.
looks simple but its just not working for me, i cant even see images the simple way
Yep. That's one way to do it.
its really good
Yayaya
also with those pictures so they can just click through them.
not easily but it's doable but it'll be less of pain just learning VBA however VBA is a pain & a headache....
If you have a picture in Excel you could COPY and PASTE it into a field in Access, sure.