Command button to add set number to a field

[Jed63]

I’m a member of a martial arts club.



We have an old laptop running XP.
I have an old Access 2000 disc which I no longer use, and this has been loaded to that machine.

I am trying to build a very simple database to keep track of the members’ hours and I’m stuck.
The table name is “Main_Table”, the fields are; [ID],[Name].[Hours]
A form exists “Sign In”.
On the Form, “Sign In” I need a Combo Box or List Box to select a record (name) then a command button which adds 2 hours to the number of hours already in the [Hours] field of that selected record, simple as that….I can’t get anything to run.

I’m out of touch with Access by umpteen years and I think I’ve forgotten a lot of it.

Thanks
Jed

[pbaldy]

I would re-examine the design. If you just update the hours, you have no history. I would store each visit in a related table, with fields for member ID, date hours and anything else relevant. You can then sum up the hours for each member from that raw data.

[Jed63]

Thanks for the reply.
"If you just update the hours, you have no history."
I understand what you're saying, but the history is not relevant, as the quantity of hours will be zeroed every time the student attains the next grade. The dates of the training hours are also irrelevant. It doesn't need to be that complicated.
So all I need is a way to add 2 hours to the selected record at the click of a button, would this need code?

Thanks
Jed

[pbaldy]

Your call. Sooner or later somebody's going to say their hours aren't right and you'll have no way to track. Presuming the form is bound to the table and on the correct record:

Me.TextboxName = Me.TextboxName + 2

[Jed63]

I'm not going to argue with 5th, 4th, and 2nd Dan black belts at my grading that my hours aren’t right, you still have to pass the grade . It's just a rough guide for the sensei so that he can get an idea of a students progress.
Me, that's what I forgot, in the 'On Click' property, yes?

Jed

[pbaldy]

Come on, you gotta stand up to these people!

What I posted is VBA, it would go here:

http://www.baldyweb.com/FirstVBA.htm

[Jed63]

Standing up is not that easy with those three around.
Yep, that's where I thought it would go.
You have a very usefull website.
And thank you for all your help, greatly appreciated.

Jed

[pbaldy]

Happy to help and welcome to the site!