Speeding up wor flow

[Amy Blankenship]

I lay out my table design in Word before I commit it to Access, and it's
pretty tedious copying and pasting each individual column name from the Word
table cell to Access. I've tried selecting multiple rows in the table
design view and pasting multiple column names into them, but so far no luck.
Is there a way to paste in more than one column name at a time into table
design view (or any other view) or am I stuck doing it one at a time?

TIA;

Amy

 

[Tim Ferguson]

I lay out my table design in Word before I commit it to Access, and it's
pretty tedious copying and pasting each individual column name

You could write a little bit of VBA in Word to read the document and make
up the SQL CREATE TABLE command and pass it to a DAO Database object. It's
the same code as you would use in Access only easier without trying to use
OLE automation.

Best wishes


Tim F

 

[Amy Blankenship]

Um, I already have all the names together...the problem is that Access does
not seem to accept the paste of the multiple columns. That's what the
question was about.

Thanks;

Amy

 

[Amy Blankenship]

The tables already exist, for the most part. I just want to add to them.
Are you saying that there's definitively no way to get the interface to
accept more than one column name in a paste at one time?

Thanks;

Amy

 

[Rick Brandt]

Um, I already have all the names together...the problem is that
Access does not seem to accept the paste of the multiple columns.
That's what the question was about.

Sorry, for some reason I was thinking of pasting from Access to Word.

 

[Tim Ferguson]

The tables already exist, for the most part. I just want to add to
them.

In that case, change the code to create an ALTER TABLE command instead...

Are you saying that there's definitively no way to get the
interface to accept more than one column name in a paste at one time?

I very much doubt it. It's not really a database type of thing to do -- if
you make a habit of messing about with your table definitions, you might be
better of junking Access and using Excel instead, which is designed to do
that very easily.

Best wishes


Tim F

 

[Amy Blankenship]

I'm in the design stage. You're telling me you don't keep rearranging
things when you're starting a project and the client keeps saying "and oh,
by the way, what about this data requirement I assumed your psychic ability
allowed you to pick up from the ether"? You must either be far better at
wringing that information out of your clients than I am, or else you have
ways of getting loads more power out of Excel than I think it's capable
of...

-Amy

 

[Rick Brandt]

I'm in the design stage. You're telling me you don't keep rearranging
things when you're starting a project and the client keeps saying
"and oh, by the way, what about this data requirement I assumed your
psychic ability allowed you to pick up from the ether"? You must
either be far better at wringing that information out of your clients
than I am, or else you have ways of getting loads more power out of
Excel than I think it's capable of...

You are probably not unique in your requirement to make lots of changes to
your table design in the early stages of a project. However; you could
very well be unique in having a requirement to document all of your
structures in Word so that all of this copying and pasting is going on.

If I need to make a change to the table I make a change to the table. I
find Access to be quite "self documenting" enough for me (at least when it
comes to table structures).

 

[Amy Blankenship]

Would be nice if I could just send a copy of the database to the client and
know they'd actually crack it open and look at it. But it's also a habit I
got into when I was sending designs to a SQL server administrator, and it
makes an easier read for doing table design in presentations, as well ;-).
Unless there are settings that let you change the text size so it is easier
to read...

-Amy