 |  |  |  |  |  |  |  |
 |
Hello to all. I have a project which is scheduling system using vb6. I can't or don't know how to find the time conflicts of each subject at the given day and given professor. For example user select the section name then a combo box for selection of subject then the a 5 checkbox(array) will unlocked then the user will select from monday - friday checkbox(array) then the combo box for the selection of start time will unlocked then another combo box for the selection of end time will unlocked and the last one is the combo box for the selection of the professor. I hope you can help me. thank you in advance.
Exactly what do you want to know? 
You want help on how to do something in vbcode? or you want somebody to implement all your business logic in vbcode?
You want help on how to do something in vbcode? or you want somebody to implement all your business logic in vbcode?
www.easyprograming.com
Make Your Programing Easy
Make Your Programing Easy
•
•
•
•
Originally Posted by yello 
Exactly what do you want to know?
You want help on how to do something in vbcode? or you want somebody to implement all your business logic in vbcode?
I want some tips or maybe some codes to be able to make the detect the conflicts of each subjects in one section. I don't know the this function or the logic of this.
I already done the part of combo box where the user can select subject and professor. The only problem i had is the check box(array) of the day and the combo boxes for the time start and time end which is definitely the available time start and time end will show or can be selected.
•
•
Join Date: Oct 2007
Posts: 147
Reputation: 
Solved Threads: 13
Junior Poster
You are focusing on the user interface. Have you given any thought to the database? You need a table that describes each time period each professor is teaching a subject and what section that class is in. To find out if a given subject is being taught at a given time, you need something like:
SELECT * from classes WHERE (myStartTime BETWEEN classes.StartTime AND classes.EndTime) AND (myEndTime BETWEEN classes.StartTime AND classes.EndTime)
Hoppy
SELECT * from classes WHERE (myStartTime BETWEEN classes.StartTime AND classes.EndTime) AND (myEndTime BETWEEN classes.StartTime AND classes.EndTime)
Hoppy
•
•
•
•
Originally Posted by hopalongcassidy
You are focusing on the user interface. Have you given any thought to the database? You need a table that describes each time period each professor is teaching a subject and what section that class is in. To find out if a given subject is being taught at a given time, you need something like:
SELECT * from classes WHERE (myStartTime BETWEEN classes.StartTime AND classes.EndTime) AND (myEndTime BETWEEN classes.StartTime AND classes.EndTime)
Hoppy
•
•
Join Date: Oct 2007
Posts: 147
Reputation:
Solved Threads: 13
Junior Poster
I looked at your screen shot and I looked at your code. I also looked at the answer you gave to Yello's question.
From my look at the screen shot, it seems to me that you have not really thought the problem through. Your answer to Yello's question seems to indicate that you want to populate the "Time start", "Time end" and "Professor" comboboxes based on the chosen "Subject" and "Time Day". The problem with this is that the start times, end times and professors are not independent of each other. The combo boxes you have set up to enable a user to select each of these independently. So, for example the user could easily select the start time from one class, the end time for some other class and the professor teaching a third class. I don't think that this will work the way you want it to. I would suggest a single combo box with three columns that lists the actual valid combinations of professor, start time and end time for a given subject and day of the week. Also, when I was going to school, a typical class might be taught by a given professor for an hour on Monday, an hour on Wednesday and an hour on Friday. Is this the case in your school?
I think that you need to think a little bit more about what the possibilities are and how to design your application in such a way that it is impossible for the user to enter invalid data. You should not write a single line of code until your design is absolutely air-tight! Once you have a good design, you will be surprised at how much simpler your code will be.
Hoppy
From my look at the screen shot, it seems to me that you have not really thought the problem through. Your answer to Yello's question seems to indicate that you want to populate the "Time start", "Time end" and "Professor" comboboxes based on the chosen "Subject" and "Time Day". The problem with this is that the start times, end times and professors are not independent of each other. The combo boxes you have set up to enable a user to select each of these independently. So, for example the user could easily select the start time from one class, the end time for some other class and the professor teaching a third class. I don't think that this will work the way you want it to. I would suggest a single combo box with three columns that lists the actual valid combinations of professor, start time and end time for a given subject and day of the week. Also, when I was going to school, a typical class might be taught by a given professor for an hour on Monday, an hour on Wednesday and an hour on Friday. Is this the case in your school?
I think that you need to think a little bit more about what the possibilities are and how to design your application in such a way that it is impossible for the user to enter invalid data. You should not write a single line of code until your design is absolutely air-tight! Once you have a good design, you will be surprised at how much simpler your code will be.
Hoppy
•
•
•
•
Originally Posted by hopalongcassidy
I looked at your screen shot and I looked at your code. I also looked at the answer you gave to Yello's question.
From my look at the screen shot, it seems to me that you have not really thought the problem through. Your answer to Yello's question seems to indicate that you want to populate the "Time start", "Time end" and "Professor" comboboxes based on the chosen "Subject" and "Time Day". The problem with this is that the start times, end times and professors are not independent of each other. The combo boxes you have set up to enable a user to select each of these independently. So, for example the user could easily select the start time from one class, the end time for some other class and the professor teaching a third class. I don't think that this will work the way you want it to. I would suggest a single combo box with three columns that lists the actual valid combinations of professor, start time and end time for a given subject and day of the week. Also, when I was going to school, a typical class might be taught by a given professor for an hour on Monday, an hour on Wednesday and an hour on Friday. Is this the case in your school?
I think that you need to think a little bit more about what the possibilities are and how to design your application in such a way that it is impossible for the user to enter invalid data. You should not write a single line of code until your design is absolutely air-tight! Once you have a good design, you will be surprised at how much simpler your code will be.
Hoppy
Maybe your right. But your suggesting me of thing that i don't understand yet and i don't have enough time to study and go back to design. How bout i populate all the time(from 7:00 am - 5:00 pm) then when user update the system will prompt if the given day and time has a conflict.
•
•
Join Date: Oct 2007
Posts: 147
Reputation:
Solved Threads: 13
Junior Poster
•
•
•
•
Originally Posted by qulit
Maybe your right. But your suggesting me of thing that i don't understand yet and i don't have enough time to study and go back to design. How bout i populate all the time(from 7:00 am - 5:00 pm) then when user update the system will prompt if the given day and time has a conflict.
You need to look at each element of the data you want the user to input and ask yourself, "What am I expecting the user to input?" and "What other things might the user input that will create problems?" and then "How can I change my design to eliminate the problems?".
Then, when you go to write the code, you will find that there are a lot of conditions that you don't have to write code to check for because you will have designed the possibility of those conditions out of the software. Your code will be simpler, easier to write and debug and easier for someone else to read.
Hoppy
|
Similar Threads
- Favorite All Time Games (Geeks' Lounge)
- mIRC or Real Time Message Boards...in Linux (*nix Software)
- cts time out (Windows NT / 2000 / XP)
- Slowed Boot Time and Internet Connection Time. (Windows NT / 2000 / XP)
- Time out web pages w/text or drop boxes (Networking Hardware Configuration)
- Windows 95/98/98SE/MM = Time To UPGRADE (Windows 95 / 98 / Me)
- Run-Time Error..? (Windows NT / 2000 / XP)
- No time... bitch load of problems (Windows NT / 2000 / XP)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: vb 6- exporting a database as an excel file in a tabular format(calendar form)
- Next Thread: for next loop
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
