Hi first timer here......my knowledge of Access is fair, but i'm getting deeper into vba and it's a huge challenge as I don't have a real good foundation or understanding of the why is something written sometimes. Especially with a Shell function that I discovered I will need to use to accomplish my next task in a major project I am trying to work out. So my goal is the use a Table A in access which has jpg image file names. Those files are in a separate folder. I want to then create a form based of table a to have hyperlinks to the corresponding .jpg files in said folder. the following is what I discovered but as I said the lack of foundation is poor. I tried searching and taking each part to get a better understanding to put it all together, but have been going in circles all day with searches and examples. Are there any good videos to watch to see someone build and execute? This would help a great deal as I'm more of a hands on learner. If anyone can elaborate on the following that would also help to guide me in completing shell function and then seeing exactly how it works to get a better understanding.
Dim x As Variant
Dim Path As String
Dim File As String
Path = "C:\Program Files(x86)\Microsoft Office\root\Office16\MSACCESS.EXE"
File = "C:\Mohawk\00532_10045_060084.JPG"
x = Shell(Path + " " + File, vbNormalFocus)
the Path & File are actual on my computer. The x = Shell(Path......as I said poor foundation and I know what vbNormalFocus is but before that...I lost....Any Help? thanks
Dim x As Variant
Dim Path As String
Dim File As String
Path = "C:\Program Files(x86)\Microsoft Office\root\Office16\MSACCESS.EXE"
File = "C:\Mohawk\00532_10045_060084.JPG"
x = Shell(Path + " " + File, vbNormalFocus)
the Path & File are actual on my computer. The x = Shell(Path......as I said poor foundation and I know what vbNormalFocus is but before that...I lost....Any Help? thanks