Button to increase value of text box but 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KCFlorist - 15 Apr 2005 15:57 GMT

Hello again - I am still messing around with this poker player database and
came across something that would make life easier but cannot figure out how
to do it. When someone wins a poker round (let's say they came in 4th place)
I am manually going to the text box that shows how many times they have won
4th place and then I delete the previous entry (let's say they have won 3
times) from 3 to 4. I thought it would be much easier if there was a command
button or something that I could click that would automatically increase the
3 to a 4...something like a command button with a plus sign next to it. I
tried creating a macro but am not sure how to tell the macro to increase the
value of TEXT BOX: NT 4TH PLACE but 1. Clicking a button to increase the
value would be much faster than having to delete the entry and then type in
the new value. Does anyone know how I can do this? Thanks in advance for
any help or comments.

Regards,
Gregg / KCFlorist.com

Reply to this Message

Klatuu - 15 Apr 2005 16:15 GMT

I would lock the textbox so the user has to use the command buttons. then,
create two buttons - cmdPlus and cmdMinus. Let's call the text box with the
value txtWinCount

In the On Click event of the buttons:
Me.TxtWinCount = Me.txtWinCount + 1

Of course, that would be for the add, for the subtract use
Me.TxtWinCount = Me.txtWinCount - 1

> Hello again - I am still messing around with this poker player database and
> came across something that would make life easier but cannot figure out how
[quoted text clipped - 12 lines]
> Regards,
> Gregg / KCFlorist.com

Reply to this Message

KCFlorist - 15 Apr 2005 16:55 GMT

Ok - I see you logic but stumbled. To create the command button I assume I
want it to run a macro? So if I create a macro called cmdplus and cmdminus,
what would the command lines in the macro be? I tried creating the command
button and replaced the EVENT PROCEDURE in the ON CLICK field with the string
you posted below but it came back saying CANNOT FIND MACRO NAMED ME. Thanks
for helping out.

> I would lock the textbox so the user has to use the command buttons. then,
> create two buttons - cmdPlus and cmdMinus. Let's call the text box with the
[quoted text clipped - 22 lines]
> > Regards,
> > Gregg / KCFlorist.com

Reply to this Message