angelaing
Last Activity: Sep 20 '18, 06:15 PM
Joined: Aug 28 '18
Location:
-
Responding to Phils comment. It’s ok because new records aren’t meant to be added on this form -
NeoPa. This meets the requirement perfectly. I have to do something similar to the same table updating the sequence basedv on the group unit rank entered for a new project enteted into a data entry form. I can conceptualize how I think it should work. This one I’m atill trying to understand why the .undo was needed.Leave a comment:
-
ok so i am a little late. I am in a hurry so I just read parts of your email but when I read the printed out version of the email I can see you asked for a copy of the code. By now I could have sent it to you. I will do both, send you a copy and try and figure it out on my own so I learn. Ok, it will be in about 6 hours and I know there's a time difference. Take careLeave a comment:
-
I keep trying to send you a message and somethings going wrong. I will look at your instructions first. There's more to debugging than stepping through code. I glanced at your instructions on debugging and there's more for me to learn so let me work on it more when I GET Back and i will let you knowLeave a comment:
-
I set watches and stepped through code to see the various values but I still think my debugging skills are not that good.
I have to run right now to go to an appt that's about an hour away so I won't be back until much later today but I will look at your link then and if I still can't figure it out if you don't mind I will either send you a copy of all the code. i could even send you the whole database but there are two of them....Leave a comment:
-
And NeoPa, this is the solution they want to use. So I'll keep trying to figure out what's going on in the meantime. I have to take off for an appointment in 30 minutes but will get back to it.Leave a comment:
-
This is a very complicated requirement and solution. I know you are putting a tremendous amount of thought into making this all work. I'm am putting a tremendous amount of time just to follow where your going with it. I think I understand the logic than I get an ahaha gotcha somewhere but that may be just me. Thanks so muchLeave a comment:
-
NeoPa, I attached the code to the Events you suggested and after I type in a new number to any record on the continuous form nothing happens it sits there forever. I can't click the close button on the form or navigate up or down. I can tab to a new field in the same record but that's it.
When I finally Right Click and choose to put in Design Mode I get the message shown in the screenshots. If I comment out the On Error Resume...Leave a comment:
-
Phil, I will look at yours also. My first reply was to NeoPa. And I haven't even mentioned that I need to do a re-ranking from a single form when users are adding new Projects. I don't even want to think about that yet but I think that one should be easier, maybe.Leave a comment:
-
It was making sense right up to the time I saw the code for the Timer Event. Very creative. I will give it a try and get back to you.Leave a comment:
-
I attached screenshots to provide an example but I changed a record ranked 5 to 1 and it moved it to 2 instead. Also here is the code. I changed one line from the previous code. Instead of n+1 i changed it to just n.
...Code:Private Sub ReRank() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim n As Integer Me.Dirty = FalseLast edited by zmbd; Aug 29 '18, 04:51 AM. Reason: [z{Please use the [CODE/] formatting tool when posting code/script - THIS IS REQUIRED}{made images visible in-line]Leave a comment:
-
Change Sequence of Remaining Records After Updating Number of Another
I have a continuous form with list of Projects ordered by Business Unit Rank. The users want to be able to update the Business Unit Rank to any number and have the remaining numbers resequence. So if the user updates Business Unit Rank from 6 to 3, the current number 3 should change to 4, 4-5, 5-6, etc. without 1 and 2 being changed. If the user changes 6 to 1 for example then the other 1 should change to 2, 2-3, etc. This is the code I have...
No activity results to display
Leave a comment: