How do I see a form on an existing database

Creating and using forms

How do I see a form on an existing database

Postby liensche1@yahoo.com » Fri Apr 21, 2017 2:05 pm

Someone gave me a database to review. I open the form file in the database and I see a datasheet. I want to see the form that they created but I can't find how to get into form view in Apache OpenOffice Version 4 Database. Help!!!
Apache OpenOffice 4 for Windows. I have Windows 10.
liensche1@yahoo.com
 
Posts: 7
Joined: Fri Apr 21, 2017 1:53 pm

Re: How do I see a form on an existing database

Postby Villeroy » Fri Apr 21, 2017 3:18 pm

We know nothing about your database. I can only guess that you are talking about an MS Access database. In this case the creator may be able to generate an executable file from that database which would include all the GUI elements. Otherwise there is no way other than using MS Access.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24399
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Form View in Database

Postby liensche1@yahoo.com » Fri Apr 21, 2017 4:09 pm

How do I get a Form in OpenOffice into Form View and out of datasheet view. I have OpenOffice 4 for Windows. I received a file from someone using iMAC. I can't find an option anywhere on the screen to change the view of the form that he created. It is stuck in datasheet mode. Help!!
Apache OpenOffice 4 for Windows. I have Windows 10.
liensche1@yahoo.com
 
Posts: 7
Joined: Fri Apr 21, 2017 1:53 pm

Re: How do I see a form on an existing database

Postby liensche1@yahoo.com » Fri Apr 21, 2017 4:11 pm

No, I am using Apache OpenOffice 4 for Windows. Someone created a database in OpenOffice on his Mac and gave me the file for review. It is not MS Access.

I see the form he created in datasheet mode but I cannot get it to show the form view.
Apache OpenOffice 4 for Windows. I have Windows 10.
liensche1@yahoo.com
 
Posts: 7
Joined: Fri Apr 21, 2017 1:53 pm

Re: How do I see a form on an existing database

Postby liensche1@yahoo.com » Fri Apr 21, 2017 4:14 pm

I can see a form view when I am creating the form for the first time in Open Office. But when I come back and review the form, it only comes up in datasheet view.
Apache OpenOffice 4 for Windows. I have Windows 10.
liensche1@yahoo.com
 
Posts: 7
Joined: Fri Apr 21, 2017 1:53 pm

Re: How do I see a form on an existing database

Postby liensche1@yahoo.com » Fri Apr 21, 2017 4:31 pm

I found it. You have to start the Form Wizard and select "Modify Form." Then it comes in to form view. I am trying to see how he did it, not get a form to fill in a database. So sending me a GUI from his database is not what I need.
Apache OpenOffice 4 for Windows. I have Windows 10.
liensche1@yahoo.com
 
Posts: 7
Joined: Fri Apr 21, 2017 1:53 pm

Re: How do I see a form on an existing database

Postby liensche1@yahoo.com » Fri Apr 21, 2017 4:36 pm

Well, that did not work the same way twice. I don't know what I am doing wrong that I can't view a form in form view but only datasheet view.
Apache OpenOffice 4 for Windows. I have Windows 10.
liensche1@yahoo.com
 
Posts: 7
Joined: Fri Apr 21, 2017 1:53 pm

Re: Form View in Database

Postby liensche1@yahoo.com » Fri Apr 21, 2017 4:41 pm

I am trying to see how he set up his database. I am not using MS Access. I don't need an executable file. I need to switch view from datasheet to form view. I have OpenOffice 4 for Windows.
Apache OpenOffice 4 for Windows. I have Windows 10.
liensche1@yahoo.com
 
Posts: 7
Joined: Fri Apr 21, 2017 1:53 pm

Re: How do I see a form on an existing database

Postby charlie.it » Fri Apr 21, 2017 6:30 pm

Ciao, can you attach here your database? We could see if is all right.
charlie AOO Italian Forum Admin https://forum.openoffice.org/it/forum/index.php
Apache Open Office 4.1.3 - Libre Office 4.3.7 - NeoOffice 3.4.1
on Mac OSX 10.7.5 Lion / macOS 10.12.1 Sierra (dual boot)
User avatar
charlie.it
Volunteer
 
Posts: 263
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: How do I see a form on an existing database

Postby Villeroy » Sat Apr 22, 2017 11:31 am

Every table, query, form and report can be opened in 2 ways at least. You can open it for use (double-click) or you can open it for editing (right-click>Edit).
After opening a form for editing, you need the "Form Design" toolbar.
https://forum.openoffice.org/en/forum/v ... 666#p52666
https://forum.openoffice.org/en/forum/v ... 83&t=28235
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24399
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Forms

Who is online

Users browsing this forum: No registered users and 4 guests