How to find out if a FIELD exists.

[joebb3]

In my endevour to create an upgrade sub for my application, I have hit a wall (again! )

I can find out if a table exists, but what about a field inside a table? It seems that everything I do gives me an error and brings everything to a stop.

As a SIDE question, is an easy way to add a default or initial entry for every record in the new field?

You guys rock!
Joe

 

[smedvid]

You can loop through the feilds collection. I'll see if I have a code snippet for your reference... or u can search for that term... should be lots of examples on inet. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[stix4t2]

Each field in the table definition has a default value property you can set.

DAO allows you to open the tabledef and loop through the fields collections. ADO allows you to open a recordset and loop through the fields collections