Boogie Loogie
boogieloogie at gmail.com
Thu Dec 2 13:59:33 CST 2004
Hi I have a an A97 db and am trying to write some code to check to see if field exists. If it does not I need it added. Right now I am lost. Please help. CODE THUS FAR: If tdfChiz.Fields("dump").Name = "dump" Then AppendDeleteField tdfChiz, "DELETE", "dump" AppendDeleteField tdfChiz, "APPEND", "dump", dbBoolean Else AppendDeleteField tdfChiz, "APPEND", "dump", dbBoolean End If If the field "dump" does not exist right now I get an error telling as such. I don't need an error message I need the field added if it does not exist :) BTW AppendDeleteField is a function I got from the help menu. It works fine in case you are wondering. Thanks BL