Speeding up wor flow

  • Thread starter Thread starter Amy Blankenship
  • Start date Start date
A

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
 
Amy said:
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
Click to expand...

Throw together a quick temporary sub-routine to send the field names to the
Debug window...

Sub Temp
Dim tbl as TableDef
Dim fld as Field

Set tbl = CurrentDB.TableDefs("TableName")

For Each fld in tbl.Fields
Debug.Print fld.Name
Next fld
End Sub

From there you can copy and paste all of the names at once.
 
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
Click to expand...

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
 
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
 
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
 
Amy said:
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.
Click to expand...

Sorry, for some reason I was thinking of pasting from Access to Word.
 
The tables already exist, for the most part. I just want to add to
them.
Click to expand...

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?
Click to expand...

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
 
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
 
Amy said:
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...
Click to expand...

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).
 
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
 
Back
Top