Add 1 to a counter when a button is pushed?

[Guest]

I would like to create a counter, which advances by 1 each time a button is
pushed.

 

[Guest]

Add to your Event or Macro for when the button is pushed to run an update
query on a number field in your counter table to update NumberField +1.

 

[Steve Schapel]

Rastamon,

Assuming Karl meant to use an OpeQuery action in the macro, his
suggested solution would work well, assuming the counter field in in a
table.

If, on the other hand, you are referring to an unbound control on a
form, you could use a SetValue action, with the arguments set like this...
Item: [NameOfCounterTextbox]
Expression: [NameOfCounterTextbox]+1

 

[Guest]

Thanks Karl and Steve. I have discovered that I can do it easier in Excel by
using a spinner button. Thanks for taking the time to reply.

Rastamon,

Assuming Karl meant to use an OpeQuery action in the macro, his
suggested solution would work well, assuming the counter field in in a
table.

If, on the other hand, you are referring to an unbound control on a
form, you could use a SetValue action, with the arguments set like this...
Item: [NameOfCounterTextbox]
Expression: [NameOfCounterTextbox]+1

--
Steve Schapel, Microsoft Access MVP

Add to your Event or Macro for when the button is pushed to run an update
query on a number field in your counter table to update NumberField +1.