Change Hyperlink Default Folder

[Learn2010]

I have a database that users will be adding hyperlinks to. First, they will add the documents to a directory. Next, they will open the database to connect this to the appropriate record. They will open a form where they will type in a description in a text field. Then, they have a hyperlink field where the link will go. The simplest way I have found to allow them to do this is as follows:

Right click on the Hyperlink field.
Left click on "Edit Hyperlink."

The next step is to navigate to the appropriate folder. How can I get it to open to that folder instead of the folder where the database resides?

Thank you.

 

[Uncle Gizmo]

Are you using:- "Application.FileDialog" ?

More info here:-
https://access-programmers.co.uk/forums/showthread.php?t=110161

Origin Northwind

 

[Learn2010]

No. I just have a text box with Hyperlink as the data type. As I said, the instructions to this point are:

Right click on the Hyperlink field.
Left click on "Edit Hyperlink."

Then it opens to the folder where our front-end database is located. That is different for each person as we each have a front-end. The folder I need is one step up for all users.

 

[Tieval]

The simple answer is that you cannot easily do it. The right click on textbox logic is pure microsoft.

In order to do it nicely you have a lot of coding to do.

 

[Learn2010]

Thank you for your help. Right now I needed something simple.