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

On Jun 24, 8:47*am, DUNNER7 <DUNN...@discussions.microsoft.com> wrote:
> * 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

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

DUNNER7 wrote:
> 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
>
>
>

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

"John Spencer MVP" wrote:

> 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
>
> DUNNER7 wrote:
> > 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
> >
> >
> >
>

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

DUNNER7 wrote:
> 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
>
> "John Spencer MVP" wrote:
>
>> 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
>>
>> DUNNER7 wrote:
>>> 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
>>>
>>>
>>>

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

"John Spencer MVP" wrote:

> 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
>
> DUNNER7 wrote:
> > 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
> >
> > "John Spencer MVP" wrote:
> >
> >> 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
> >>
> >> DUNNER7 wrote:
> >>> 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 found other post....sorry. Disregard this post

Del

"DUNNER7" wrote:

> 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
>
> "John Spencer MVP" wrote:
>
> > 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
> >
> > DUNNER7 wrote:
> > > 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
> > >
> > > "John Spencer MVP" wrote:
> > >
> > >> 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
> > >>
> > >> DUNNER7 wrote:
> > >>> 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
> > >>>
> > >>>
> > >>>
> >

Take a look at this:
http://www.fontstuff.com/access/acctut19.htm

This is good too:
http://datapigtechnologies.com/flash...mtoreport.html

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"DUNNER7" wrote:

> 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
>
> "John Spencer MVP" wrote:
>
> > 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
> >
> > DUNNER7 wrote:
> > > 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
> > >
> > > "John Spencer MVP" wrote:
> > >
> > >> 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
> > >>
> > >> DUNNER7 wrote:
> > >>> 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
> > >>>
> > >>>
> > >>>
> >