Shell Question - connecting to a path that is present on the form.

[JoaoSousa]

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

[kd2017]

If the path has spaces in it then you will need to surround the path with quotation marks.

Try this:

Shell """" & Me.PathCZItxt & """", vbNormalFocus

[JoaoSousa]

It worked!
I didn't know I had to put the & & bit!

Thank you