Execute the contents of a field?

T

TA

I can't figure out how to have the contents of a field
(i.e. a field that contains the string
C:\TEMP\GRAPHIC.JPG) execute as a command line
instruction. A RunApp macro would seem to make sense, but
I dont know how to pass a variable like a form's field
contents to it. Perhaps I'll need to do this as a module?
(My database stores locations of graphic files that I
would like to be able open for the current record by
pressing a button. Graphic file extensions are associated
with a graphics viewer.) Any suggestions would be greatly
appreciated.

Thanks,

-TA
 
S

Steve Schapel

TA,

One option would be to define it as a hyperlink data type. Enter your
data like this...
file:\\C:\TEMP\GRAPHIC.JPG

- Steve Schapel, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Autonumber field in Excel that behaves the same as Access 0
Retrieve contents of a neighboring cell 3
Copy the contents of the clipboard to a specific cell of the first table 10
Macro - add 2 spaces after the end of a sentence. 0
Execute a field value 2
Write a macro to copy the contents of another wksht to the active 1
Extracting the Contents of a Field 1

Top