Date Question

[Guest]

Here it is, I am writing a database for my school where I work. It is an
alternative school, so students are required to achieve a certain level of
compliance. They receive number of demerits each day for any noncompliance.
Weekly the Student Progress Report is being sent home to let parents know of
the progress.
Here comes the problem:
When a student’s demerits are being recorded in the database each demerit is
a separate record with date attached, however when student is perfect that
day, there is no need to enter anything into the database, so date is not
recorded. The 100% compliance on day like this has to be figured into
calculations of weekly, quarterly and etc. periods, also the date has to
appear on weekly report with all statistical numbers and descriptions.
I am so new to this, and after reading some of the posts, I am convinced
that I know almost nothing about access, as it’s real power is not in
wizards. So please be kind.
JPol
MS Access 2000

 

[Jeff Boyce]

I didn't see a question.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Jeff Cox]

Here it is, I am writing a database for my school where I work. It is an
alternative school, so students are required to achieve a certain level of
compliance. They receive number of demerits each day for any noncompliance.
Weekly the Student Progress Report is being sent home to let parents know of
the progress.
Here comes the problem:
When a student’s demerits are being recorded in the database each demerit is
a separate record with date attached, however when student is perfect that
day, there is no need to enter anything into the database, so date is not
recorded. The 100% compliance on day like this has to be figured into
calculations of weekly, quarterly and etc. periods, also the date has to
appear on weekly report with all statistical numbers and descriptions.
I am so new to this, and after reading some of the posts, I am convinced
that I know almost nothing about access, as it’s real power is not in
wizards. So please be kind.
JPol
MS Access 2000

One simple way would be to insist that teachers include a figure for all
days, even days with 0% noncompliance, just put in 0!

This has the added benefit that you can see how many days a student has
100% compliance, which would be an interesting statistic to have at the
end of the semester.

Jeff Cox

 

[BruceM]

You could set the field's default value to 0. You probably need to tie
attendance records into this. Achieving 0 demerits is more of an
accomplishment if the student is actually in school that day.

 

[Guest]

I think this is the easiest way.
Another Question;
I would like to have combo box popup on mouse down when pointed to the
LastName field and then disappear after name has been selected and the form
populated.

 

[Jeff Cox]

I think this is the easiest way.
Another Question;
I would like to have combo box popup on mouse down when pointed to the
LastName field and then disappear after name has been selected and the form
populated.

Click on the lasname textbox and a combo appears, right?
Add a combo to your form with visible set as no.
On the mousedown event of the texbox put:
Me.cboName.Visible=True

On the 'On Current' event of the mainform put:
Me.cboName.Visible=False

I hope this is what you're after!

Jeff Cox

 

[Guest]

Jeff thanks this works great,
Now how could I autoextend the combo box?
JPol

 

[Guest]

As I wrote, the combo box works great as I followed your code, but I need the
box to open automatically and show it's content. All I would have to do is to
select the desired record.
JPol

 

[Jeff Cox]

As I wrote, the combo box works great as I followed your code, but I need the
box to open automatically and show it's content. All I would have to do is to
select the desired record.
JPol

:

On the mousedown event of the textbox put:

me.cboName.Setfocus
Me.cboName.Dropdown

Good Luck

Jeff Cox

 

[Guest]

Thanks, at first it did not work, but I pet this code into the Lastname box
and now is doing what I have intended.
JPol