Spin Controls in MS Access 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a spin controls in MS Access 97? I would like to setup a spin
control for user to increase or decrease an integer value.
 
Charles,

There are a number of third party spin controls available. For example,
see the Total Access Components collection at www.fmsinc.com.

However, it is fairly easy to roll your own. Just use a textbox, and a
couple of suitably positioned command buttons with arrow icons on them.
Here is an example of the code you can use on the "decrease" button,
which assumess 0 is the lowest allowable value...

Private Sub DecreaseIt_Click()
Me.YourTextbox = Me.YourTextbox - 1
Me.YourTextbox.SetFocus
If Me.YourTextbox = 0 Then
Me.DecreaseIt.Enabled = False
End If
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Freeze animation 1
Is there a spinning wheel control in Access 2007 (like Apple Use)? 0
Excel Forms Spin Button - Return to 1 after max value 0
Set focus to textbox after spin-button control is pressed?? 3
PowerPoint Super Stuck and Desperately Need Help 0
Changing Cell Link on Spin Button Form Control 14
Spin Button - how to write an "After Spinning" procedure 3
Reset Spin Button 2

Back
Top