Search results

  1. David Thorpe

    Setting table field default property in VBA

    Can anybody advise me how to go about setting the default property of a (text) field in a table from VBA? A database I have been using for years to run a local charity is now to be used by a group of other similar charities in the area. I have added a table that will hold details of each new...
  2. David Thorpe

    Table Field properties in ADOX

    All my attempts to set the Caption property of a field in an ADOX table have failed. Clearly I am missing something, but cannot figure out what it is. I understand from Access Help that this property must be "created and appended to the Properties collection of the object to which it applies"...
  3. David Thorpe

    Creating ADOX tables

    Can anybody advise me how to specify field parameters when creating ADOX tables? For instance, ".Columns.Append "ITEM", adWChar 16" generates a 16 character field - but how do I set the "Required" property to Yes, or specify a validation rule? I have tried to adapt a DAO method, but failed...
  4. David Thorpe

    Specifying (table) field parameters from VBA code

    I am new to code writing and am beginning, with the aid of a couple of doorstop sized text-books books, by generating tables. So far, I have managed to create tables with various field types, such as text, date, number, currency etc. What defeats me is how to code other properties such as...
Back
Top Bottom