• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  47. 47
  48. 48
  49. 49
  50. 50
  51. 51
  52. 52

Visual basic project of the booking system

Extracts from this document...


VISUAL BASIC PROJECT OF THE BOOKING SYSTEM CARLOS ALBERTO MONTOYA HNC SOFTWARE ENGINEERING (FAST TRACK). LECTURER: IAN EMMS TABLE OF CONTEST TABLE OF CONTEST 2 ASSIGNMENT 5 SYSTEM REQUIREMENTS 6 DESIGN LAYOUT 7 STAGE 1 11 STAGE 2 12 PROBLEMS WITH MY DESIGN AND CODE 13 SOLUTIONS TO THE PROBLEMS I FOUND ON MY DESIGN 16 FINAL CODES 33 ? CODES OR PROCESS FOR THE coursecode COMBO BOX 33 ? CODE IN ROOMS 1 LIST BOX 34 ? CODES IN THE roomnumber TEXT BOX 34 ? CODES IN THE cmdsave COMMAND BUTTON 36 ? CODES IN THE cmdload COMMAND BUTTON 43 ? CODES IN THE cmdprint COMMAND BUTTON 44 ? CODES IN THE cmdreset COMMAND BUTTON 48 ? CODES IN THE cmdabout COMMAND BUTTON 49 ? CODES IN THE cmdexit COMMAND BUTTON 49 ? CODES FOR cmdok BUTTON ON THE FRMABOUT FORM. 49 ? CODES FOR timer1 on booking system form. 49 ASSUMPTIONS 50 EVALUATION 51 REFERENCES 52 ASSIGNMENT A College requires a booking application for the Computer rooms in the college. The application needs to record the Tutor who wants to book the room, the course code for the class, the date of the booking, the start and finish times of the booking, the room number, the number of computers in the booked room that are required (this is dependent on the number of students in the class) and any specialist software required for a particular class i.e. Visual Basic, Select CASE Tool, Flash etc. Available Information: * Rooms T100, T229, T201, T232 each have 25 computers * Rooms T217, T212, T211, T221 each have 20 computers * Rooms T227, T223, T152 each have 15 computers * Course Code HCCISX0A - 21 Students * Course Code ZHMMMX1A - 23 Students * Course Code HCCISE1A - 18 Students * Course Code HCCISE2A - 13 Students * Course Code HCCISX0A - needs Visual Basic, Select and Flash * Course Code ZHMMMX1A - needs Visual Basic and Flash * Course Code HCCISE1A - needs Visual ...read more.


* To solve this problem I used a code to add item on the list box call bookinfo, this code will be place on all the command button the user is more likely to use. The code is the following: BOOKINFO.Clear BOOKINFO.AddItem "NAME: " + TextNAME.Text + " " + TextSURNAME BOOKINFO.AddItem "COURSE CODE: " + coursecode.Text BOOKINFO.AddItem "ROOM NUMBER: " + roomnumber.Text BOOKINFO.AddItem "DATE: " + comboday.Text + " " + combomonth + " " + comboyear BOOKINFO.AddItem "FROM: " + Combohour.Text BOOKINFO.AddItem "TO: " + Combohours.Text BOOKINFO.AddItem "NUMBER OF COMPUTER AND SOFTWARE AVAILABLE: " j) There is not message box that ask the user if the information they enter is correct. * All I have to do to achieve this is a message box with ok and a cancel button, this code will be place on the print command and the save command. The code I am going to use is the following: If MsgBox("IS THIS INFORMATION CORRECT?" + vbCrLf + _ "NAME: " + TextNAME.Text + " " + TextSURNAME.Text _ + vbCrLf + " COURSE CODE: " + coursecode.Text _ + vbCrLf + " ROOM NUMBER: " + roomnumber.Text _ + vbCrLf + "DATE: " + comboday.Text + " " + combomonth + " " + comboyear.Text _ + vbCrLf + "FROM: " + Combohour _ + vbCrLf + "TO: " + Combohours, vbOKCancel, _ "Save Record") = vbOK Then Dim filenumber As Integer filenumber = 1 Open "C:\BOOKING INFORMATION.TXT" For Append As #1 Print #1, vbCrLf Print #1, " THIS ROOM HAS BEEN BOOKED" Print #1, Date Call Shell("NOTEPAD.EXE C:\BOOKING INFORMATION.TXT") End if k) I do not think I need the information command button to find out what rooms are available with a course code. > The way to remove the information command button without altering the process of the program will be by creating four if ....then...elseif.....end if statements as a click event, that way when the user selects a course code that will automatically show all the rooms number available . ...read more.


lblhours.Caption = Format$(Time, "hh") End Sub ASSUMPTIONS > The college opens its doors at 8 o'clock in the morning, so booking start at the same time as well, the last booking has to be made before 18:30, the college closes its door at 21:00 o'clock. > All booking must be done a least a day before the actual date the room is needed. > All rooms must be booked for more a minimum of 15 minutes. EVALUATION Doing this project has been very hard because I did not have any knowledge of visual basic but reading some very good books gave me a big help. Overall I think my design cover pretty much all the angles in the validation, I assumed I was the user and looked a every single possibilities that came to my mind, like what happens if I don't select the course code but instead write my name on that combo box, what will the program do?. If the program continues then I have to write a validation where the program is expecting the information that is already store in the system and that exactly what I did. One of the most difficult things I found doing this project was working out the validation for the date, so that the user could booked rooms a date that has already passed. One thing that I would do different is start documenting every single change I made to the program from the moment I started it, it was very difficult recalling everything I did from the start. I have check my codes and design several times and the only thing I could enhance on the future is that if the user has already entered all the information but suddenly change any information like the date time etc, then I would show a message box asking the user if he/she wants to save the information that was there before he made the change. Apart from this, I really enjoy myself doing this assignment. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Advertisements section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Advertisements essays

  1. the five elements of multimedia: Text, Sound, Graphics and Animation, Video, and Multimedia development

    Metaphors Lingo -programme language used by director. Copyright.provides legal protection and grants certain rights to its owner. The author of the image is usually the owner of the copyright,unless the author has transferred copyright ownership to some one else. Video conferencing- Using videoconferencing technology, two or more people at different

  2. Summary of the English Text

    Today it is a world-wide life style factory and - to many - a provocation. The result is one of Italy's most rapidly growing companies that provide especially the youth, but also small children and the slightly older generation, with clothes.

  1. Analyse how structural and linguistic devices are used to target a specific audience in ...

    The advert is cleverly worded and persuasive - teachers 'influence young minds'; implying that this 'influence' is for the better. The advertisement was printed in full colour. The first page is nearly filled with the photograph of a young persons truncated face (deliberately, it is not possible to determine the sex)

  2. The Historical Critical Approach to the Bible requires the text to be read in ...

    'abuses' of the Church, his hermeneutical reformulation differed little in essence from that which he had dismissed. The Old Testament was still interpreted Christologically, and history and reason were all but denied on the grounds that they had no relevance to the 'power of Christ'.6 Anomalies within the Biblical texts

  1. Free essay

    Tetley Evaluation

    The advert starts off outside a suburban house with the protagonist fixing a car; it is a typical stereotyped old lady which can relate to the tea. The protagonist is stereotyped male; with bold head, strong and fixing a car.

  2. Create ing your own business - create a full plan on a business of ...

    through display cases or regular demonstration on how to use a public service offered by the shop. Listening to music or seeing the mobile handset models in the showcase. Packaging: - by letting people know that you exist through unique packaging e.g. design, shape, information displayed on the packaging.

  1. Market Audit for Camel Cigarettes/RJ Reynolds

    While the price is generally same throughout the country, the state tax can vary significantly from state to state. For example, Missouri has the cheapest state tax at $.17 per pack while Rhode Island has the most expensive tax at an additional $2.46 per pack.


    Therefore the ethical standards differ from person to person. "There is nothing morally wrong with the practice of advertising in itself. But how managers advertise may generate moral problems. These problems usually centre around the use of persuasion and the creation of consumer demands. Moral questions may arise, sometimes; because of the way advertisers go about trying to convince people that they should buy their product.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work