[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Query: MS Access question



I'm using Access 97. You simply go to the table view; the fields will appear
as columns. Place you cursor close to where you want the new field/column to
appear; click on "Insert" on the toolbar on top; click on "column" and Bob's
your uncle. You can then rename the column to what you want, and go to
"design view" to set the properties (field length, etc).

You could also perform this operation completely in the design view.

Thomas J. Wood
Archivist
Archives/Special Collections LIB 144
University of Illinois at Springfield
P.O. Box 19243
Springfield IL 62794-9243
217-206-6520 | wood@uis.edu | http://www.uis.edu/~lib-arch


-----Original Message-----
From: Bridgette Kelly [mailto:BKelly@STANHYWET.ORG]
Sent: Friday, April 14, 2000 10:25 AM
To: ARCHIVES@LISTSERV.MUOHIO.EDU
Subject: Query: MS Access question


Hi all!  Just a question for those of you who have set-up & altered
forms in MS Access. We have been working on cataloging our staff
reference books in Access. All of the books are entered, but we need to
add a couple more fields. I know I've done this before, but I just can't
seem to remember how. After an hour, we got nowhere.
We found the field list, but what we need to do is add fields to the
field list. Anyone out there know how to do that? (The field list is the
one where you first create the fields, determine what type of info they
will have, and the size. This is different from the field property
listing.) Thanks for your help!!!

Bridgette A. Kelly
Special Collections Manager
Stan Hywet Hall & Gardens
714 N. Portage Path
Akron, OH 44303
Ph: 330-836-9075 ext. 132     f: 330-836-2680
Bkelly@stanhywet.org <mailto:Bkelly@stanhywet.org>

A posting from the Archives & Archivists LISTSERV List!

To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
      In body of message:  SUB ARCHIVES firstname lastname
                    *or*:  UNSUB ARCHIVES
To post a message, send e-mail to archives@listserv.muohio.edu

Or to do *anything* (and enjoy doing it!), use the web interface at
     http://listserv.muohio.edu/archives/archives.html

Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>

A posting from the Archives & Archivists LISTSERV List!

To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
      In body of message:  SUB ARCHIVES firstname lastname
                    *or*:  UNSUB ARCHIVES
To post a message, send e-mail to archives@listserv.muohio.edu

Or to do *anything* (and enjoy doing it!), use the web interface at
     http://listserv.muohio.edu/archives/archives.html

Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>