MS Access help?

[quietann]

I am stumped. I need to do something that should be very simple within Access: score a multiple choice quiz and record the score as a permanent variable. I could do it in 5 minutes in SAS, but that won't work here because the Access database will be in Botswana, and the people there will want to see the scores as soon as the data entry is done.

help? (snarks about MS to /dev/null)

Comments

[(Anonymous)]

hm, my Access is long ago & far away, but will VBA work?

load file with test answers
for each set of test answers
(load test answers into array
set score to 0
for each element in array
(compare to correct answer in db
if correct add (some number) to score)
write score to row in db containing student's info)
close file and/or free file handle
other cleanup goes here
(optionally)send email to botswana telling them that their data is there.

--desert_born, channeling the developer she never was

[quietann.livejournal.com]

That's the exact process I am trying to figure out. It's just getting the VBA right is driving me crazy!

[(Anonymous)]

Oh, that problem! :) That's always the killer. Try:
http://www.functionx.com/vbaccess/
http://www.blueclaw-db.com/accessvisualbasic/
http://www.conknet.com/~mmagnus/VBA/

Good luck!

--desert_born

[(Anonymous)]

hm, my Access is long ago & far away, but will VBA work?

load file with test answers
for each set of test answers
 (load test answers into array
  set score to 0
  for each element in array
    (compare to correct answer in db
     if correct add (some number) to score)
 write score to row in db containing student's info)
close file and/or free file handle
other cleanup goes here
(optionally)send email to botswana telling them that their data is there.

--desert_born, channeling the developer she never was