Search results

  1. E

    fill in fields in a form

    Thanks for all your help. Got the thing to work with dbOpenSnapShot. Happy Coding to all. Ed
  2. E

    fill in fields in a form

    Public Sub SearchField3(Find As String, Co As String) Dim strSQL As String Dim db As Database Dim rs As Recordset strSQL = "Customers" Set db = CurrentDb() Set rs = db.OpenRecordset(strSQL) With rs Do While rs.NoMatch = True .MoveNext .FindFirst...
  3. E

    Recordsets

    you need an additional pair of ' ' around the inner " ". That will solve your string problem.
  4. E

    Forms

    Have you tried using a query to do that for you? Its much simpler than getting a form to do it.
  5. E

    'Add' records

    I have a query that imports one table into another. It duplicates the records from time to time but without any reason. What are some of the reasons why it could be doing this and can I get by without writting a query to find and delete the duplicates?
Top Bottom