OpeningWord

[Guest]

I am using Access2000.

On a form I have a combo box that the user can select a company from the
llist. On update of the combo box I want to open a particular word doc. The
name of the different word docs are FY[year][conbr].doc. Ex. FY20051132.doc.
I set a variable in VB txtFileToGet and populate it, txtFileToGet = "FY" &
cboCo.column(0) & cboCo.column(2) & ".doc". The next line in VB reads
Application.FollowHyperlink "D:\path\txtFileToGet.

Question; Can somone help me with this? I've tried everything I can think
of. Thanks.

 

[Guest]

Hi,
if txtFileToGet holds the true full name of the document and you are
specifying the path to it hardcoded then your followhyperlink statement
should look something like this:

Application.FollowHyperlink "d:\path\" & Me.txtFileToGet

HTH
Good luck