Need an Access macro to view the contents of a single text field in a form with an external program

Generally, I would like to be able to view the contents of a specific text field in a form using an external application.

Specifically, I created an Access 2013 form that sources its data from an MS SQL Server 2008 R2 database. I would like to add a button to the form such that when a user clicks it, it saves the contents of a specific field to a text file in a pre-defined path and filename. Then I would like that file to be opened in a specific application located at a pre-defined path.

For example, the data type of the field is XML, and I would like to open the contents of that field in Notepad++.

Thanks!

Jim


February 27th, 2015 2:05pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics