[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Slider Control 6 in Access 2003 and Continous Froms

Posted on 2007-07-22
7
Medium Priority
?
511 Views
Last Modified: 2008-01-09
I would like to use the slider control in a continuous form.
As normal the slider values are the same for each record in the continous form but I would like them to be the value of another field in the record. ( each record has a different value and the slider shows it)
I wrote a litle script to go through the records and change the Slide Control to the value in each, however as the script moves down the records the next one changes the previous one and so the result is record 1 has record 2's value, record 3 has record 4's and so on.
Any suggestions?
Thanks
Danny
0
Comment
Question by:quickdan
  • 4
  • 3
7 Comments
 
LVL 39

Expert Comment

by:thenelson
ID: 19544490
Post your script and in which event you entered the script.
0
 

Author Comment

by:quickdan
ID: 19544566
A button in the header - On click
Private Sub Command20_Click()
Dim t
For t = 1 To 4
Me.Slider9 = Me.CLValueEvaluation
Me.Repaint
DoCmd.GoToRecord , , acNext
Next t
End Sub
0
 
LVL 39

Expert Comment

by:thenelson
ID: 19545096
Try putting it in the on current event:
Private Sub Form_OnCurrent()
Me.Slider9 = Me.CLValueEvaluation
Me.Repaint
End Sub
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 

Author Comment

by:quickdan
ID: 19557530
I'm using this in a subform.
The "On Current Event" does the same thing
Did it work for you?
Thanks
Danny
0
 

Author Comment

by:quickdan
ID: 19585491
Do I assume the whole thing was a bad idea?
0
 
LVL 39

Accepted Solution

by:
thenelson earned 1000 total points
ID: 19586229
I tried playing with the slider control on a continuous form and could not get it to show a different value for each record.  It's the old unbound control on continuous form problem.

You could create a crude bar graph by placing several text boxes side by side and change their backcolor via conditional formatting.
0
 

Author Comment

by:quickdan
ID: 19586988
Thanks for checking this out for me and the suggestion on the text boxes.
Danny
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question