Search results

  1. W

    Filter Function

    Alexandre, Thanks. I was trying to carry water in an envelope but I didn't know pails had been invented. Instr worked just fine. Warren
  2. W

    Filter Function

    Okay, here goes. Remember, to this point I am only trying to trap those records that satisfy a condition. (i.e. inclusion of a field from records in another table. Ergo the cross reference issue.Option Compare Database Function Cross_Ref() ' Off DoCmd.SetWarnings False Dim recIR_No...
  3. W

    Filter Function

    Alexandre, Thanks for your help. I may be using the function other than in its intended purpose. I am giving the function an array of 1 and asking if a string occurs in the given array. Based on what you have given me, it seems if the size of VarArr is greater than 0(zero), my answer is that...
  4. W

    Filter Function

    Can anyone give a brief example of the use of the Filter Function. i.e. Filter(sourcearray,match[,include[,compare]]). I am trying to use it in a module to identify those records where a match for a piece of text appears in a field so I can write a table of cross references. i.e. Create a...
  5. W

    Limit to field size in SQL statement

    Has anyone encountered a problem with size of memo fields when using VBA SQL to add records to a new table. The error message I am encountering is; Run Time error 3188 Could not update; currently locked by another session on this machine. As soon as I reduce the size of the field, it runs...
  6. W

    Autonumber field in Make Table query

    Problem solved programatically. Thanks Warren
  7. W

    Add an AutoNumber field(ADO)

    Can someone suggest the proper "Append" or "CreateField" statement to add an AutoNumber field to an existing table programatically in ADO? I have found an example for DAO but it does not work in an ADO environment. Warren
  8. W

    Autonumber field in Make Table query

    Is anyone aware of a way to add an AutoNumber field to a Make Table query in design view in MSAccess. I am trying to create a new field so that it starts at 1 and goes to number of records each time the query is run. Thanks, Warren [This message has been edited by wperzel (edited 03-12-2002).]
Back
Top Bottom