IainMc2013
New member
- Local time
- Today, 13:18
- Joined
- Apr 1, 2013
- Messages
- 7
I have an access form for creating log records which will require extended information to be stored in a txt file. I have added a button to the form to open notepad so I can type the text and save the file manually however I want to modify the button so that when I click it, it will:
1. create the file in a specified folder (a subfolder in the same folder as the database) using three variables from the form to construct the filename (to standardise the file names and prevent typos arising from manual saving)
2. Add the file name to a field in the form
3. Open the text file in notepad so I can add information to it
I also want to add a function to the list of log entries (which is an embedded form in datasheet mode) so that when I click the filename field in the record list (configured as a hyperlink but this is defaulting to the file path of the database) it will open the corresponding text file in notepad for viewing/editing.
How would I go about this?
1. create the file in a specified folder (a subfolder in the same folder as the database) using three variables from the form to construct the filename (to standardise the file names and prevent typos arising from manual saving)
2. Add the file name to a field in the form
3. Open the text file in notepad so I can add information to it
I also want to add a function to the list of log entries (which is an embedded form in datasheet mode) so that when I click the filename field in the record list (configured as a hyperlink but this is defaulting to the file path of the database) it will open the corresponding text file in notepad for viewing/editing.
How would I go about this?