Form To Form Code Error

[MRadysh]

This is a code that I want to use on a command button to open a form.
It does not work and an error appears on:
OpenForm = formContainer.loadComponentFromURL("test","_blank",0,aProp())

Does anyone know how to fix this?

Thanks in advance.

REM----------------------------------------------------------------------------------------------------------
function OpenForm( formContainer as variant, oConnection as variant, sFormName as string) as variant
Dim aProp(2) As New com.sun.star.beans.PropertyValue
aProp(0).Name = "ActiveConnection"
aProp(0).Value = 1
aProp(1).Name = "OpenMode"
aProp(1).Value = "open"
REM OpenForm = formContainer.loadComponentFromURL("test","_blank",0,aProp())
OpenForm = formContainer.loadComponentFromURL("test","_blank",0,aProp())[/color]
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_Assets_Input( oev as variant )
sFormName = "SFAbrasion"
OpenForm( getFormsTC, getConnectionTC, sFormName )
end sub

[RPG]

Hello

I have post in the other forum a shorter example what only work with OOo3.1 and higher

Edit by Romke

[RPG]

Hello

I do not know if you still need this macro. Your question makes me clear that it is to difficult for people using the macro who exist. It was for also not easy for me. But now I succeed in making it a little less difficult.
The rest of the text is for all people

I do add again a openform macro on this forum.
Very much people want open a form with a macro and there are several macro's on this forum. I did post earlier an example. The first one was copied from other person. Later I did make an easier one with checking on errors and now this is again easier. It means I do under stand more the API.

For people who are starting with OOo base and with programming If you want open a form try first Switchboard of Benitez
http://www.baseprogramming.com/resources.html

For better understanding forms, do study his manual about forms
http://www.geocities.com/rbenitez22

If this is the first time you use macro's do study
this link
http://api.openoffice.org/basic/man/tutorial/tutorial.pdf
And the help file of you OOo basic give a lot information.

I will not explain all questions read the manuals.
I knew it very difficult to find good information so I also add some important links

You can search with macros I did post some macro's but Villeror and Voobase did post some nice examples for how to search without macro's
http://user.services.openoffice.org/en/forum/viewtopic.php?f=39&t=10036
http://www.oooforum.org/forum/viewtopic.phtml?t=80648
The last link is an example database

This macros is build on other macros read if you want this
http://www.oooforum.org/forum/posting.phtml

I hope this help you
I have edit this post so you can better read it

Romke





For inserting macros I add also text.

[RPG]

Hello

In OOo there are new capabilities one of them is how to open a form.
Opening and closing a form is much easier then before. You have to use the new predifine ThisDatabaseDocument object.

When you use this then you can open a form and closing a form. It is only capable to open a form in the current database. You can use it maybe also to open a form in an other database but I did not code it

The code I did wrote is a little long. The reason I did add some testing so you can knew where your problem exist. I hope this help you.

Romke

[RPG]

Tutorial about open a form with macros.

There are coming frequent questions about opening a form. Since OOo has embedded all in one document there are more ways to do it. Basicly there is no change for opening a form since OOo started.
you have to do:
a) Making a connection to the database
b) Open that form with the connection to the database.

When you design a database it is real important to design your tables careful. This makes no difference for OOo it is all the same. But when you use OOo it is also important to design careful how you want use the forms. You can have all the forms inside your database document or outside your database document even you can mixed it. It to the designer to make a choice. When you want open a form which is embedded in the database document with macros who are not embedded in the database and without running the database self then you have to take care that your data changes are written to the database. This method is not recommend.

Summary
When you want open a form there is now a difference between several thing
a) Open a stand alone form
Use the old method as in begin of this thread

b) Open an embedded form from outside the database.
This method is better not to use. There not all data automatic is stored in the database. You have to close the connection at the end.
When you need this methode I think it is better to bring your forms outside the database document

c) Open an embedded form from inside side the database document.
I think this is the best methode for most people and easy without complication

Romke

[eleleleelelelelelelele]

I used this code and it works great,

only 1 fix -
print oNewForm.implementationname
end
delete the end - it finishes the sub without continuing.

pitty I searched for 2 hours, and tryied so many other sample codes that didn't work, and tried to debug them before I reached this one - you should find a way to erase the wrong sample codes. maybe create a official site for sample codes - and there locate only the good ones.

[RPG]

Hello

Thank you for that point. I did not have seen it and you are the first who told it. I don't know why I did have removed it.

I have out comment the two lines

Romke