Spin Up/Down Example (1 Viewer)

Status
Not open for further replies.

Dreamweaver

Well-known member
Local time
Today, 08:56
Joined
Nov 28, 2005
Messages
2,466
Hope you find this useful and should you find any errors please let me know.


This will allow you to move a record up and down but will also colour the record your moving so you don't get lost this handles deleting, Adding records and when you move away form the subform the condional formating is reset


To use his example all you need do is click the up/down buttons next to the task name you could make them bigger by moving them side by side and making the buttons background as the normal colour and adding an image to show up/down should you have the room.



see image in next post


If you like what I've done please come back and let me know by clicking the thanks button
 

Attachments

  • UP-down Example.zip
    44.6 KB · Views: 635
Last edited:

pbaldy

Wino Moderator
Staff member
Local time
Today, 01:56
Joined
Aug 30, 2003
Messages
36,118
You might want to add a more detailed description of what the sample does.
 

Dreamweaver

Well-known member
Local time
Today, 08:56
Joined
Nov 28, 2005
Messages
2,466
this is what it should look like you can change the conditional formating colour by enter design view then clicking all the fields then on the toolbar click format, condional formating please note should you edit multiple you will overwrite any you already use I found that out the hard way
 

Attachments

  • 2018-12-30.jpg
    2018-12-30.jpg
    111.7 KB · Views: 376

Dreamweaver

Well-known member
Local time
Today, 08:56
Joined
Nov 28, 2005
Messages
2,466
Been told when going to a new record while spinning records the colour stays the same so I added below


to the subforms oncurrent add
If Me.NewRecord Then ReSetSpin



Then Add the following sub to the subform
Code:
Private Sub ReSetSpin()
CurrentDb.Execute ("UPDATE tblTasks SET [PrintFlag]=False WHERE [PhaseID]=" & Me![PhaseID] & " And [PrintFlag]=True")
End Sub
I haven't worried about what happens if they click in the Task name
 
Last edited:
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom