Recent content by David Thorpe

Re setting table field parameters via VBA Had I been starting from scratch, your comments would be perfectly valid. However, a database that I have developed for my sole use (over the past 6 years) is now desired by a number of other users. I am very happy to give it to them for free, but they...

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...

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"...

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...

Mark, Thank you for your very quick response - but I am not sure your solution will work for me. I said I was new to this coding business and now realise I should have mentioned that I am working in ADO mode (as my doorstop text-books recommend this) and not DAO (last week I did not know the...

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...