Buttons, still looking...

thierry · Newbie Joined: 19 Jul 2005 Posts: 2

Well, have done a bit of Access but am newer to Oo Base... Question has popped-up a few times in the forum but answers not really usable it seems:

How do you tell a button on a form to open another form?

URL's don't seem to work with these objects (limited to files and www?) Drag and drop of form to URL container does not work for me either...

Thanks!
_________________
TCo

DrewJensen · Posted: Tue Jul 19, 2005 5:01 pm Post subject: Buttons - Events and URLS

Thierry

It seems to me as I read the forum that there is a bit of confusion about the two subjects you rase.

The first is the use of URL in places that new users expect to see FILENAME. Further in the case of the new OOO Base a URL in place of FORM NAME.

Specifically the use of a URL in the LoadComponentFromURL command.

As you seem to imply you 'get' the idea of converting an Operating System specific file name to URL , but the addition of database files that contain forms and reports seems not to mesh with the concept.

It's simple, in the case of form and report documents embedded in an OOo Base database file the URL is the name of the document.

So if I had a stand alone form document named Form1.odt, c:\dbForm\Form1.odt the URL would be:

"file:///C:/dbForms/Form1.odt"

If the same form where embedded in a database file its URL would be

"Form1"

The next thing about loading this embedded form that is different is WHICH component can actually perform the command LoadComponentFromURL for us.

In the case of our embedded form this could be handled ONLY by the DocumentContainer of the database file that holds the form.

So, if you tried to do something like this:

thierry · Newbie Joined: 19 Jul 2005 Posts: 2

Drew,

Thanks, this helps... but I did mention I was new to Oo! I went out and took a look at A. Pitonyak's doc on macros. Will need some time to digest! I tried copying the code you provided (I understand some of it but not all). Tried adding som DIM statements but something is still missing to get it working.

I am trying to run the macro in a Database called "Accounting' and I would like a button named "Go to members" residing on a form called "Welcome" to open another existing form in the same database that is named "Members".

Would I be abusing by asking you what the misdsing code is to get this working ?! I am sure a lot of others would be delighted to see a complete example!!

Many thanks
Thierry
_________________
TCo

millek · Newbie Joined: 23 Aug 2005 Posts: 1

Hi,

I have the same problem.

I understand from this topic that I have to insert change some code in the macros... but how to find the place where I should put this code? I open the Macro Organizer from the main OO window and get stuck.

Do I change (or create) new macro only for this button, or do I open a general macro which serves all buttons in a particular database, or do I influence the OpenOffice "build-in" macro which influences all databases I have on my computer?

Emilia

DrewJensen · Posted: Tue Aug 23, 2005 10:35 am Post subject: Brief example

Ok, I am not sure if this will help or not.

I will post something a bit more detailed about my way of working with forms, and events on the Code Snippet list in a day or two. But until then, here is a working example from a little utitlity I built for myself that I use a lot.

Here is a screen shot of a dialog box.

See the 'Open Forms buttont. It is attached in the 'On Initialize' event to this macro: