In anticipation of my various Access deatabases being combined someday, I
would like to automatically populate a column on every record with a project
name I decide upon.
-MS Access 2007
-Users create records through forms created using the built-in feature to
create split forms.
-There are about 20 forms which create records for about 20 underlying tables.
-One separate database per project at this time. (Which is what we want for
now because we will not be networking the databases-- each project will be
separate mdbx, sometimes copied and moved around using USB jump drive.)
-It's OK for the value to be set rather manually and technically by me in
code for each copy of the database-- no need for form to create that value.