[Solved] Controls don't have Data Tab
[Solved] Controls don't have Data Tab
I used the form wizard to create a form. All the controls were (apparently) added, but the only ones that have a "Data" tab are these for Date/Time format fields. I tried adding a control manually, and it still has the same issue. What am I missing?
Last edited by pruscoe on Mon Jun 19, 2017 10:55 pm, edited 1 time in total.
Open Office 4.1.3 on Windows 10.
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: Difficulty creating a form - controls don't have Data Ta
Ciao, attach your file here so we can see the problems better.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Re: Difficulty creating a form - controls don't have Data Ta
Here goes. It is a small database with only one newly-created form.
- Attachments
-
- DVDs.odb
- (10.81 KiB) Downloaded 366 times
Open Office 4.1.3 on Windows 10.
Re: Difficulty creating a form - controls don't have Data Ta
I downloaded your file, but the table seems to be linked to/located in an external file on your computer so could not use it or the form.
OpenOffice 4.1.12 on Windows 10
Re: Difficulty creating a form - controls don't have Data Ta
Oh - you're right. That is ANOTHER problem I haven't solved --- how to take a Miscosoft Access database, and, using OO, create a native one, independent of the old one. This forum won't let me upload an MDB file (seems a bit petty to me) so I can't send you the Access original.
Open Office 4.1.3 on Windows 10.
Re: Difficulty creating a form - controls don't have Data Ta
Open Office base will import the MS Access database.
Once you have it imported, save it as an Open Office Base file (.odb extension).
You will now have two databases. The one for MS Access and one for Open Office,
While the forum won't let you upload the MDB file, you can work around it by zipping the MDB file, then uploading the zip file or you can upload the MDB to a file sharing site (eg: Dropbox or MediaFire), then post a link to the uploaded file.
Once you have it imported, save it as an Open Office Base file (.odb extension).
You will now have two databases. The one for MS Access and one for Open Office,
While the forum won't let you upload the MDB file, you can work around it by zipping the MDB file, then uploading the zip file or you can upload the MDB to a file sharing site (eg: Dropbox or MediaFire), then post a link to the uploaded file.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Difficulty creating a form - controls don't have Data Ta
Yes, this database document is linked to the original MS Access file DVDs.mdb which is a good decision.
The wizard creates grouped pairs of labels and data aware controls. When you click on a control, you select the grouped pair and the properties dialog shows the common properties of both selected controls. Shift+Click selects one element. You should know that the form wizard is pretty stupid and you should know about the form navigator (5th button on toolbar "Form Design")
The wizard creates grouped pairs of labels and data aware controls. When you click on a control, you select the grouped pair and the properties dialog shows the common properties of both selected controls. Shift+Click selects one element. You should know that the form wizard is pretty stupid and you should know about the form navigator (5th button on toolbar "Form Design")
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Difficulty creating a form - controls don't have Data Ta
OK. Why is it a good decision to link to the original MDB? Regarding the rest of the response, the controls created by the wizard (and the ones I created manually) are not as you describe. Shift-Click does nothing, and click selects a box that comprises the name and what SHOULD be the control. But they are inseparable. The only exception is for date/time fields. (I'm perfectly happy creating my controls. i just wanted to use the wizard to get a head start.) I'll zip and attach the original MDB.
- Attachments
-
- DVDs.zip
- (28.28 KiB) Downloaded 354 times
Open Office 4.1.3 on Windows 10.
Re: Difficulty creating a form - controls don't have Data Ta
Open the form for editing
menu:View>Toolbars>Form Design
Click the 5th button.
It shows the form collection with its forms, subforms and the form controls belonging to forms and subforms.
It does not show the individual form controls that are bundled in table grids. Click the column header to show the properties of these controls.
You don't set upcomplicated database backends and then change them every time when you are going to change the frontend. Base is just a frontend.
menu:View>Toolbars>Form Design
Click the 5th button.
It shows the form collection with its forms, subforms and the form controls belonging to forms and subforms.
It does not show the individual form controls that are bundled in table grids. Click the column header to show the properties of these controls.
You don't set upcomplicated database backends and then change them every time when you are going to change the frontend. Base is just a frontend.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Difficulty creating a form - controls don't have Data Ta
Yes. Did that. I know how to edit forms. But the controls shown are NOT in a grid. And, to go back to my original point, when I look at the properties of ANY of the control (except type date/time) there is no "Data" tab. Are you able to open the database I uploaded, and see the form (there is only one?)
Open Office 4.1.3 on Windows 10.
Re: Difficulty creating a form - controls don't have Data Ta
By the way, there are only FOUR buttons in the Forms Toolbar - Open, Edit, Delete, Rename.
Open Office 4.1.3 on Windows 10.
Re: Difficulty creating a form - controls don't have Data Ta
The toolbar is named "Form Design"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Difficulty creating a form - controls don't have Data Ta
I don't have that option. My choices are Form/Query/Report/Standard/Table/Customize. Where should focus be when choosing View > toolbars?
Open Office 4.1.3 on Windows 10.
Re: Difficulty creating a form - controls don't have Data Ta
Villeroy wrote:Open the form for editing
menu:View>Toolbars>Form Design
Click the 5th button.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Difficulty creating a form - controls don't have Data Ta
OK. "Open in Design Mode" I did that (I already knew how to do that.) Yes, it shows all the controls created by the wizard. But with the original problem. So I guess what you are telling me is "don't use the wizard at all. Instead, insert all the controls manually with the Form Controls toolbar, for example." That was what I was trying to avoid. The example I provided was a simple one. But the one I really care about right now has a LOT more database fields.
Open Office 4.1.3 on Windows 10.
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Difficulty creating a form - controls don't have Data Ta
Rather than creating an Embedded database with all the attendent issues, it's better to start with a split database. Go toI haven't solved --- how to take a Miscosoft Access database, and, using OO, create a native one, independent of the old one.
viewtopic.php?f=83&t=61183
and download the file Split_HSQLDB_2.3.2_Wizard_v3d.odb
Create a directory to hold your database, and copy/move the downloaded file into the new directory. Since that will be your entry point into your new database, you can rename the file to something like DVDs.obd. Open the new file and a macro will run and a dialog will open. Follow the recommendations in the dialog to establish the connections for your new database.
One by one drag and drop each of the tables from your misbehaving database into the new one. You will get a copy dialog for each file. Select Copy definition and data. I noticed your table DVDs may not copy correctly. On the Type formatting page of the dialog check that all the fields have the correct Field type particularly the Date and Time fields. Also, right click on the ID field to set the Primary Key. If the copy reports errors you will need to delete the new table and start over on that table. Double check the Field type settings. The dialog defaults all Text fields to 50 characters, so you may need to change that if your source table has more characters. Once the tables have all been successfully copied you should be able to begin using the new database.
As Villeroy pointed out the Form Wizard is very limited, but it can be used to add a large number of fields from a single table (i.e.DVDs). The wizard will allow you to add a single SubForm, but beyond that you will need to use the Form Navigator to add other SubForms and controls.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Difficulty creating a form - controls don't have Data Ta
Thank you all for your help. The one thing that still hasn't been addressed is my original question. Why didn't the Form Wizard create controls I could actually use (after any necessary editing?)
Open Office 4.1.3 on Windows 10.
Re: Difficulty creating a form - controls don't have Data Ta
I have checked out your form, now that I have the mdb file, and find that all the controls DO have a Data tab. I think the problem maybe that when you just select a control you also by default also select its label so that clicking on Control gives the Properties of the 'Multiselection'. Instead, hold the Ctrl key down when selecting the field/control and then you will get the Properties of the text box or other control and the data tab will show.The one thing that still hasn't been addressed is my original question. Why didn't the Form Wizard create controls I could actually use (after any necessary editing?)
OpenOffice 4.1.12 on Windows 10
Re: Difficulty creating a form - controls don't have Data Ta
I hate to mix my topics, but now I can't open the form in design mode! The button at the bottom labeled "Open in Design Mode" has no effect. So I can't try what you suggested.
Open Office 4.1.3 on Windows 10.
Re: Difficulty creating a form - controls don't have Data Ta
Yes, Ctrl+Click is the correct action to select a member of a control group, not Shift+Click
This is how you call the forms navigator and select the single text box without its associated label: With a right-click on the grouped pair you can also ungroup the pair or enter the group.
This is how you call the forms navigator and select the single text box without its associated label: With a right-click on the grouped pair you can also ungroup the pair or enter the group.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Difficulty creating a form - controls don't have Data Ta
Select 'Forms', right-click on the form name and select 'Edit'but now I can't open the form in design mode! The button at the bottom labeled "Open in Design Mode" has no effect. So I can't try what you suggested.
OpenOffice 4.1.12 on Windows 10
Re: Difficulty creating a form - controls don't have Data Ta
Hooray! Thank you Villeroy and Nocton. The answer to my question (what am I doing wrong?) is "You're clicking, not CTRL-clicking!"
Open Office 4.1.3 on Windows 10.