[Solved] One final file

Discuss the database features
Post Reply
Popay57
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am

[Solved] One final file

Post by Popay57 »

Hello,
I'm quite newbie with OpenOffice, but I have big problems and I'm very desperate now.
Look, I have one table where I want to save some data like: name, job, date.... and one form to fill in this info.
When I fill in my form, data are in table, that's good, everything fine....
but now I want to create form, where will be two buttons:
1.button for watching saved data (name, job, date)
2.button for create new data in form, before safe
yes, I have got it now, buttons are in funkction, but NOW I have big problem!
I want this form for wider spectrum of people and many of them havent any idea about this program so I want only one file with that funkction: after start will be there only that two buttons, nothing more and these buttons will be active... I have big problem to solve that, I dont really know how can I do it

so in finaly:
I want file, where will be after double click only two function buttons(one will be ADD, second will be browse records)!
I dont want after double clicks to go to OpenOffice: BASE with normal layout, I want only that two buttons there....

I hope it's clear for now and also I hope it's possible to do it, Im very desperate... please try to help me....

thank you very much!
cheers Popay
Last edited by Popay57 on Wed Feb 17, 2010 6:52 pm, edited 1 time in total.
OpenOffice 3.1 on Windows Vista
Popay57
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am

Re: One final file

Post by Popay57 »

after double click on file I dont want to see this!

Image


I want only this after double click:

Image

It's possible??
OpenOffice 3.1 on Windows Vista
Popay57
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am

Re: One final file

Post by Popay57 »

Im using this macro:

Code: Select all

REM ***** BASIC *****
function OpenForm( formContainer as variant, oConnection as variant, sFormName as string) as variant 
Dim aProp(1) As New com.sun.star.beans.PropertyValue 
aProp(0).Name = "ActiveConnection" 
aProp(0).Value = oConnection 
aProp(1).Name = "OpenMode" 
aProp(1).Value = "open" 
OpenForm = formContainer.loadComponentFromURL(sFormName,"_blank",0,aProp()) 
end function 

function getFormsTC() as variant 
getFormsTC = thisComponent.Parent.getFormDocuments 
end function 

function getConnectionTC() as variant 
getConnectionTC = thisComponent.Drawpage.Forms(0).ActiveConnection 
end function 

sub OpenForm_Main_Form( oev as variant) 
sFormName = "MainForm"
OpenForm( getFormsTC, getConnectionTC, sFormName ) 
end sub 

sub OpenForm_Prehled_Nabidek( oev as variant) 
sFormName = "PrehledNabidek"
OpenForm( getFormsTC, getConnectionTC, sFormName ) 
end sub 
and when Im going to OPEN DATBASE PROJECT: in menu: SENT - CREATE MAIN DOCUMENT, Im going to create it... and after double click it's open exactly what I need, two buttons, but after click on one button it writes: getFormsTC = thisComponent.Parent.getFormDocuments >> Object variable not set. on this line

I dont really know what I have to do, thanks
OpenOffice 3.1 on Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: One final file

Post by Villeroy »

Open your form which is an ordinary Writer document stored in the Base document (a zip archive actually).
File>Save As... <some place>
Close the form
Open the file
View>Toolbars>Form Design
Turn on edit mode (button #2)
Turn on the form navigator (button #5)
Get the form properties, tab "Data"
Click the [...] near "Data Source", connect the form to the database file. If the database is a registered one you may pick the registered name from the combo box.
Reconnect all the form's subforms in the same manner if any.
Save the document.
Close the document.
Revoke write permissions from the file so the document gets loaded in the same read-only status as the embedded form.

Now you can:
- Create ordinary desktop links
- Use ordinary hyperlinks to other form documents
- Create subforms to pull related data from other databases.
 Edit: Since version 3.3 you can protect the form design and layout with a read-only password. 
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
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: One final file

Post by Villeroy »

Popay57 via PM wrote:hi there,
I cant do it, I dont know where is mistake :(
Do you think it's possible that I will send my files to you, when you will be able to solve that problem?
It will be really great if you will have time and you can help me, it's possible??
Please do not write personal messages unless it is a personal question out of public interest.
What is wrong with my description? At which point you get stuck?

[Forum] How to attach a document here
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
Popay57
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am

Re: One final file

Post by Popay57 »

ok, sorry
First steps are all right, than I set "Data source" thats good
but again it writes: getFormsTC = thisComponent.Parent.getFormDocuments >> Object variable not set. on this line

thanks for help!
OpenOffice 3.1 on Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: One final file

Post by Villeroy »

Turn off the macro trash. It's no longer needed when your forms are ordinary office documents
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
Popay57
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am

Re: One final file

Post by Popay57 »

what do you think about macro trash ? how can I make it?
OpenOffice 3.1 on Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: One final file

Post by Villeroy »

Having all your forms in some directory, you can easily call them by ordinary hyperlinks without any Basic code, just like that.
Insert>Hyperlink... Document...

Or using the buttons on your screenshot form:
Property Action: Open Document or URL
Property URL: file:///path/other_form.odt

You can add an ordinary desktop link to your start form, so you never see the database window.
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
Popay57
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am

Re: One final file

Post by Popay57 »

yes, that's goood
it works! but when I have hyperlink on some form, it's empy, normaly is full, but now it's empty, I dont know how can I connect filled info with this form....
EDIT: YESSSS, not it's working!!! thank you mate for help !!!!!!!! respect!
OpenOffice 3.1 on Windows Vista
Post Reply