I need the Visual Basic Script that would be entered into the <onclick_button1> section of the form to complete the following:
When I click button1:
A text file will be created in a physical locaton like "c:\logfiles\*"
The text file will be create with properties by:
1. choosing a radio button1 "which represents all the data from the beggining of the table data to the end" of tablename1
OR additional interface option:
2. a text box <textbox1.txt> that can be filled in with a numeric value so when <onclick_button1> it allows you to choose, going from today, backwards how many files/days you numerically choose in textbox1. (each file/day would be represented by a row)
OR additional interface option:
3. a range from monthcalendar1 to monthclendar2
any of the three options [login to view URL] will process the range to a textfile.
---------------------
the log file could be auto titled as daterange to daterange like "122508_032709.txt" or something similar. Delimited style is fine.
(I can handle the interface bit, I just cannot figure out how to create the script to process the info)
Form Image Uploaded for your reference***
I am using Visual Basic 2008 Express, It is a microsoft SQL Server Compatct 3.5 Database