Help with access strings

[russ1985]

My apologies for being thick. self taught so that means i no nothing.

I have been given this to create a hyper-link based on record content however i don't know how to enter it in. I want it to be on a control button that when clicked runs this code. please can someone provide me with the complete code to go into VB.

If 45456 was in the EDIDREF control then:
"k:/edid/" & Me.EDIDREF & ".pdf"
would yield "k:/edid/45456.pdf"
as a string.

 

[namliam]

research the word "Shell"

 

[russ1985]

My apologies,

i have searched for the word Shell as instructed but only can find vague forum posts none of which explain what it is.

Is there any possibility you can elaborate or help with the code as requested?

Thanks and apologies for the thickness again.

 

[namliam]

not all resources are online...

Try going into VBA, then type Shell and hit F1

 

[russ1985]

Thanks,

Ironically it searched access's 'online' help LOL.

Found it now i have included below for any future persons.

Shell "cmd.exe /c Start ""Electronic Document"" ""k:/ed/" & Me.fieldname & ".pdf""", vbHide


Thanks very much.