943,741 Members | Top Members by Rank

Ad:
You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page
Oct 20th, 2007
0

Re: time

Coming up with a good design doesn't take as much time as you imagine. And it's the most important skill you can have as a programmer. And it's much more important than "coming up with something" on this particular assignment in this particular class. Better to fail on an assignment than to fail in your career. You can ask anyone who has achieved success at anything and they will (without exception) tell you that what I'm saying is true. In your heart, you already know it's true.

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


I guest your right. I'll start redesign this form. You say earlier that combo box can have more than 1 fields(start time, end time, and professor) or what ever the name of that. Can you tell me how to do it.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
qulit is offline Offline
8 posts
since Oct 2007
Oct 20th, 2007
0

Re: time

Yes,

1. Create a ListBox on your form.
2. Open the Properties Box and click on the "Data" tab.
3. For the "Row Source Type", specify "Table/Query".
4. For the "Row Source" enter the name of the table or query you want to use to provide the data to populate the ListBox. In your case, you are probably want to use a query since you only want to display the table entries that correspond to the subject that the user chooses and the day of the week the user chooses. The query should probably have an "ORDER BY StartTime" clause in it. This way it will be easier for a student to pick a class that occurs at a convenient time.
5.For "Bound Column", enter the column number in the query that corresponds to "Start Time".
6. Click on the "Format" tab.
7. Enter the "Column Count".
8. For "Column Heads" select "Yes". This will cause the ListBox to display the field names in the query as the column headings.
9. For "Column Widths", you are going to have to experiment a little. The "Column Widths" property consists of numbers separated by semicolons (. There should be as many widths as you specified in "Column Count". Make sure that the sum of the column widths does not exceed the width of the ListBox.
10. Click on the "Other" tab and enter the name of the ListBox as you will refer to it in your code.

That's it.


Hoppy
Reputation Points: 53
Solved Threads: 13
Junior Poster
hopalongcassidy is offline Offline
148 posts
since Oct 2007
Oct 21st, 2007
0

Re: time

Yes,

1. Create a ListBox on your form.
2. Open the Properties Box and click on the "Data" tab.
3. For the "Row Source Type", specify "Table/Query".
4. For the "Row Source" enter the name of the table or query you want to use to provide the data to populate the ListBox. In your case, you are probably want to use a query since you only want to display the table entries that correspond to the subject that the user chooses and the day of the week the user chooses. The query should probably have an "ORDER BY StartTime" clause in it. This way it will be easier for a student to pick a class that occurs at a convenient time.
5.For "Bound Column", enter the column number in the query that corresponds to "Start Time".
6. Click on the "Format" tab.
7. Enter the "Column Count".
8. For "Column Heads" select "Yes". This will cause the ListBox to display the field names in the query as the column headings.
9. For "Column Widths", you are going to have to experiment a little. The "Column Widths" property consists of numbers separated by semicolons (. There should be as many widths as you specified in "Column Count". Make sure that the sum of the column widths does not exceed the width of the ListBox.
10. Click on the "Other" tab and enter the name of the ListBox as you will refer to it in your code.

That's it.


Hoppy


Thank you for the help. I'll follow what you said. Can I have your email address so I can directly ask you or something? And I'm sorry, I'm just a new on this field. Thank you again and good luck.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
qulit is offline Offline
8 posts
since Oct 2007
Oct 21st, 2007
0

Re: time

Click to Expand / Collapse  Quote originally posted by qulit ...
Thank you for the help. I'll follow what you said. Can I have your email address so I can directly ask you or something? And I'm sorry, I'm just a new on this field. Thank you again and good luck.
I'm sorry, but I think it's against the DaniWeb rules to do that. If you just click on my name in this or any other thread in which I have participated, you will get a dropdown box. Click on "Send a private message". I think it will accomplish the same thing.

Hoppy
Reputation Points: 53
Solved Threads: 13
Junior Poster
hopalongcassidy is offline Offline
148 posts
since Oct 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: vb 6- exporting a database as an excel file in a tabular format(calendar form)
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: for next loop





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC