Recent content by ksgirl

ANYONE?

I've now tried this: Private Sub Form_Unload(Cancel As Integer) Dim strMsg As String, strTitle As String strMsg = "Please enter a " strTitle = " Missing Entry" If Me.Dirty Then If IsNull(Me![Reason for Modification]) Then ......Blah....Blah End If...

Thank you for your reply. But it still doesn't help me any. I understand that you think the code should be put in the BeforeUpdate event, and yes that would solve my "bypass" problem, but I'm still back to some kind of error.... the verification code works but doesn't leave the form open for...

Opps, I copied the wrong code for you. I did have the statements set up as If...Then/ElseIf....End IF, I've been playing around with it so much that it is hard to post something with the correct info. Anyway, here is what I did have on the Unload event: Private Sub Form_Unload(Cancel As...

This is the code I have for the missing field verification: Dim strMsg As String, strTitle As String strMsg = "Please enter a " strTitle = " Missing Entry" If IsNull(Me![Reason for Modification]) Then MsgBox strMsg & "Reason for Modification", vbInformation + vbOKOnly...

I've had this code on the Before-Update previously (look at my previous posts around 8-1-02), which it works, but the form closes without the user being able to go back and fill in the field. Someone suggested to put in the Unload event which solved my problem, until now. With the...

This is in reference to some of my previous post, but different, so here I am posting something new! I have a form set up so that the user has to fill in fields before they can exit the form. I have this in the unload event and it worked great until something was brought to my attention...

I currently have two forms where you enter info into them. You first have to fill out the first form, before you can proceed to the second form. I want a button on this second form that the user can select if they decide that the want to "exit without saving"..... I have code currently set up as...

Anyone? :confused:

I am still extremely confused!! I knew Pat would be to my rescue! I guess I'm not sure where to put these "new site" and "old side" parameters.... In the query? Why do you suggest putting them on the form? Are you talking about the Primary Key's (Clearance ID) new and old value? HELP...

I've been reading other posts that are similar to my problem, but I'm still left with a few questions to get me started. This is the post where you can find my source of information so far..... http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=17031 I have three forms...

Thanks, Tim! That totally slipped my mind..... I feel so stupid now.... I should have thought of that myself!! Thanks again!

Thanks for your reply Pat, and I do agree with you mostly. Let me explain where I'm coming from. This form is where a user enters information into the form to be saved in the tables. On the form is the "Employee ID" field, where the user has to put there ID in, so for that record there is an...

I think this might work, but I am getting an error!..... rs.FindFirst is highlighted.....and the error says "Compile Error. Data Member not found." I'm not sure what this means! Any suggestions?

Sure!!! I'd like to have a look at it! Anything is worth a try for me! Thanks!