Search results

  1. K

    search on numeric value

    The following works when I am searching a form on a value in a sub-form where the value is text ------------------------------- Private Sub find_boats_by_enq_no_Click() Dim stDocName As String Dim strSQL As String Dim trz As String trz = InputBox("Enquiry number??") stDocName =...
  2. K

    filter by form

    I'm using filter by form and have an issue with email addresses For example if I search on - "kenjones@somewhere.com" that's OK But if I search on - "ken.jones@somewhere.com" I get the following error message; "The expression you entered contains invalid syntax You may have entered an...
  3. K

    filter by form email address problem

    Hi Originally I posted this in "forms" last Friday so apols if you are seeing this again. Still unresolved I have a form displaying contact details. One of the fields being email address. Works fine until I enter an email address to search for with a "." before the "@". So It will search...
  4. K

    filter by form email address problem

    I have a form displaying contact details. One of the fields being email address. Works fine until I enter an email address to search for with a "." before the "@". So It will search for kenjones@ But ken.jones@ Will generate the following error "The expression you entered contains invalid...
  5. K

    deleting records

    I have two related tables, company is the one table, areas the many I want to be able to delete records in the many table that match the criteria of a field in company I have no problems selecting the records with the following; ----------- Private Sub areas_find_empty_records_Click() Dim...
  6. K

    filter main form by value in subform

    Hi I have a form (Company) with a subform (Areas Inc Lay Company) The subform has a combo box (country) (record#) and (areas#) are the related fields in the underlying tables With a command button (company_find_bareboat_operators_spain), on the main form I would like to filter records of...
  7. K

    filter by value in subform

    Hi I have a form (Company) with a subform (Areas Inc Lay Company) The subform has a combo box (country) (record#) and (areas#) are the related fields in the underlying tables With a command button (company_find_bareboat_operators_spain), on the main form I would like to filter records by the...
Back
Top Bottom