Linking Multiple Word Documents on a Single Form in Access

[StarScream]

Linking Multiple Word Documents on a Single Form in Access

Scenario:
1. A user clicks on a button that opens a clean Word document (actually a hyperlink to a default word file previously saved). I want to be able to have Access save the information typed into the Word document automatically as a filename the user chooses. I don't want Access to save over the default word file because the user may need to save several files on the same form.

2. How do you have a user add several files to a single form? Can you have a button bring up the windows explorer file prompt so the user can select which file they want.

I need to make this as automated as possible, since most users are not very access or computer smart. I already know how to insert a hyperlink into a OLE object on a form. I'm looking for code ideas to automate this with a button (ie - click and it brings up the file manager window so the user can just select several files and have them populate a list box as hyperlinks automatically). Any ideas?

Thanks. PJ

 

[Francescina]

You problem is quite easy to solve, but you need to replace the standard ACCESS OLE procedures by more performant ones. Otherwise your application will explode.
I recommend you to have a look at

http://www.unsoftwareag.com/towwa.htm

for more details.