How do Imake a report work like a form for data entry?

  • Thread starter Thread starter DUNNER7
  • Start date Start date
D

DUNNER7

I am keeping a student database, I have a table for demographics and a table
for students...they are related by student ID#. Here is my problem, I am
able to to use the table I designed for attendance to do it using a drop-down
box linked to the demographic information...pick name enter Present (next
field) and datetimestamp occurs upon enter. Simple enough...however, it will
be cumbersome to try and do this in September while checking in 300 students
into the building during a 15-20 minute period.

Possible solution: I was able to design a report and set it up so that each
kid's id, first and last name are listed and I could easily scroll down the
list of names. My question is: Is there a way to design code so that when I
clicked on the last name that it would enter "PRE" (present) and store the
datetimestamp entry in my attendance table? Is it also possible to cause the
color property of the font of the last name LABEL to change upon the click
and then change back to the default color at some later time period? (to
avoid clicking a name twice).

Thanks,
Del Dobbs
 
  I am keeping a student database, I have a table for demographics and a table
for students...they are related by student ID#. Here is my problem, I am
able to to use the table I designed for attendance to do it using a drop-down
box linked to the demographic information...pick name enter Present (next
field) and datetimestamp occurs upon enter. Simple enough...however, it will
be cumbersome to try and do this in September while checking in 300 students
into the building during a 15-20 minute period.

Possible solution: I was able to design a report and set it up so that each
kid's id, first and last name are listed and I could easily scroll down the
list of names. My question is: Is there a way to design code so that whenI
clicked on the last name that it would enter "PRE" (present) and store the
datetimestamp entry in my attendance table? Is it also possible to cause the
color property of the font of the last name LABEL to change upon the click
and then change back to the default color at some later time period? (to
avoid clicking a name twice).

Thanks,
Del Dobbs
Click to expand...

No. Reports are read-only. They have different events than forms -
they cannot respond to clicks.
 
See my response to your earlier posting.

I forgot to say that REPORTS are static and can only be viewed and printed.
There is no way to make them respond to a click on a particular printed line.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
O.K., Is there a way to make a form that lists every student, 1 per row, that
I could scroll down and click there name and enter the time entered that way?

Thanks,
Del Dobbs
 
Again, see my reply to your earlier posting. If you don't understand that
reply or need further guidance, then request more information.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Maybe I am missing something, didn't is ask for more assistance in my reply
to your first post. O.K. .........?

Maybe I am in wrong forum?

Del
 
Back
Top