Saving file location - please help!

[ac512]

Hello

I am using Microsoft Access 2000 on Windows XP.
Is there any way that I can save a document file location so that I can
refer to this in the future?
Basically, I would like users to click a button prompting them to select a
relevant document, and when they do this, I would like to save the document
location in my Access database, so that I can use this as a hyperlink at a
later stage?
Is this possible?
Any help/advice/suggestions would be greatly appreciated.

Regards
AC

 

[pietlinden]

Hello

I am using Microsoft Access 2000 on Windows XP.
Is there any way that I can save a document file location so that I can
refer to this in the future?  
Basically, I would like users to click a button prompting them to select a
relevant document, and when they do this, I would like to save the document
location in my Access database, so that I can use this as a hyperlink at a
later stage?
Is this possible?
Any help/advice/suggestions would be greatly appreciated.

Regards
AC

use the FileOpen API from Access Web. It's the first article in the
modules section. Then just strip off everything to the right of the
final /. then just stuff the value into a custom property.

 

[ac512]

Thank you for your prompt response.
I had a little 'play' with your suggestion, and although it worked OK using
Access 97, when I endeavoured to apply it to my Access 2000 database, I
received numerous error messages.
Any suggestions?

Thanks very much in advance
Kind regards
AC

 

[pietlinden]

Thank you for your prompt response.
I had a little 'play' with your suggestion, and although it worked OK using
Access 97, when I endeavoured to apply it to my Access 2000 database, I
received numerous error messages.
Any suggestions?

Thanks very much in advance
Kind regards
AC

Could you be more specific? That's like going to the Doc and not
telling him exactly where it hurts. Error messages? Lines it's
crashing on? Code you tried?

 

[ac512]

The error messages I receive when I endeavour to open the 'frmExplorer' I
downloaded from the Access Web are as follows (in this order):

- The expression On Error you entered as the event property setting produced
the follwoing error:
User-defined type not defined.
*The expression may not result in the name of a macro, the name ov a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

- 'fListFill' may not be a valid setting for the RowSourceType property, or
there was a compile error in the function.

- The expression On Error you entered as the event property setting produced
the follwoing error:
User-defined type not defined.
*The expression may not result in the name of a macro, the name ov a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

- The expression On Open you entered as the event property setting produced
the follwoing error:
User-defined type not defined.
*The expression may not result in the name of a macro, the name ov a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

And the form does not open

Thank you
Kind regards
AC