Useless and needs help

[asmith61]

Hi



Was just wondering if anyone out there knew of a way i could generate the following situation

I want to have a form that has multiple buttons (say for example, monday tuesday wednesday). For each of those buttons, what i want is a tally situation. So that every time i press the button, it adds "1" to the count in the table. This way i generate a number for how many time i pressed each button. This is simply for an activity statement for work, and i am useless at access, and was hoping someone had the knowledge to help me through it.

cheers

asmith61

[SoftwareMatters]

Do you want to store the numbers or is it just a visual thing?

If you want to store the numbers you will need a table with the fields you wish to store i.e. monday tuesday wednesday etc and format them as numbers with a default of 0.

Create a form based on theis table using the wizard.

Now create the buttons on the form that correspond to the fields i.e. mondayButton tuesdayButton wednesdaybutton etc and place code on the OnClick event of each of them something like this:

Private Sub mondayButton_Click()
Me!wed = Me!wed + 1
End Sub