Microsoft Note Pad

[Ripley]

Hi. Firstly happy new year to all!

I wondered if you could help me on some code.

What i want to be is:

1) Open microsoft nodepad.

2) Open a query

3) Copy all records from the query to windows clipboard.

4) Paste it into MS Notepad

5) Add a new paragraph to the end of the pasted data.

6) Repeat the process for various querys etc.

7) At the end all i want to do is bring notpad open on screen with the data that has been pasted.

If anyone could post some basic code i would appriciate it, many thanks.

 

[Bat17]

I think that your best bet would be to use code to create a file witting your data to it and then just open it.
have a look at
http://www.access-programmers.co.uk/forums/showthread.php?t=39728&highlight=write+text+file
it might give you an idea for starters.

Peter

 

[FoFa]

Rather than copy and paste, why not just create a text file and then open notepad using that file?