Access 2016 - 7 - OLE, Attachment and Hyperlink fields - An introduction with just 2 tables

hi it's Navigant and in this video we are going to add an Ola field and we're going to add some icons to our company table I actually have just some images here and I have already copied and pasted my database table you'll notice the minute I open this the date and change I've labeled it that I'm going to add an Ola feel so we'll enable this content we'll go to our company table and at the moment we do not have any images in here so if we go to our design view and we add a table for logo and we're going to make an O L object so I can choose that one here I'm also going to add a field for teaching material so I'm just going to write Docs and I'm going to call that an attachment so I could do the drop down here just typing so an attachment so that I can attach documents to this and while we're here I might make a links field so that we can look at the hyperlink datatype as well okay so we've got three new fields if I want to view that it's going to ask me to save the table first and we now have extra fields here so that's telling me there are no documents attached to any of those fields at the moment all right now we I'm going to close that I want to show you what happens if we don't then I go into design view here I think it's going to not let me work so here's my company table it's got a subform for each of the calls for that company um I'll just there are that permit of their change my column size over here now my address fields are not actually going to be that wide so if I highlight I can if I highlight just that much I'll get one film if I highlight all of those all of those fields I can reduce the size of my address fields now I want to add in an image field for my logo so if I go around on the design view here and look for this image field let's put it in here okay if I want to move that label if I at the moment if I grab it somewhere like this I will move both fields control Z for undo but if I grab it at that top right hand corner I can move it up to there and I can call it logo to eat not that we really need a label for it because the minute you see the picture you're going to know what's going on now what will be my control sauce and it should be logo and I'm going to copy that and I'm going to put that as its name as well if I want to be a bit more precise I could call that olee logo and it gives me the type of field or image logo while we're at it let's add in an attachment field again that can be a box like this what it's going to contain is now I'm going to use the arrow keys to just move it up a little bit there it's going to contain an icon for Word or Excel or PowerPoint whatever our attachment might be so that will do and let's also add in a hyperlink field now that hyperlink I'm pretty sure that we're just going to do a normal text box like so hyperlinks tend to be long so I'm going to make this link and so just reduce that a little bit and bring this across here and control source here is going to be links and up here I'm going to have hy-vee links my control source here is going to be soda my control source there's going to be Doc's and this is going to be and of course I don't like an uppercase first letter so I'm going to change it to a write it tells me the types of fields and their names okay let's save that let's now go into our View mode and let's attach a load owner I've got some little logos here they are at the moment PNG files what axis will do is store this as a BMP file and it's pretty tricky the way that you put it in putting it in from here I'm not able to copy it properly let's just try and copy it from here if I go copy/paste it will not put it in it's just putting in a link like that so backspace control dude we're getting out of there delete yeah okay so what I might do is open it up in paint so open with paint and let's get it over here you'll see that whoops I'm going to just enlarge this to eight hundred percent so view zoom in and I don't really need to do that because I'm well I'm going to do is copy it ctrl C I could have copied it while it was small let's go back over to here my logo is highlighted - so my logo here is highlighted ctrl V now it will actually manipulate the file and save it in there as a BMP all right I actually have the video link to the playlist here so that can go in there and I have an attachment let's grab a file from somewhere at the moment here's a file link so if I click on attachment and I add an attachment and I browse for it let's let's go databases let's database one let's just add the core log and so that's okay now if I want to view this I'll move on to the next field it has no image and no attachment if I want to open that attachment I have to open if I had more than one attachment it would give me the choice so we've added images attachments and a hyperlink to our company table and therefore we're able to hold various types of information in our database thanks for listening

Channel: Nev Goodyer

Views: 54,732

Rating: 4.2982454 out of 5

Keywords: Access OLE, Access 2016, Access Hyperlink, Access Attachment, Adding images to Access, adding attachments to access

Id: Y8a11gVBLEU

Length: 9min 30sec (570 seconds)

Published: Sun Nov 13 2016