Access 2003 runtime version and shortcut menus

[NielsE]

I have developed an application and packed it into a runtime version.
However, in the runtime version the shortcut menus do not work. The reason why I want the user to have that possibility is that the application has two hyperlink fields and it is much easier for the users to be able to browse to the documents instead of typing each link with all the errors that might give as well.
Any help would be appreciated.

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

Browse [Find a directory or file]

The Access runtime does not give the user the full functionality like the retail version of Access has. You need to create custom toolbars if needed. Better to just make custom command buttons and then program exactly what the user needs to do.

 

[NielsE]

Geeting an error

Thank you very much. This seems to be very helpful.
However, when I try to apply it I get an error.
I have used the code for the Browse button in the "fFindOpenImportFile" form, but the code stops at varFileName=tsGetFileFromUser and I get the following error message: Compile error, sub of function not defined.
I have to admit that my coding knowledge is very rudimentary, at best.
Niels

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

Browse [Find a directory or file]

The Access runtime does not give the user the full functionality like the retail version of Access has. You need to create custom toolbars if needed. Better to just make custom command buttons and then program exactly what the user needs to do.

 

[NielsE]

Cannot update bound control through browsing

I solved the problem and got the both the browsing and openfile buttons to work.
That means that it works fine when the control where the path appears is an unbound control. When I make the control bound (I need to store the path value in a table) I get the following message:
-2147352567 -This Recordset is not updateable.

How do i solve this problem?

 

[ghudson]

Are you storing the \path\file as text?

Post an example of the \path\file string.