Using Visual Basic to Change Field Properties in Access Table 
Author Message
 Using Visual Basic to Change Field Properties in Access Table

Can anybody help me regarding changing the properties of
fields in a table by using visual basic. Specifically, I
am thinking of changing the following field properties by
using a macro. Any help or advice will be appreciated.

1)Required
2)Allow Zero Length
3)Indexed

Pele



Sat, 19 Nov 2005 01:42:04 GMT  
 Using Visual Basic to Change Field Properties in Access Table
Pele,

I do not think it is possible to do this with a macro.

However, I have given some sample vba code in your other thread on
this subject, which may help achieve your purpose.

- Steve Schapel, Microsoft Access MVP

Quote:

>Can anybody help me regarding changing the properties of
>fields in a table by using visual basic. Specifically, I
>am thinking of changing the following field properties by
>using a macro. Any help or advice will be appreciated.

>1)Required
>2)Allow Zero Length
>3)Indexed

>Pele



Sat, 19 Nov 2005 04:07:10 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Change Precision of a Field Within a Table using Visual Basic Code

2. Can you change field properties with Visual Basic?

3. Using Visual Basic to insert a table field

4. Urgent: how to change Access 2002 database password by using Visual basic 6.0

5. Urgent: how to change Access 2002 database password by using Visual basic 6.0

6. Urgent: how to change Access 2002 database password by using Visual basic 6.0

7. how to access pivot table in excel using visual basic

8. Create a table with a autonumberfield using Visual Basic for access

9. Error on Null field using Visual Basic Date function in Access

10. change from access basic into visual basic


 
Powered by phpBB® Forum Software © phpBB Group