Questions about docmd.runcommand acCmdEditHyperlink

1.  Is there anyway to make this return full path names instead of relative path names?
2.  Is there anyway to disable the ability to hyperlink to objects other than files?

I have been trying to work around problems with using this command by attempting to develop my own window for managing hyperlinks, but, because of the way events are handled in Access, this has created more problems.   Thus I would be open to any other control available that would substitute for this command if, particularly, the second issue cannot be addressed.

sjl
LVL 1
sjlevine34Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

stevbeCommented:
www.mvps.org/access/api/api0001.htm has code for the open file dialog and you can specify what file types are allowable by setting the Filter property. You could then take the returned string (which is ful path to the file they selected) and write that to your table.

Steve

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sjlevine34Author Commented:
This is the way I will go, then.  I actually have a similar program from Litwin's Access 2002 handbook.

Is there any way to add a field for hyperlink title and screentip to this dialog box?

Also, Litwin's dialog box does not insert file into pathname field when you double click on it.  Can this be remedied.

sjl
stevbeCommented:
I also use Access Developer's Handbook ... that code uses the windows api to call the open file dialog and there is no way to add fields for Title and Tip to your form or have a second popup form as for these 2 fields. You could also go back to your original copde and then parse the reurn value to make sure they seelcted afiel and to parse the relative path back into a full path but that will be a fair amount of code.

Steve
sjlevine34Author Commented:
Thank you very much.

Your recommendation plus a little reading in Litwin produced a very acceptable result using the File Open common dialog box.  I even have the Open  button reading "Select". (straight out of Litwin).

Thanks again

sjl
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.