Opend PDF File from access from

[BorisGomel]

Hello everybody.

I hope you help me with my problem .I have a lot of pdf file that we save every day and name them like this 8012012,8022012, that are 2 gigits day, 2 gigits month and four digits of years no slaches. The fiels are txt fiels that we recive from banks. After processing thier data, the upper management wants me to open those pd f files form access . i have created form named frmOpenPdf, placed text box named txtName and placed also commund button named cmdOpen . I research code over internet and here is below, but it doesn' work;
Dim avCodeFile As CAcroAVDoc


Dim MYSRTING As String
MYSTRING = txtName.Value
Set Acroapp = CreateObject("AcroExch.App")
Acroapp.Show
Set avCodeFile = CreateObject("AcroExch.AVDoc") 'This is the code file
avCodeFile.Open "C:\Documents and Settings\Desktop\ETFPdfFiles\MYSTRING.pdf",

What I am doing worng here. I would like to have like this : an user types 08012012 and the code excute to opend file names 0802012 in commund button .

Thank you in advance for help,

The Best Reagard,

BorisGomel

[pbaldy]

I've never used that method; I've used FollowHyperlink successfully many times.