Results 1 to 3 of 3

Thread: 'quick' vb/access question :)

  1. #1
    cat /dev/null streetster's Avatar
    Join Date
    Jul 2003
    Location
    London
    Posts
    4,138
    Thanks
    119
    Thanked
    100 times in 82 posts
    • streetster's system
      • Motherboard:
      • Asus P7P55D-E
      • CPU:
      • Intel i5 750 2.67 @ 4.0Ghz
      • Memory:
      • 4GB Corsair XMS DDR3
      • Storage:
      • 2x1TB Drives [RAID0]
      • Graphics card(s):
      • 2xSapphire HD 4870 512MB CrossFireX
      • PSU:
      • Corsair HX520W
      • Case:
      • Coolermaster Black Widow
      • Operating System:
      • Windows 7 x64
      • Monitor(s):
      • DELL U2311
      • Internet:
      • Virgin 50Mb

    'quick' vb/access question :)

    hopefully the solution is easy, and doesnt involve ADO or anything complicated...

    basically, i am doing a timetable system, and i have written out a timetable in table (fields like, day, period, lesson, studentID), and i now have made a form with the days/periods on it, all i want is for the user to be able to choose the user from the drop down (done that bit), which then runs a query to list what lesson a particular student has on a particular day & period, based upon the id in the drop-down box.

    Code:
    SELECT [tbl_timetable_student].[Subject]
    FROM tbl_timetable_student
    WHERE ((([tbl_timetable_student].[Student_ID])=prototype.gStudentIDBox) And (([tbl_timetable_student].[Day])="Monday") And (([tbl_timetable_student].[Period])="Period1"));
    where prototype.gStudentIDBox is a global variable defined by the value in the drop down box.. but when i try it like that, it asks me to input the parameter "prototype.gStudentIDBox". which isnt useful...

    any ideas folks?

    mark

  2. #2
    Funking Prink! Raz316's Avatar
    Join Date
    Jul 2003
    Location
    Deal, Kent, UK
    Posts
    2,978
    Thanks
    130
    Thanked
    62 times in 52 posts
    can you not just call the entry from the drop down straight off, instead of using a variable?

  3. #3
    cat /dev/null streetster's Avatar
    Join Date
    Jul 2003
    Location
    London
    Posts
    4,138
    Thanks
    119
    Thanked
    100 times in 82 posts
    • streetster's system
      • Motherboard:
      • Asus P7P55D-E
      • CPU:
      • Intel i5 750 2.67 @ 4.0Ghz
      • Memory:
      • 4GB Corsair XMS DDR3
      • Storage:
      • 2x1TB Drives [RAID0]
      • Graphics card(s):
      • 2xSapphire HD 4870 512MB CrossFireX
      • PSU:
      • Corsair HX520W
      • Case:
      • Coolermaster Black Widow
      • Operating System:
      • Windows 7 x64
      • Monitor(s):
      • DELL U2311
      • Internet:
      • Virgin 50Mb
    hmm, this should be in the programming section as i just went to look for it there and realised it wasnt...

    anyhow the student_Id is taken from a different table, and i dont see how i can make it work on the form, as the control source of the form is the timetable table, rather than the student table... might have another fiddle tho.

    cheers
    Mark

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •