Pat Hartman Can You Help
Sep 30, 2005How do I link or import access to visio. I can't find visio in the list. Please Help. Thanks Pat I know tha you are so smart.
View Replies
ADVERTISEMENT
Curious Question For Pat Hartman
Aug 13, 2005Ms. Hartman,
You have may it very clear on a number of post, that I've read, that checking for required fields and duplicate fields, should be done in the forms BeforeUpdate event and last week, when you helped to try and achieve this on one of my forms, posted back and stated, "I never remove the close box or make forms modal unless they absolutely work."
Here's my question. If I disabled the forms max, min and close and then put my own Close cmdButton on the form and in this cmdButtons OnClick event I did my validations before I allowed the form to go to Close, wouldn't this at least be an OK way of doing it since I'm not allowing any of the forms "closing" events to fire? With BeforeUpdate I'm having to validate and if it doesn't pass, then stop the form from closing and cancel the forms events.
I'm only asking this cause I know your experience level is way above mine and of course I'm using my own close button, and the way you answered me made me think this was not a good way to do it, so I thought I would ask if it is a bad way of doing it and why. I just want to make sure that I'm not creating problems for myself.
Hope this makes sense,
Shane
Database Example-Pat Hartman Non Normal Form
Dec 1, 2005Hey folks!
A favor to ask: Pat Hartman posted an example db shortly before this site was attacked that dealt with setting up a form in a non-normal fashion to enter/display data that was in normalized tables. Did anyone download and keep a copy?
I downloaded it and was going to study it to try to build something similar for a lab application, but I lost my copy and can't get it back. A search here did not pull the post up, so I'm assuming the attack got the post, which was in the example DB section.
If anyone still has a copy, or if you see this Pat, would you mind posting the file again? I'd really like to study this one.
Thank you in advance.