Hi,
How do I build a Shell function where the path is present on a text box of the form (it gets the value from a QRY)?
Example
1 form with multiple entries, each entry with its own command button with the shell cmd, each entry with its own path to the file.
I want the button to open the path that is present on the text box that is on the form.
The text box is called PathCZItxt.
I know that the path is correct, as if I write it on the shell cmd it will open it without any problem.
Shell "C:\Program Files\...\....\....\....exe PATH ON THE SQUARE THING OF THE FORM", vbNormalFocus
I tried me.PathCZItxt.value; me.PathCZItxt.text; among other things...
The path has spaces in it, example of the path to the file:
R:\StudyYear\Shared\Scans\Stainings\Study Scanning\Quality\111111\111111-1 Sample 1
I managed to concatenate everything on a QRY so that it gets all the paths for all samples by having a standard naming (more that 1000 paths)
(New user of access with no IT background, just a passion for IT and loads of time to watch youtube to improve the database we're building)
Any guidance?
Kind regards