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
|
|||
|
|||
form properties vs. VBA
I have a form which I set to allow additions (No edits, No Deletes). The
form only has 1 control - cotinuous form. On the form I have the control's x2 click property calling Allen Browne's popup calendar. My problem is that although the user cannot manually make changes to the data (a date) entered in previously, the x2 click event still get trigerred and the popup calendar can make the modification. How can I disable the event/popup when it is not a new entry? Thank you, QB |
#2
|
|||
|
|||
form properties vs. VBA
Answer my own question.
By comparing the CurrentRecord to teh RecordsetClone.RecordCount I can enable or not the popuo cal. QB "Question Boy" wrote: I have a form which I set to allow additions (No edits, No Deletes). The form only has 1 control - cotinuous form. On the form I have the control's x2 click property calling Allen Browne's popup calendar. My problem is that although the user cannot manually make changes to the data (a date) entered in previously, the x2 click event still get trigerred and the popup calendar can make the modification. How can I disable the event/popup when it is not a new entry? Thank you, QB |
#3
|
|||
|
|||
form properties vs. VBA
You can also determine if it is a new record with
If Me.NewRecord Then 'It is a new record End If -- Dave Hargis, Microsoft Access MVP "Question Boy" wrote: Answer my own question. By comparing the CurrentRecord to teh RecordsetClone.RecordCount I can enable or not the popuo cal. QB "Question Boy" wrote: I have a form which I set to allow additions (No edits, No Deletes). The form only has 1 control - cotinuous form. On the form I have the control's x2 click property calling Allen Browne's popup calendar. My problem is that although the user cannot manually make changes to the data (a date) entered in previously, the x2 click event still get trigerred and the popup calendar can make the modification. How can I disable the event/popup when it is not a new entry? Thank you, QB |
#4
|
|||
|
|||
form properties vs. VBA
Thank you Klatuu. I wasn't aware of that approach. Simpler is better (in my
mind)! "Klatuu" wrote: You can also determine if it is a new record with If Me.NewRecord Then 'It is a new record End If -- Dave Hargis, Microsoft Access MVP "Question Boy" wrote: Answer my own question. By comparing the CurrentRecord to teh RecordsetClone.RecordCount I can enable or not the popuo cal. QB "Question Boy" wrote: I have a form which I set to allow additions (No edits, No Deletes). The form only has 1 control - cotinuous form. On the form I have the control's x2 click property calling Allen Browne's popup calendar. My problem is that although the user cannot manually make changes to the data (a date) entered in previously, the x2 click event still get trigerred and the popup calendar can make the modification. How can I disable the event/popup when it is not a new entry? Thank you, QB |
#5
|
|||
|
|||
form properties vs. VBA
You won't find many people simpler than I g
-- Dave Hargis, Microsoft Access MVP "Question Boy" wrote: Thank you Klatuu. I wasn't aware of that approach. Simpler is better (in my mind)! "Klatuu" wrote: You can also determine if it is a new record with If Me.NewRecord Then 'It is a new record End If -- Dave Hargis, Microsoft Access MVP "Question Boy" wrote: Answer my own question. By comparing the CurrentRecord to teh RecordsetClone.RecordCount I can enable or not the popuo cal. QB "Question Boy" wrote: I have a form which I set to allow additions (No edits, No Deletes). The form only has 1 control - cotinuous form. On the form I have the control's x2 click property calling Allen Browne's popup calendar. My problem is that although the user cannot manually make changes to the data (a date) entered in previously, the x2 click event still get trigerred and the popup calendar can make the modification. How can I disable the event/popup when it is not a new entry? Thank you, QB |
Thread Tools | |
Display Modes | |
|
|