VB6 -Access Timed scehduler..
Posted on 2003-11-03
Looking for assistance to write an application in VB 6 with Access 2000 (and/or 97).
The idea is that Access would have at least 2 tables... geo_section_date_time_file_assoc_tbl and the other file_location_tbl (this could be done in 1 table and in more tables - your decide). The first table would have values entered by Geography, Section, Date, Time and File Id. The second would have File name and Local drive location.
The idea is to have a program that runs all the time and checks your system time and date. Depending on the time and date, the application would run a file (EXE/WAV/SQF/etc).. that has to be defaulted to certain file, but allow the user to change.. so say I opt in the database to open up Notepad at 7:00PM on June 2 from Section 3 facility in San Diego, CA .. then on such time (PST) on June 2 (every June 2)... Notepad should come up.. reason for Section and Location, is 1 for time (daylight savings or not) and section is say I want to kick off Notepad for Section 3 and MP3 file for Section 2 at the same time... I should be able too.
This app is to run all the time.. System Tray app would be the best. but I leave that to you.
The application should allow user to set the values in the database.. including file and file type... for this maybe a "wndows dialog box to select the file instead of typing in the name and location of the file.
The last and most important thing is that I need to learn from it.. so if you could comment the code.. I would appreciate that. Also, any references or components added, let me know if comments as well. Will learn and also use to help class learn.
If the code is tight, I will increase the points. I have another idea to build on this application, which is to make it an ASP project.. I hope to use the example and build on it with ASP to make it a web application for my class project.
Looking forward to your ideas...