I'm attempting, via vba, to check if a field exists, if it doesn't, then create it. I have a handful of fields to apply this to. Any help is appreciated.
Thanks
I'm attempting, via vba, to check if a field exists, if it doesn't, then create it. I have a handful of fields to apply this to. Any help is appreciated.
Thanks
if you are want to fill in records on a form try looking at a if statement. http://www.techonthenet.com/access/f...ed/if_then.php
something like
if isnull(txtone) or len(txtone)=0 then
txtone="happy"
end if
it is unclear whether you wish to create a new field in a table or a new text control box on a form or both. but in any case the rationale to do this via vba on-the-fly is a stretch and definitely not something that is common.... perhaps it would be best if you explain the goal in more general terms as perhaps you have a fundamental design issue at play here...
jeffatwork,
Please tell readers why you would be adding fields via vba.
Perhaps you could give us some overview of your background/experience with database and access.