[Solved] One final file

Discuss the database features

[Solved] One final file

Postby Popay57 » Wed Feb 17, 2010 2:18 am

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

Postby Popay57 » Wed Feb 17, 2010 2:37 am

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

Postby Popay57 » Wed Feb 17, 2010 1:18 pm

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
OpenOffice 3.1 on Windows Vista
Popay57
 
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am

Re: One final file

Postby Villeroy » Wed Feb 17, 2010 2:51 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26983
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: One final file

Postby Villeroy » Wed Feb 17, 2010 5:19 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26983
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: One final file

Postby Popay57 » Wed Feb 17, 2010 5:27 pm

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
Popay57
 
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am

Re: One final file

Postby Villeroy » Wed Feb 17, 2010 5:32 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26983
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: One final file

Postby Popay57 » Wed Feb 17, 2010 6:08 pm

what do you think about macro trash ? how can I make it?
OpenOffice 3.1 on Windows Vista
Popay57
 
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am

Re: One final file

Postby Villeroy » Wed Feb 17, 2010 6:25 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26983
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: One final file

Postby Popay57 » Wed Feb 17, 2010 6:46 pm

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
Popay57
 
Posts: 6
Joined: Wed Feb 17, 2010 2:08 am


Return to Base

Who is online

Users browsing this forum: No registered users and 7 guests