Re: How did you complete this?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks very much for your reply - after what you said I thought maybe a
better way to do it would be to create a lists table with one column for the
species, and have tick lists as columns representing a different type of list,
thereby merely extending an individual table rather than creating a new table
every time a new list was needed. As you said, the latter would be complete
overkill. The number of lists would in mosts cases level off at about 10 or
12 - there are only so many lists a person needs - even birdwatchers!

So 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. (I'm happy to do it all straight into the table, but if other
people want to use the database themselves, messing about with the tables may
not be the best; a macro or command buttons would be much better)

I created a (pretty basic - standard access operators) 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 actual table
with the column name highlighted and ready to change), but I couldn't change
the data type to 'Yes/No' (Boolean) with the macro; it would also need to be
a tick box for the users.

I wouldn't have known how to interrupt the macro and create a prompt for the
user to rename the new column, which would be far preferable to opening the
actual table to do it. I have been racking my brains, maybe put three macros
on a form, 1 to create the column, 1 to rename it, and one to change the data
type - a 3 part list creation process.

Any ideas? Is this too big a request for this arena? Many thanks in advance
for any advice

Mark Norton



John W. Vinson wrote:
Hi - apologies first, I'm a pretty low level user. Could you tell me how you did this - module? Macro? Not sure what to do with your code. I want to create a fairly simple function - basically I want (users to be able) to Copy a table, then rename it, but ad-hoc/prompted rather than specifying the name in the CopyObject macro. I’m creating a simple Birdwatching program, and the copied table is a new type of list e.g. Life List, County List, Year List etc

Many Thanks

NONE of these should be in Tables. Instead you should use a Query with
criteria. You can display a query data***, or base a Form on the query, or
base a Report on the query, or export the query, or... take your pick.
Creating a new table for every subset of the data just clutters your database
with tables of forgotten meaning, bloats your database and ruins performance.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200809/1

.

Quantcast