[Solved] One final file
[Solved] One final file
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
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
Re: One final file
after double click on file I dont want to see this!
I want only this after double click:
It's possible??
I want only this after double click:
It's possible??
OpenOffice 3.1 on Windows Vista
Re: One final file
Im using this macro:
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
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
I dont really know what I have to do, thanks
OpenOffice 3.1 on Windows Vista
Re: One final file
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.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: One final file
Please do not write personal messages unless it is a personal question out of public interest.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??
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: One final file
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!
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
Re: One final file
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: One final file
what do you think about macro trash ? how can I make it?
OpenOffice 3.1 on Windows Vista
Re: One final file
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.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: One final file
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!
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