Search results

  1. 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...
  2. 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...
  3. 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
  4. 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