[AccessD] Append properties to a new field

You have to trap the error and add the property for that field when the error is thrown.  There used to be code in the help file showing you how to create a property that included the handling for trapping the error.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Gray
Sent: Tuesday, September 12, 2006 3:37 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Append properties to a new field

Hi,

Would anyone have some code to create properties for a newly created field in a table def using DAO.

My code allows me to create properties for an existing field but if i try to test for the existence of a property in the newly created and appended field my error handler which will handle error 3270 'Property not found' stops working and I get the error message error 3270 'Property not found'. I am refreshing the Fields collection after appending the field.

Thanks in advance

David Gray
96 Springacre Rd
Thornlands QLD
Yahoo ID: flock_it_software
 



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com