Recent content by Catennacio

Guys sorry for the confusion... and thanks for your replies.. I tried this and it worked... but now I want to use this approach for the Allow Zero Length string property too... I tried: Set prp1 = fd.CreateProperty prp1.Name = "Allow Zero Length" prp1.Type = dbBoolean prp1.Value = true...

No.. I want to write a stand alone VB app to modify the current structure of my DB...

That library has already been included..

Thanks for your reply, I tested the code and got compile error "Variable not defined" at the CurrentDb. Probably because I haven't set the DAO object yet.. how to create and point it to the desired database? (I said I'm very new to this project and just jumped in as backup when someone is on...

Thanks for your quick reply. I'm new to DAO, so I have a few questions: - Does your code create a new property in the existing column or does it update an existing column with Input Mask = ""? - How do I set up the "CurrentDb"? I want to update an existing column making it a password column, so...

Hi all, My project requires writing a VBA program to update our customer database structure, including changing the "Allow Zero Length" property of a column and also change Input Mask for that column to "PASSWORD". I know how to set the "Allow Zero length" property for a column but I have...