Search results for query: *

I need help with the following code. I need it to be able to handle the After_Update event when the text box is a Null, or if there is no match I would like to just cancel the whole process. Such as: If rs.NoMatch Then MsgBox "No Match" "Cancel entire...

I use the following code in a text box to jump to a certain record. The way it is now, if there is no record that matches, then it jumps to the first record in the table. How can I trap or identify when this code returns no match? I know it would be easy if it were a combo box (NotInList), but...

Can somebody help me with the following string. It's a date field and I have never done this with a date field. Not sure how to use the # and etc... I currently have it set for a text field, but that is just not working. Thank you: rs.FindFirst "[ActivityDate] = '" & Me![txtActivityDate] & "'"

I use the following code to jump to an account by entering an account number. I just need to put a little MsgBox error in there saying there is no such account number when a bad account number is entered. It originally was a Combo Box and the error simply went in the NotInList Event, however, it...

I have a combo box on a form that gathers data from a query, however, there are several hundred thousand or so records in there. I would really like to speed this process up by somehow doing the following. Maybe after a few characters are entered in the combo box, then it can populate with a...

I have a Form that is single form, and the subform is datasheet. I would like to have a combo box on the main form that when you enter a text value in it, it will jump to that same record in the subform. I don't want to filter just that record, I would only like the subform to jump to that...