Video instructions and help with filling out and completing 8850 Form Ins

Instructions and Help about 8850 Form Ins

Hello everyone and welcome to programming in Access 2013 my name is Steve Bishop today's video is a how-to video and this particular topic is very common requests that I get from not only my youtube channel but also from some of the forums that I frequent and this particular question comes from Katey sin Lau and he asks can you show me how to display PDF files in an access forum and that's a very good question a lot of times what we want to do is display the contents of a file to our users actually within a forum and luckily for us there is a special component there's a special control that we can put on our forms that allows us to display just about any type of file including PDF files and I'm going to show you the method of how you can do that today alright so let's go ahead and back out and go into our database and the first thing I'm going to do is going to go to the create tab and I'm going to create a new form and I'm going to go right into the design of the form I'm not going to do a wizard or anything now I'm going to make this nice and large because we're going to be displaying the entire contents of a phial and you probably want to make sure also that you making it large individuals that that the application may have because what's going to happen is when you open up a file inside of access access is not actually the application that's opening the file instead the default program the default application that is used to view that file will open up a window inside of your form so especially with PDF files you need to make sure that the user has some sort of PDF viewer application like Adobe Reader or Foxit reader which is I use Foxit reader for my PDFs so what we're going to do is we're going to first and foremost make sure that our form is nice and big it's got to be large enough so that the user can see everything on here and I'm going to go ahead and drop in a text box and this will become very important later I'm going to go ahead and name this text box or I'm going to give it a label here of file location okay and I'm going to move this over a little bit just make sure it's the right size and make that nice and wide here because this is actually going to display the full location on our computer where that file is that we are displaying to the user I'm also going to drop in a button here because what we're going to do is we're going to make this a nice dynamic and interactive form that allows the user to select a file and then display that file inside of our form so I'm going to go ahead and make this just say browse and finally the control that we're actually going to display the content in is the web browser control okay and that may sound like a little bit of a weird thing I don't really want to display something from the web on here but actually the web browser is a very very dynamic control that allows us to view pretty much any type of file both a web address or a location on our computer now before I get to this dialog box I'm going to go and cancel this for just for a moment what I need to do is I need to put some names on all of these controls so I'm going to go ahead and name my text box txt file location and then I'm going to make this browse button I'm going to change it to button browse and finally this web browser I'm just going to go ahead and call it let's say WB contents whatever you feel like naming it's perfectly fine this is just what I'm going with all right let me make this a little bit wider here just want to make sure it's fully viewable and a little taller okay all right so we've got all the controls I'm going to go ahead and minimum make this nice and big so I can see the whole screen here now what we're going to do is since we've got the text box named txt file location I'm going to go back into the data tab of my web of my web browser and I'm going to go to the control source and click on the ellipsis and we're going to get that insert hyperlink dialog box back open now here where it says Bay URL we can click on this ellipsis button and this will give us our expression builder and on our expression builder we can actually select the text box called txt file location that we created and I'm just going to go ahead and double click that and you'll see it just plops it right in there as the expression and I'm going to go ahead and click OK so now what's actually happening here is that the contents of the control the control source are actually directly linked to whatever we put up here in our file location text box okay so we're going to go ahead and click OK on that and now what we're going to do is we're going to set we're going to do some of the code on our browser button to make the contents of our text box to change the file location basically alright so let's go ahead and go to the on click event for our browse button and go to the code builder and the first thing I always do is I want to make sure option explicit is set up here

100%
Loading, please wait...