At 18:12 15/04/2008 -0400, Drew Jensen wrote:
Brian Barker wrote:
At 19:43 15/04/2008 +0200, Frank Häusler wrote:
I created a simple database from an excel-sheet.
Now I created a form with the wizard ==> ok.
When I double-click the form to use it for data entry it does not work.
The opened Writer-Document shows in the
title-bar the name I gave to the form and the
additional text "(schreibgeschützt)" english: "(read only)".
I don't think this is a problem. The
"read-only" attribute applies, I think, to the
*format* of the form, not its contents. It
prevents the user changing the appearance or
layout of the form, but it doesn't prevent the
insertion of data and its saving to tables in the database.
I don't suppose anyone can help you if all you
say is that entering data "does not work".
Hello Frank, Brian
Well, the bottom line is simply this. Base files
that use spreadsheet data for the data source
are read only. It has nothing to do with the use
of a form - just opening a table object in this
Base file would render a read only result set also.
What Brian describes regarding the
'Read-only-ness' of the form is absolutely
correct but, as I say, in this specific case of not relevant.
Drew
What you say certainly applies to a database
created by *connecting* to a spreadsheet. But I
had taken the original questioner's description
of "creat[ing] a simple database from an
excel-sheet" to include the possibility that he
had pasted spreadsheet data into the database to
create a table. In this case, the table itself
should not be read-only and the form should allow
data entry, I think. My experimentation certainly suggests so.
And that may be his solution: he should copy the
spreadsheet data and paste it in (into the Tables
panel of the database so as to create a new
table) rather than connecting the database to the original spreadsheet.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
