Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rsynan

    Filter by date selected in combobox

    I have a form with a combo box that has a select query as a Row Source. My code for the cboAfterUpdate event is below. When I select a date from the combo box, the combo box displays a blank and the form shows an empty record 1 of 1 (filtered) --no error message. I can't figure out what is...
  2. rsynan

    Finding closest match in string lookup

    Yes, I noticed that = sign. I took it out and ba-da-bing...it worked! That was a wonderful solution. Thanks again for helping me with this.
  3. rsynan

    Finding closest match in string lookup

    Sorry! It worked perfectly. I just had a typo. Thank you very much for the great solution. Made my day!!
  4. rsynan

    Finding closest match in string lookup

    I get this error: Syntax error (missing operator) in query expression '[MAIL_NAME]Like='Florida*".
  5. rsynan

    Finding closest match in string lookup

    I inserted the & "*" in the strLinkCriteria and it pulled up the subform but with a blank filtered record (1 of 1). I believe it does this when it doesn't find a match.
  6. rsynan

    Finding closest match in string lookup

    I have a main form where user enters the name of a business. The subform ("frm_NewMembersVerifyInvoiceFlag") pulls up the record, but only if user types an exact match (upper/lower case, spaces, punctuation, etc.) I would like to make this more flexible by having the user type in the...

Part and Inventory Search

Back
Top