• 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

    If we make sure that we are on schedule and keep to the pre production deadline we would be able to have one week of filming and two weeks of editing and a spare week just in case something goes wrong or of we need more time to film or edit.

  1. 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.

  2. Comparative Commentary - Comparing text 1(a) and 1(b).

    The author makes clear that the 'LIDO'resorts are perfect holiday destinations. (line 10; 'It's not just all-inclusive, it's Super-Inclusive. And most of all, it's not just a resort, it's a Lido resort by SuperClubs.') The text type of text 1(b)

  1. 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.

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

    Whereas ADVERT 2 Those who can, teach. the presentation is sleek and clearly considered, organised and defined. There is a full colour image completely filling the first page, of the cropped left hand side of a black face with bright flames reflected in the eye, against a white background; the

  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. A case against the moving from sms to mms - Will the multicolored animated ...

    telephones comprising of words or numbers or an alphanumeric combination.1 SMS is provisioned using a Short Message Service Centre (SMSC) that acts as a store and forward mechanism for Short Messages. Short Messages are sent via a signalling channel of an associated mobile network.

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