S
Safe60
Hi all and greetings from Italy !
I'm coding my first MSAccess app !! It does include a form with tabular
layout and each record in the table describe an event in terms of "something
that the application will remember to the user" . One of the fiels is the
end date of the event to remember. Using the TImerInterval property and
putting some code in the Timer event of the form, I was able to have a
function that is automatcally scheduled. The code check the records in the
table in order to see if the end date of the event, is for example today
and if yes, it pop up a message box to the user. This is working fine but
until now, I created a record set in my code with the appropriate SQL
statement and then looping through the rs I check everything. Now I would
like to put some graphic feedback to the user setting for example the
background color of every record that is an event that must be done today.
How do I access to the records that are shown on the form ? What I mean is:
How do I know from code the records that the user see in that moment on the
screen ? This way I could set the color of the appropriate control. Another
question is.. if have let' say 200 records in my table, and in the form only
25 are shown because the form layout is so designed, how do I know from my
code which subset is the user seeing ? thanks for any suggestion and please
ignore my english errors. My italian is far better.
Sandro
I'm coding my first MSAccess app !! It does include a form with tabular
layout and each record in the table describe an event in terms of "something
that the application will remember to the user" . One of the fiels is the
end date of the event to remember. Using the TImerInterval property and
putting some code in the Timer event of the form, I was able to have a
function that is automatcally scheduled. The code check the records in the
table in order to see if the end date of the event, is for example today
and if yes, it pop up a message box to the user. This is working fine but
until now, I created a record set in my code with the appropriate SQL
statement and then looping through the rs I check everything. Now I would
like to put some graphic feedback to the user setting for example the
background color of every record that is an event that must be done today.
How do I access to the records that are shown on the form ? What I mean is:
How do I know from code the records that the user see in that moment on the
screen ? This way I could set the color of the appropriate control. Another
question is.. if have let' say 200 records in my table, and in the form only
25 are shown because the form layout is so designed, how do I know from my
code which subset is the user seeing ? thanks for any suggestion and please
ignore my english errors. My italian is far better.
Sandro