David Gray
david.gray at tpg.com.au
Tue Sep 12 20:47:54 CDT 2006
Hi Charlotte, Thanks for replying. Yes my code traps the 3270 'Property not found' error succesfully while adding properties for existing fields but if I add a new field and then try to add properties to that field my error trap is ignored and I get a standard error message. The same thing happens if I try to add a second field. David Gray -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, 13 September 2006 11:03 AM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com