I am modifying an Access 2010 database and I ran into a problem. VBA is probably the solution, but I am not familiar with it. Just scratching the surface I'm afraid...
I want to click a button in my customer-form, making Explorer.exe to open and show me the content of the customers folder on my server.
The database is basicly containing my customers name, contact data and sessionnumber.
I have tried this simple code:
Shell ("Explorer.exe /e,Link")
"Link" is the name of a calculated field in the main table connected to the form, and contains the correct path to the customers folder. I was hoping to make VBA read the "Link"-text in the table-field and open that folder for me, with just one click.
Can you please guide me to the solution?
I want to click a button in my customer-form, making Explorer.exe to open and show me the content of the customers folder on my server.
The database is basicly containing my customers name, contact data and sessionnumber.
I have tried this simple code:
Shell ("Explorer.exe /e,Link")
"Link" is the name of a calculated field in the main table connected to the form, and contains the correct path to the customers folder. I was hoping to make VBA read the "Link"-text in the table-field and open that folder for me, with just one click.
Can you please guide me to the solution?