If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
KEEP FORM OPEN IF A FIELD IS BLANK
I WANT TO CREATE A MACRO OR VALIDATION OR MODULE THAT WOULD NOT ALLOW A FORM
TO CLOSE IF A CERTAIN DATA FIELD WAS LEFT BLANK. I CAN SET VALIDATION RULES BUT I AM STUMPED ON HOW TO KEEP SOMEONE FROM ENTERING FURTHER INTO THE DATABASE UNLESS THEY SIGN IN PROPERLY. |
#2
|
|||
|
|||
KEEP FORM OPEN IF A FIELD IS BLANK
If I was trying to do this, this is how I would get to the same place you
want to be. Make the form popup or maximised and modal, this will stop the user from clicking anywhere else to move focus from the current form. Turn off all the forms close controls in the forms properties. Now you have a form you can open but not close. To close the form. Add a close button. Use the wizard to generate a button to close the current form (DoCmd.Close (lookup the syntax in help for your access version)) In the forms on open event, disable the close button (Me.ButtonName.Enabled = False) In the Control that is not to be Null, After Update event re-enable the button (Me.ButtonName.Enabled = true) (You may have to play with which event of the Control carries the Enable code) I hope I have explained carefully and that this solution helps you. Kindest Regards Mike -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "DEBRA" wrote: I WANT TO CREATE A MACRO OR VALIDATION OR MODULE THAT WOULD NOT ALLOW A FORM TO CLOSE IF A CERTAIN DATA FIELD WAS LEFT BLANK. I CAN SET VALIDATION RULES BUT I AM STUMPED ON HOW TO KEEP SOMEONE FROM ENTERING FURTHER INTO THE DATABASE UNLESS THEY SIGN IN PROPERLY. |
#3
|
|||
|
|||
KEEP FORM OPEN IF A FIELD IS BLANK
Thank you. I am going to attempt this.
"MikeJohnB" wrote: If I was trying to do this, this is how I would get to the same place you want to be. Make the form popup or maximised and modal, this will stop the user from clicking anywhere else to move focus from the current form. Turn off all the forms close controls in the forms properties. Now you have a form you can open but not close. To close the form. Add a close button. Use the wizard to generate a button to close the current form (DoCmd.Close (lookup the syntax in help for your access version)) In the forms on open event, disable the close button (Me.ButtonName.Enabled = False) In the Control that is not to be Null, After Update event re-enable the button (Me.ButtonName.Enabled = true) (You may have to play with which event of the Control carries the Enable code) I hope I have explained carefully and that this solution helps you. Kindest Regards Mike -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "DEBRA" wrote: I WANT TO CREATE A MACRO OR VALIDATION OR MODULE THAT WOULD NOT ALLOW A FORM TO CLOSE IF A CERTAIN DATA FIELD WAS LEFT BLANK. I CAN SET VALIDATION RULES BUT I AM STUMPED ON HOW TO KEEP SOMEONE FROM ENTERING FURTHER INTO THE DATABASE UNLESS THEY SIGN IN PROPERLY. |
#4
|
|||
|
|||
KEEP FORM OPEN IF A FIELD IS BLANK
Thanks for the response Debra, if I can assist further, re-post here.
Regards Mike -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "DEBRA" wrote: Thank you. I am going to attempt this. "MikeJohnB" wrote: If I was trying to do this, this is how I would get to the same place you want to be. Make the form popup or maximised and modal, this will stop the user from clicking anywhere else to move focus from the current form. Turn off all the forms close controls in the forms properties. Now you have a form you can open but not close. To close the form. Add a close button. Use the wizard to generate a button to close the current form (DoCmd.Close (lookup the syntax in help for your access version)) In the forms on open event, disable the close button (Me.ButtonName.Enabled = False) In the Control that is not to be Null, After Update event re-enable the button (Me.ButtonName.Enabled = true) (You may have to play with which event of the Control carries the Enable code) I hope I have explained carefully and that this solution helps you. Kindest Regards Mike -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "DEBRA" wrote: I WANT TO CREATE A MACRO OR VALIDATION OR MODULE THAT WOULD NOT ALLOW A FORM TO CLOSE IF A CERTAIN DATA FIELD WAS LEFT BLANK. I CAN SET VALIDATION RULES BUT I AM STUMPED ON HOW TO KEEP SOMEONE FROM ENTERING FURTHER INTO THE DATABASE UNLESS THEY SIGN IN PROPERLY. |
#5
|
|||
|
|||
KEEP FORM OPEN IF A FIELD IS BLANK
One thing I forgot to mention is the fact that you will have to test for
valid entry of text in the Control. I have not included any code but you may have to do a lookup to a password and user table, if valid then enable the Control. Hope this helps -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "MikeJohnB" wrote: Thanks for the response Debra, if I can assist further, re-post here. Regards Mike -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "DEBRA" wrote: Thank you. I am going to attempt this. "MikeJohnB" wrote: If I was trying to do this, this is how I would get to the same place you want to be. Make the form popup or maximised and modal, this will stop the user from clicking anywhere else to move focus from the current form. Turn off all the forms close controls in the forms properties. Now you have a form you can open but not close. To close the form. Add a close button. Use the wizard to generate a button to close the current form (DoCmd.Close (lookup the syntax in help for your access version)) In the forms on open event, disable the close button (Me.ButtonName.Enabled = False) In the Control that is not to be Null, After Update event re-enable the button (Me.ButtonName.Enabled = true) (You may have to play with which event of the Control carries the Enable code) I hope I have explained carefully and that this solution helps you. Kindest Regards Mike -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "DEBRA" wrote: I WANT TO CREATE A MACRO OR VALIDATION OR MODULE THAT WOULD NOT ALLOW A FORM TO CLOSE IF A CERTAIN DATA FIELD WAS LEFT BLANK. I CAN SET VALIDATION RULES BUT I AM STUMPED ON HOW TO KEEP SOMEONE FROM ENTERING FURTHER INTO THE DATABASE UNLESS THEY SIGN IN PROPERLY. |
Thread Tools | |
Display Modes | |
|
|