open notepad file with on click event

[Dave_epic]

Private Sub open_Click()
Call Shell("NOTEPAD.EXE", 1)
End Sub

Hi

I can open notepad application with the above code but what the code for opening a specific saved notebook file with a command button on a form. The notebook file is saved on c:\ for example.

Or.... It is just a list of numbers I want to open in notepad is there a nicer way to open a list of numbers from a command button. something like an Excel comment box?

Thanks

 

[MarkK]

You can do this ...

private sub cmd_click()
  shell "notepad.exe c:\test.txt"
end sub

is there a nicer way to open a list of numbers from a command button

There are a million ways to show a list of numbers. What you want to do with the list?

 

[Dave_epic]

Thanks

I thought it might just be adding a directory tree somewhere.

I don't want to do anything with the list of numbers, just for them to pop-up when you click the command button. However I would like the pop-up list to be specific to the particular record you are looking at, I can't seem to do that at the moment.


Regards

 

[Rokhi]

How are the numbers in the list file related to the records in the MDB?
Why are they separate to the MDB?
How are they generated and how often? eg on the fly? static?