[Solved] One final file

[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

[Popay57]

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




I want only this after double click:



It's possible??

[Popay57]

Im using this macro:

Code: Select all   Expand viewCollapse view

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

[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.

[Villeroy]

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

[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!

[Villeroy]

Turn off the macro trash. It's no longer needed when your forms are ordinary office documents

[Popay57]

what do you think about macro trash ? how can I make it?

[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.

[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!