[users] BASE - Form-Problem
Hello ! 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 did not set any option in the wizard that the data is for read only use. The database-file and the spreadsheet-file are not write-protected and I have full write-access through the filesystem to them. I'm using OOO 2.4.0 ; Windoze XP 64 Has anyone any idea ?? You are welcome. Best regards Frank Häusler - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] BASE - Form-Problem
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. One possibility, of course, is that the combination of fields that you have included in the form prevents you from adding essential data. If, for example, you have a field that is marked as Entry required but it does not appear in the form, then you will not be able to enter new records. This applies in particular to the primary key; you can avoid the problem in that case by setting this to AutoValue. I trust this helps. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] BASE - Form-Problem
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 -- OpenOffice.org User Community Forum: http://user.services.openoffice.org United States PostgreSQL Association: http://www.postgresql.us/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] BASE - Form-Problem
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]