• 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. Free essay

    Tetley Evaluation

    The problems that accord in the pre production that we couldn't find a location to film which also was a problem for the directing because I couldn't do the camera shot list or even the storyboard. So as a group we made sure to find a location to film as

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

    > More responsibilities for one person > All the risks is the owners > There is difficulty raising capital Partnership: Advantages: * More owners means more capital * The work load can be shared between the owners * Low

  2. Market Audit for Camel Cigarettes/RJ Reynolds

    With this knowledge in hand, strong Marlboro regions of the country can be targeted with similar styles of Camel cigarettes. Environmental Factors Customers Cigarettes and cigarette companies are not viewed in a positive manner by the overall community. Cigarettes are proven to cause a number of diseases including but not limited to cancer and emphysema.


    Advertising ethics affects the practice of our lives and also the practice of business in subtle and prominent ways."(www.questia.com). Unethical advertising can contribute to the worsening of poverty. Advertisements have several economic, political, cultural and moral benefits and disadvantages. (http://www.vatican.va/roman_curia).

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

    white background continues to the next page where the typography outlines the negative shape of a flame round the photographic image of a burning match; which both relates to the flames reflected in the eye and complements and illustrates the low key, discreetly sized, main heading and title on two

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

    Scripture did not exist merely to verify a particular set of doctrines, rather it was the inspired and infallible Word of God.4 For the most part therefore, allegorical interpretation was formally denied, although Luther covertly had recourse to its use.5 Although Luther tried to rescue the Bible from the allegorical

  2. I have to design a stencil, which will be given away as a free ...

    I've decided to get a picture of a lion which I will place as my second stencil. This is generally because it's easy for little children to understand and identify. As this stencil will be used in nurseries I will aim to use images of simple animals for example, lions and fishes.

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