gakiss2
Registered User.
- Local time
- Today, 09:31
- Joined
- Nov 21, 2018
- Messages
- 168
The issue is that I get an error when a form is refreshed. Debug shows the Me.refresh line of code. The 'error' is that the due date is not a weekday.
I tracked that back to a validation rule that I had put into the table. It was behaving properly, I just didn't want that behavior any more. I wanted to allow users to use the due date on a weekend if they like.
The table is linked So I deleted the Validation Rule from the back end table first.
Same behavior.
I found the validation rule showing up in the Linked Table on the front end. I had thought the deletion of the validation rule on the Back end would carry forward, apparently wrong I deleted that validation rule as well.
Same behavior, throws an error if I put in a due date that is on a weekend.
The only thing that I can think of that I haven't done is to delete the due date field in the source (back end) table. I'm holding off because it would be some work to restore all the due dates. That's fine if that will fix the problem but I was hoping I could get an Amen or even another easier way to get Access to stop obeying a rule that isn't there anymore.
I could attach but not sure that will help. the only code that I can imagine is Me.Refresh. I can say that I can remove the Me.Refresh line the error does not come up but then a function of the database doesn't work (refresh is needed to stimulate a 'save' for a Document Change history using Access Append). Also it does not change the due date and does not warn the user it didn't change. Arguably an even worse outcome.
Let me know if there is some attachment you need.
Thank You for your time helping with this issue.
I tracked that back to a validation rule that I had put into the table. It was behaving properly, I just didn't want that behavior any more. I wanted to allow users to use the due date on a weekend if they like.
The table is linked So I deleted the Validation Rule from the back end table first.
Same behavior.
I found the validation rule showing up in the Linked Table on the front end. I had thought the deletion of the validation rule on the Back end would carry forward, apparently wrong I deleted that validation rule as well.
Same behavior, throws an error if I put in a due date that is on a weekend.
The only thing that I can think of that I haven't done is to delete the due date field in the source (back end) table. I'm holding off because it would be some work to restore all the due dates. That's fine if that will fix the problem but I was hoping I could get an Amen or even another easier way to get Access to stop obeying a rule that isn't there anymore.
I could attach but not sure that will help. the only code that I can imagine is Me.Refresh. I can say that I can remove the Me.Refresh line the error does not come up but then a function of the database doesn't work (refresh is needed to stimulate a 'save' for a Document Change history using Access Append). Also it does not change the due date and does not warn the user it didn't change. Arguably an even worse outcome.
Let me know if there is some attachment you need.
Thank You for your time helping with this issue.