N
nortonm via AccessMonster.com
Hi - I've been trying to figure out how to do the following - create a macro
(or code) so users can enter a new column in a table, rename it, and change
the data type. It's a birdwatching DB, and this function is to allow the
user to create a new bespoke tick list in a table of lists (life list, county
list etc). The Data type seems to default to text, I need it to be Boolean,
or 'Yes/No'. I could also do with the users to be prompted to enter the name
of the new table somehow.
I created a macro that got as far as creating a new column in an existing
table, renaming the column (in quite a basic way, it just opened the table
with the column name highlighted and ready to change), but I couldn't change
the data type to 'Yes/No' with the macro, and I wouldn't have known how to
interrupt the macro and create a prompt for the user to rename the new column.
Any ideas? Many thanks in advance
Mark Norton
(or code) so users can enter a new column in a table, rename it, and change
the data type. It's a birdwatching DB, and this function is to allow the
user to create a new bespoke tick list in a table of lists (life list, county
list etc). The Data type seems to default to text, I need it to be Boolean,
or 'Yes/No'. I could also do with the users to be prompted to enter the name
of the new table somehow.
I created a macro that got as far as creating a new column in an existing
table, renaming the column (in quite a basic way, it just opened the table
with the column name highlighted and ready to change), but I couldn't change
the data type to 'Yes/No' with the macro, and I wouldn't have known how to
interrupt the macro and create a prompt for the user to rename the new column.
Any ideas? Many thanks in advance
Mark Norton