Search results

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!

This might sound kind of strange, but I was wondering if there was a way to check if an item is "Not in List" without using a combo-box. Here is my situation: I have a field 'Employee ID' on a form, where the employee enters in their own ID number. My problem is that I need something that...

Whew! I went back to my original code.....and the problem arose in the fact that in the OnClick event to open up the second form, if an error occured (in the if statements) it wouldn't recognize that I needed the Do.Cmd Open Form to cancel too! I put this statement in after the If statements...

The problem with your (sorry, Rich) code, is that on my form I only want the certain fields specified as above to make the user input data into them. I have several other fields on this form that don't need to have info in them for the user to progress to the next form. Therefore if I only...

But it doesn't!!!! I can't get this to work!!!!!!!!!!!!!!!! Ok, here is what I have.... Private Sub work_orders_button_Click() On Error GoTo Err_work_orders_button_Click Dim strMsg As String, strTitle As String, stDocName As String strMsg = "Please enter a " strTitle = "...

Ok, I've placed this in the OnClick of the first form (to open the second form), and I now have the Msgbox pop up and prompt the user that a field is blank but when you click ok on the Msgbox it still opens up the second form and not allowing the user to correct the mistake. How do I cancel the...