Keith Clark wrote:
On Sat, 2008-06-14 at 16:36 +0100, Brian Barker wrote:
At 11:11 14/06/2008 -0400, Keith Clark wrote:
On Sat, 2008-06-14 at 16:04 +0100, Brian Barker wrote:
At 10:09 14/06/2008 -0400, Keith Clark wrote:
How can I change the size of a field after I've created it?
Are we talking database fields here?
o Select the relevant table and go to Edit | Edit... (or
right-click | Edit). This opens the Table Design window.
o Select the relevant field.
o If necessary, select the field type and use the drop-down menu
to choose a new type.
o If necessary, modify the parameters in the Field Properties area
at the bottom.
o Save the changes.
Sorry, yes, in Base.
After creating a table, I cannot go back and edit a field. Base
will not allow me to do that. They are all greyed out.
We are dangerously close to the limit of my knowledge of databases
here: indeed, we may have passed it! But I have one further
suggestion. Is this table an actual table in Base, or did you open a
connection to another document - perhaps an existing database or
spreadsheet, for example? If it is the latter, I think you will see
the effect you are describing. You may need to copy the data into a
new database instead of creating such a connection, I think.
Or you may need a database expert ...
I trust this helps.
Brian Barker
Nope, a real table created in Base.
Keith
You don't seem to be getting a lot of answers here, maybe because others
haven't had this experience -- I've generally had no problem with making
changes, so I don't know just what you're running into here. What OOo
version and OS are you running? Is there a primary key? Is that what you
are trying to change, or something else? Anyway, one thing that should
definitely work is to create a new table with the specs you want, then
right-click the name of your current table and choose Copy. Still in the
same pane, paste (Ctrl-V works fine) to bring up the import wizard, and
fill in the name of your new table, then the option to append the data.
You proably should run through the various "Next" options to make sure
everything is as expected, then Create. This should pick up all your
data properly into the new definition. If you had some queries, forms,
or reports based on the old table, you'll need to delete or rename the
original table and give the new version the correct name. The queries
should then work fine, but the forms and reports may need
tweaking/redefinition, depending on what kinds of changes were made..
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
