Recent content by OldBirdman

  1. O

    Run-time error '2185'

    Recover from a zero-rows condition.
  2. O

    Run-time error '2185'

    I am trying to have a program that does not lock up or give an error if my pseudo-filter does not return any rows. But apparently a bound form cannot work if there are no rows, even if the control is unbound.
  3. O

    Run-time error '2185'

    Interesting - Access 2000/2007, Windows XP Home on desktop, Access 2002, Windows XP Home on laptop. Access 2007 doesn't give same error, it clears the textbox and locks it. Can't type, so no error.
  4. O

    Run-time error '2185'

    I'm new here, didn't notice the post #'s. It is #6. I'm going to upload a sample of the problem. To test: 1) Enter "Ken" in the box in the footer and press "Apply Filter". 2 Records are shown. 2) Enter "Kenn" in the box, press "Apply Filter". 1 record is shown. 3) Enter "Kennn" in the box &...
  5. O

    Run-time error '2185'

    See my post of 10:42 AM Today (19 Jul08). Yes, me.recordsource = "" shows zero records, but it won't allow entry into the textbox either.
  6. O

    How do I trap error: "The text is too long to be edited."

    Apparently Access will not do DoCmd.RunCommand acCmdPaste in an Error routine processing a Paste-from-Clipboard. The code suggested by boblarson does work, and offers me a neat solution. Thanks again!
  7. O

    How do I trap error: "The text is too long to be edited."

    I didn't say I couldn't do it, I said I didn't understand it. In the past, when I do things I don't understand, like try to include some library, eventually it goes wrong, and I am stuck, 'cause I don't understand so I can't debug. Thank you for considering my problem.
  8. O

    Run-time error '2185'

    Still the question from above, "I can know that I have zero records before the Me.RecordSource assignment, but I don't know what else to do to display nothing." What standard SQL will display nothing? I can change the .Visible of all controls to False if zero records, and leave the RecordSource...
  9. O

    Run-time error '2185'

    I think you missed the point. Once the RecordSource query returns zero records, the program stops functioning correctly. Even though the control is unbound and should not be affected by the query, apparently it is. Zero records is, however, a valid result. I need some way to show a blank...
  10. O

    How do I trap error: "The text is too long to be edited."

    I checked your reference, but that is too far beyond my understanding to even consider. I'll stick with DoCmd and accept that it doesn't always work. Thank you for considering may problem.
  11. O

    Run-time error '2185'

    My goal is to build an SQL statement to assign into the form's RecordSource property. I want to type into a textbox, then have a command "Apply Filter" that does: Me.RecordSource = "SELECT . . . WHERE . . . Like """ & txtName & "*""" If txtName = "Ken", the names Ken and Kenneth are found. But...
  12. O

    How do I trap error: "The text is too long to be edited."

    Thank you! I didn't understand Form_Error, and was trying to use Err.Number, which was zero. Where are these DataErr codes listed, and where is information about what the "Response as Integer" parameter is, and what I can do with it? I can now trap the error, and display a meaningful message. I...
  13. O

    Run-time error '2185'

    Run-time error '2185' You can't reference a property or method for a control unless the control has the focus. Private Sub txtName_Change() strSaveText = Me.txtName.Text End Sub The message occurs for Me.txtName.Text and only if the body of the form contains zero records. What's wrong?
  14. O

    How do I trap error: "The text is too long to be edited."

    This message occurs if I try to paste a string from the clipboard into a bound textbox control when the bound field is smaller than the data being pasted. How can I trap this error?
  15. O

    Run-time Error 2118 - You must save the current field before you run the Requery acti

    Private Sub cboQuickList_Click() . . . Forms!fAAA.cboQuickList.Requery Forms!fAAA.cboQuickList.Visible = True Forms!fAAA.cboQuickList.Dropdown End Sub I am clicking the Dropdown list of a combobox. Therefore, it is visible, enabled, and after the click has the focus. The...
See more
Back
Top Bottom