Hello!
First let me say that I am using Access 2010 and I do not have much experience using it.
I need advice on how to change the property of a field in a table programmatically.
I have a table in which one field has Required property set to "Yes". I would like to set this property by using VBA code to "No", then add data into a table using a query and re-set the Required property to "Yes".
Is this possible and if so, how can I do it?
Regards,
Frank
:banghead:
First let me say that I am using Access 2010 and I do not have much experience using it.
I need advice on how to change the property of a field in a table programmatically.
I have a table in which one field has Required property set to "Yes". I would like to set this property by using VBA code to "No", then add data into a table using a query and re-set the Required property to "Yes".
Is this possible and if so, how can I do it?
Regards,
Frank
:banghead: