Validation rule work around

[thatlem]

I have a table that I have set up a validation rule that prevents staff from entering data more than 45 days old... My problem is that Team Leaders want a work around so they can still enter the data if necessary. I know that work arounds are not allowed with validation rules, so I was wondering if anyone had thoughts on how I could do this.

I thought perhaps I would create a popup form with a code field that Team Leaders could enter a code and if correct then proceed to enter the data.

Would this work best in code, or thorough a macro? I've got about thirty different forms I would need to add this to, so am trying to develop a "universal" all inclusive application without having to define this on every form.

Also, would I need to tie the field to a temporary variable somehow? Any thoughts you experts have would be appreciated.

 

[missinglinq]

I know this isn't the answer you want to hear, but if this Validation Rule was entered in the table itself, you need to remove it from there and move it to your form(s) then create a separate form for the team leaders to use that doesn't have the Validation Rule. This can simply be a copy of the form(s) that doesn't have the rule. I usually simply give it a different color scheme, so the Team Leaders, in this case, can visually tell which form they're currently in.

Someone more clever than I may be able to give you to loop thru your thirty forms and add this Validation Rule to your date field on each one.

This kind of thing gives you an appreciation of the value of planning before programming, especially in getting the users needs down. "Scope Sprawl" is an ugly thing!

Good luck!

 

[thatlem]

Yes, I figured that!!! Nothing like doubling the work when you need to make a change.....uuuugh

 

[pkoko]

If you want a dumb workaround.... how about instructing the users to change the system date so the validation rule is still valid.

 

[gemma-the-husky]

why would you have thirty different forms to capture data?

surely you would have one only - maybe one edit form also - why so many in which the date originally entered would be editable?

 

[DCrake]

Another solution would be that if the user inputs a date outside the validation rule then call up an authorisation screen to get the manager pasword. I know managers are manager but why do they want to break the rules. In time if there is a descrepancy in the dates they cannot blame anyone else as its only managers that can override the rule.

David