File browse dialog box....

[Red Devil]

I have a field in a form to which I wish to be able to browse to a particular PDF file. This location is then to be a hyperlink that when clicked upon, it will open the chosen file.

I have seen a thread already for file browsing, but it said to look at the VBA code, which I have no idea what it means

Please help, this is driving me mad.

TIA

RD

 

[lessthanme5]

Example

This is an example database which you can use to get this function...

I hope it helps.

 

[ghudson]

I have seen a thread already for file browsing, but it said to look at the VBA code, which I have no idea what it means
RD

You need to view the code in the modules. All VBA [Visual Basic for Applications] code is stored in the modules. Forms and reports have modules specific to that object then there are standard and class modules. They all look the same but they are not and they are located in differnet places. You have to go into the design mode of the object to then get the View Code option to see the VBA in a form or report. You have to go to the modules tab to see the standard and class modules and then you click the design button to get inside.

Search around for there is a lot if info on what you want and how to learn more about modules [Subs & Functions].

My Browse [Find a directory or file] sample is pretty easy to use and incorporate into your db but you have to understand how to create and edit a Sub routine and I am guessing that might be beyond your skill level since this is your first post. But I might be wrong so go for it. Post back with "specific" questions if you get stuck.

 

[reaperman70003]

I'm sorry for dragging up an old post, but this sounds pretty much like what I want to do in my database which hyperlinks to scanned documents. Note that access is far from my primary job, and I got drafted into this having gone years since my last database or class on the subject.

the example browse code works fine when I try it, but seems a bit over my current level of knowledge to get it working for me. (I get lost figuring out what tbHidden is)

But I notice that since the field type is 'hyperlink' I can get a pretty useful browse dialog up by pressing ctrl+K. Is there an easier way I can just make a button that sets focus to the appropriate form field and presses ^K without having to figure out the logic involved in the browse code? Or just calls the insert hyperlink browse dialog a different way.