Question for help to create specs to enhance Push Button to open Form or Report

Hello users@dba
Im new here and im only a Base user.

But i read once, if ideas or specs for things you want exist,
sometimes there is an programmer and takes it.

One of my favorite things i miss in Base is, to open a form or
report from inside the database, without knowledge from macro
programming. This was also on the Feature Poll list.

So i want to give something back an tried to make a detailed feature
wish. My second step is now to find someone who is interested to
have a look and could give me feedback. Who will help to take a look
if this idea is "releaseable".
Please feel free to change or expand the suggestions like the way
that open source works. Today, this paper only describes the way i
thought, what the user has to do, to open a form or report with a
push button.

With OOo 3.1.0 will be a new "basic" something implement.
ThisDatabaseDocument.FormComponents.getByName( "form name" ).open

I thought with this implemention it could be possible to enhanced
the Push Button Actions to open forms and reports from inside a
database. But i thought that there is something more needed then
only to open a form or report by double click.

Please let me know if you are interested to have a closer look to
the start suggestion. I will send it to you.
It would be also helpfull, if there is someone interested who know
the next steps what to do with this paper after that.

Thanks in advance.
Ulf Dietrich

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Frank Schoenheit, Sun Microsystems Germany]

Hi Ulf,

> One of my favorite things i miss in Base is, to open a form or
> report from inside the database, without knowledge from macro
> programming. This was also on the Feature Poll list.
>
> So i want to give something back an tried to make a detailed feature
> wish. My second step is now to find someone who is interested to
> have a look and could give me feedback. Who will help to take a look
> if this idea is "releaseable".

Interesting. I don't have too much time for a detailed review, not to
mention a comprehensive discussion, but would definitely be interested
in having a look.

Perhaps uploading your ideas to some public place
(http://dba.openoffice.org/servlets/ProjectDocumentList?) is a good
idea? (Personally, I think the Wiki would be a good place, too. But
editing a Wiki article is more cumbersome than writing a text doc, so
... your decision.)

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Frank Schoenheit, Sun Microsystems Germany]

Hi Ulf,

one thing, in addition to my previous mail:

> With OOo 3.1.0 will be a new "basic" something implement.
> ThisDatabaseDocument.FormComponents.getByName( "form name" ).open

My suggestion here: When describing a new feature, don't let you (too
much) inspire by existing (or possibly new) API. This is something the
developer needs to care for, and a topic of its own. Try focusing on the
end user experience instead. Otherwise, existing/new implementations
might influence you into a possibly wrong direction.

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Mechtilde Stehmann-2]

Hello Ulf,*,

I will have a look at it.

Regards

Mechtilde
Ulf schrieb:

> Hello users@dba
> Im new here and im only a Base user.
>
> But i read once, if ideas or specs for things you want exist,
> sometimes there is an programmer and takes it.
>
> One of my favorite things i miss in Base is, to open a form or
> report from inside the database, without knowledge from macro
> programming. This was also on the Feature Poll list.
>
> So i want to give something back an tried to make a detailed feature
> wish. My second step is now to find someone who is interested to have a
> look and could give me feedback. Who will help to take a look if this
> idea is "releaseable".
> Please feel free to change or expand the suggestions like the way
> that open source works. Today, this paper only describes the way i
> thought, what the user has to do, to open a form or report with a
> push button.
>
> With OOo 3.1.0 will be a new "basic" something implement.
> ThisDatabaseDocument.FormComponents.getByName( "form name" ).open
>
> I thought with this implemention it could be possible to enhanced
> the Push Button Actions to open forms and reports from inside a
> database. But i thought that there is something more needed then
> only to open a form or report by double click.
>
> Please let me know if you are interested to have a closer look to
> the start suggestion. I will send it to you.
> It would be also helpfull, if there is someone interested who know
> the next steps what to do with this paper after that.
>
> Thanks in advance.
> Ulf Dietrich
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>

--
Dipl. Ing. Mechtilde Stehmann
## http://de.openoffice.org
## Ansprechpartnerin für die deutschsprachige QA
## Freie Office-Suite für Linux, Mac, Windows, Solaris
## Meine Seite http://www.mechtilde.de
## PGP encryption welcome! Key-ID: 0x53B3892B


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[egwjens]

Hello

I got a similar problem,

just want to insert a button, to open an other form or report from a previous form. Only button actions are submit, new, reload, save data etc...

normaly, someone has to "step into" the control center of OO Base and find all the other tools, when he wants to open a new form. It is not very client or user friendly.

So, to open a form from an desktop icon, and then to jump from Base form to Base form via buttons looks for me much more user friendly.

I would also like, if the Base form is just in a frame/window, again without the tools of writer.

I dont believe, that this problem is not adressed, if anyone knows help here....

Greetings
Jens

Mechtilde Stehmann-2 wrote:

Hello Ulf,*,

I will have a look at it.

Regards

Mechtilde
Ulf schrieb:
> Hello users@dba
> Im new here and im only a Base user.
>
> But i read once, if ideas or specs for things you want exist,
> sometimes there is an programmer and takes it.
>
> One of my favorite things i miss in Base is, to open a form or
> report from inside the database, without knowledge from macro
> programming. This was also on the Feature Poll list.
>
> So i want to give something back an tried to make a detailed feature
> wish. My second step is now to find someone who is interested to have a
> look and could give me feedback. Who will help to take a look if this
> idea is "releaseable".
> Please feel free to change or expand the suggestions like the way
> that open source works. Today, this paper only describes the way i
> thought, what the user has to do, to open a form or report with a
> push button.
>
> With OOo 3.1.0 will be a new "basic" something implement.
> ThisDatabaseDocument.FormComponents.getByName( "form name" ).open
>
> I thought with this implemention it could be possible to enhanced
> the Push Button Actions to open forms and reports from inside a
> database. But i thought that there is something more needed then
> only to open a form or report by double click.
>
> Please let me know if you are interested to have a closer look to
> the start suggestion. I will send it to you.
> It would be also helpfull, if there is someone interested who know
> the next steps what to do with this paper after that.
>
> Thanks in advance.
> Ulf Dietrich
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [e-mail]
> For additional commands, e-mail: [e-mail]
>
>


--
Dipl. Ing. Mechtilde Stehmann
## http://de.openoffice.org
## Ansprechpartnerin für die deutschsprachige QA
## Freie Office-Suite für Linux, Mac, Windows, Solaris
## Meine Seite http://www.mechtilde.de
## PGP encryption welcome! Key-ID: 0x53B3892B


---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]

[Alex Thurgood]

Hi all,

The funny thing about this is that this functionality used to work in StarOffice 5.1. I used to have a form, which was obviously a StarOffice Writer document at the time, with four buttons on it. Each one was configured to open another form (i.e. another document), and as I recall (because I don't still have those documents around), the button could be linked to a file URL which would then automatically load the other form. I could also put a nice little picture as the background to the button.

My guess is that this functionality went away when Sun got rid of the StarDesktop environment...but I could be wrong ;-)


Alex


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Alex Thurgood wrote:
> Hi all,
>
> The funny thing about this is that this functionality used to work in StarOffice 5.1. I used to have a form, which was obviously a StarOffice Writer document at the time, with four buttons on it. Each one was configured to open another form (i.e. another document), and as I recall (because I don't still have those documents around), the button could be linked to a file URL which would then automatically load the other form. I could also put a nice little picture as the background to the button.
>
> My guess is that this functionality went away when Sun got rid of the StarDesktop environment...but I could be wrong ;-)
>
>  
Hi Alex,

Actually the functionality didn't change at all - that is kind of the
problem.
Add a button to a document and you can still open another document or a
web page.
This works if the button happens to be on a form embedded in an ODB file
just as well as if it where on a stand alone Writer file. The only thing
you CAN NOT do is open a form, or report embedded in an ODB file, not
even the same one with the form containing the button. (or a query def,
or a dataview)

So it's not that any functionality was lost when the suite went from 1.x
to 2.0 it was that no functionality to support the new Base module was
added.

Drew



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[egwjens]

Hi Guys,

thats strange.... on the one side, ready-made-buttons seems to exist, but not in special cases, like a base form in the same container (odb).

Why has Sun not created such easy thing?

To present to many functions on a screen is playfull, but stress for ´Non-techies', so simplicity is beautiful. A simply function, assigned to a form, which shows only the "client-mode", without all the tools, would be really good.  

It must be so easy, to offer such an functionalitiy, and lots of questions in the forums would just disapear.

I have recieved now an macro code for opening a new form, but still the paramters are not included:

REM  *****  BASIC  *****

Sub openFormByTag(oEv)
REM OOo3.0: Reads the form name from a calling control's tag
cWhat = com.sun.star.sdb.application.DatabaseObject.FORM
oModel = oEv.Source.getModel()
sName = oModel.Tag
oView = oModel.Parent.Parent.Parent.Parent.getCurrentController()
oView.loadComponent(cWhat, sName, FALSE)
End Sub

And fill the paramter in the "Additional Information" tag. in the control/function panel of the button.

Hope that this is working fine, but still the parameters, which identifies the next data sentence in the next from are missing.

How do I pass on datas from one form to the next form?

Greetings
Jens

Drew Jensen wrote:

Alex Thurgood wrote:
> Hi all,
>
> The funny thing about this is that this functionality used to work in StarOffice 5.1. I used to have a form, which was obviously a StarOffice Writer document at the time, with four buttons on it. Each one was configured to open another form (i.e. another document), and as I recall (because I don't still have those documents around), the button could be linked to a file URL which would then automatically load the other form. I could also put a nice little picture as the background to the button.
>
> My guess is that this functionality went away when Sun got rid of the StarDesktop environment...but I could be wrong ;-)
>
>  
Hi Alex,

Actually the functionality didn't change at all - that is kind of the
problem.
Add a button to a document and you can still open another document or a
web page.
This works if the button happens to be on a form embedded in an ODB file
just as well as if it where on a stand alone Writer file. The only thing
you CAN NOT do is open a form, or report embedded in an ODB file, not
even the same one with the form containing the button. (or a query def,
or a dataview)

So it's not that any functionality was lost when the suite went from 1.x
to 2.0 it was that no functionality to support the new Base module was
added.

Drew



---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]

[frazelle09]

egwjens wrote:

> Hello
>
> I got a similar problem,
>
> just want to insert a button, to open an other form or report from a
> previous form. Only button actions are submit, new, reload, save data etc...
>
> normaly, someone has to "step into" the control center of OO Base and find
> all the other tools, when he wants to open a new form. It is not very client
> or user friendly.
>
> So, to open a form from an desktop icon, and then to jump from Base form to
> Base form via buttons looks for me much more user friendly.
>
> I would also like, if the Base form is just in a frame/window, again without
> the tools of writer.
>
> I dont believe, that this problem is not adressed, if anyone knows help
> here....
>
> Greetings
> Jens
>
>
> Mechtilde Stehmann-2 wrote:
>  
>> Hello Ulf,*,
>>
>> I will have a look at it.
>>
>> Regards
>>
>> Mechtilde
>> Ulf schrieb:
>>    
>>> Hello users@dba
>>> Im new here and im only a Base user.
>>>
>>> But i read once, if ideas or specs for things you want exist,
>>> sometimes there is an programmer and takes it.
>>>
>>> One of my favorite things i miss in Base is, to open a form or
>>> report from inside the database, without knowledge from macro
>>> programming. This was also on the Feature Poll list.
>>>
>>> So i want to give something back an tried to make a detailed feature
>>> wish. My second step is now to find someone who is interested to have a
>>> look and could give me feedback. Who will help to take a look if this
>>> idea is "releaseable".
>>> Please feel free to change or expand the suggestions like the way
>>> that open source works. Today, this paper only describes the way i
>>> thought, what the user has to do, to open a form or report with a
>>> push button.
>>>
>>> With OOo 3.1.0 will be a new "basic" something implement.
>>> ThisDatabaseDocument.FormComponents.getByName( "form name" ).open
>>>
>>> I thought with this implemention it could be possible to enhanced
>>> the Push Button Actions to open forms and reports from inside a
>>> database. But i thought that there is something more needed then
>>> only to open a form or report by double click.
>>>
>>> Please let me know if you are interested to have a closer look to
>>> the start suggestion. I will send it to you.
>>> It would be also helpfull, if there is someone interested who know
>>> the next steps what to do with this paper after that.
>>>
>>> Thanks in advance.
>>> Ulf Dietrich
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@...
>>> For additional commands, e-mail: users-help@...
>>>
>>>
>>>      
>> --
>> Dipl. Ing. Mechtilde Stehmann
>> ## http://de.openoffice.org
>> ## Ansprechpartnerin für die deutschsprachige QA
>> ## Freie Office-Suite für Linux, Mac, Windows, Solaris
>> ## Meine Seite http://www.mechtilde.de
>> ## PGP encryption welcome! Key-ID: 0x53B3892B
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@...
>> For additional commands, e-mail: users-help@...
>>
>>
>>
>>    
>
>  

Wow, if we could get this in Base, it would be like reaching some sort

of a Gold Standard or something.

Have a great evening!  :-)

[frazelle09]

FamiliaFrazelle wrote:

> egwjens wrote:
>> Hello
>>
>> I got a similar problem,
>>
>> just want to insert a button, to open an other form or report from a
>> previous form. Only button actions are submit, new, reload, save data
>> etc...
>>
>> normaly, someone has to "step into" the control center of OO Base and
>> find
>> all the other tools, when he wants to open a new form. It is not very
>> client
>> or user friendly.
>>
>> So, to open a form from an desktop icon, and then to jump from Base
>> form to
>> Base form via buttons looks for me much more user friendly.
>> I would also like, if the Base form is just in a frame/window, again
>> without
>> the tools of writer.
>> I dont believe, that this problem is not adressed, if anyone knows help
>> here....
>>
>> Greetings
>> Jens
>>
>> Mechtilde Stehmann-2 wrote:
>>  
>>> Hello Ulf,*,
>>>
>>> I will have a look at it.
>>>
>>> Regards
>>>
>>> Mechtilde
>>> Ulf schrieb:
>>>    
>>>> Hello users@dba
>>>> Im new here and im only a Base user.
>>>>
>>>> But i read once, if ideas or specs for things you want exist,
>>>> sometimes there is an programmer and takes it.
>>>>
>>>> One of my favorite things i miss in Base is, to open a form or
>>>> report from inside the database, without knowledge from macro
>>>> programming. This was also on the Feature Poll list.
>>>>
>>>> So i want to give something back an tried to make a detailed feature
>>>> wish. My second step is now to find someone who is interested to
>>>> have a
>>>> look and could give me feedback. Who will help to take a look if this
>>>> idea is "releaseable".
>>>> Please feel free to change or expand the suggestions like the way
>>>> that open source works. Today, this paper only describes the way i
>>>> thought, what the user has to do, to open a form or report with a
>>>> push button.
>>>>
>>>> With OOo 3.1.0 will be a new "basic" something implement.
>>>> ThisDatabaseDocument.FormComponents.getByName( "form name" ).open
>>>>
>>>> I thought with this implemention it could be possible to enhanced
>>>> the Push Button Actions to open forms and reports from inside a
>>>> database. But i thought that there is something more needed then
>>>> only to open a form or report by double click.
>>>>
>>>> Please let me know if you are interested to have a closer look to
>>>> the start suggestion. I will send it to you.
>>>> It would be also helpfull, if there is someone interested who know
>>>> the next steps what to do with this paper after that.
>>>>
>>>> Thanks in advance.
>>>> Ulf Dietrich
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: users-unsubscribe@...
>>>> For additional commands, e-mail: users-help@...
>>>>
>>>>
>>>>      
>>> --
>>> Dipl. Ing. Mechtilde Stehmann
>>> ## http://de.openoffice.org
>>> ## Ansprechpartnerin für die deutschsprachige QA
>>> ## Freie Office-Suite für Linux, Mac, Windows, Solaris
>>> ## Meine Seite http://www.mechtilde.de
>>> ## PGP encryption welcome! Key-ID: 0x53B3892B
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@...
>>> For additional commands, e-mail: users-help@...
>>>
>>>
>>>
>>>    
>>
>>  
> Wow, if we could get this in Base, it would be like reaching some sort
> of a Gold Standard or something.
>
> Have a great evening!  :-)
>

[egwjens]

Hi,

is not gold-standard, or over-the-mOOn 3.0...


It is just a simple tool,  in OO Base are allready so many similar tools included, look at the connection between Subform and Form...

just something between Form and Form,

Does your attachment includes something like that? What is the purpose of your attachment?

Thanks,
Jens

frazelle09 wrote:

egwjens wrote:
> Hello
>
> I got a similar problem,
>
> just want to insert a button, to open an other form or report from a
> previous form. Only button actions are submit, new, reload, save data etc...
>
> normaly, someone has to "step into" the control center of OO Base and find
> all the other tools, when he wants to open a new form. It is not very client
> or user friendly.
>
> So, to open a form from an desktop icon, and then to jump from Base form to
> Base form via buttons looks for me much more user friendly.
>
> I would also like, if the Base form is just in a frame/window, again without
> the tools of writer.
>
> I dont believe, that this problem is not adressed, if anyone knows help
> here....
>
> Greetings
> Jens
>
>
> Mechtilde Stehmann-2 wrote:
>  
>> Hello Ulf,*,
>>
>> I will have a look at it.
>>
>> Regards
>>
>> Mechtilde
>> Ulf schrieb:
>>    
>>> Hello users@dba
>>> Im new here and im only a Base user.
>>>
>>> But i read once, if ideas or specs for things you want exist,
>>> sometimes there is an programmer and takes it.
>>>
>>> One of my favorite things i miss in Base is, to open a form or
>>> report from inside the database, without knowledge from macro
>>> programming. This was also on the Feature Poll list.
>>>
>>> So i want to give something back an tried to make a detailed feature
>>> wish. My second step is now to find someone who is interested to have a
>>> look and could give me feedback. Who will help to take a look if this
>>> idea is "releaseable".
>>> Please feel free to change or expand the suggestions like the way
>>> that open source works. Today, this paper only describes the way i
>>> thought, what the user has to do, to open a form or report with a
>>> push button.
>>>
>>> With OOo 3.1.0 will be a new "basic" something implement.
>>> ThisDatabaseDocument.FormComponents.getByName( "form name" ).open
>>>
>>> I thought with this implemention it could be possible to enhanced
>>> the Push Button Actions to open forms and reports from inside a
>>> database. But i thought that there is something more needed then
>>> only to open a form or report by double click.
>>>
>>> Please let me know if you are interested to have a closer look to
>>> the start suggestion. I will send it to you.
>>> It would be also helpfull, if there is someone interested who know
>>> the next steps what to do with this paper after that.
>>>
>>> Thanks in advance.
>>> Ulf Dietrich
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [e-mail]
>>> For additional commands, e-mail: [e-mail]
>>>
>>>
>>>      
>> --
>> Dipl. Ing. Mechtilde Stehmann
>> ## http://de.openoffice.org
>> ## Ansprechpartnerin für die deutschsprachige QA
>> ## Freie Office-Suite für Linux, Mac, Windows, Solaris
>> ## Meine Seite http://www.mechtilde.de
>> ## PGP encryption welcome! Key-ID: 0x53B3892B
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [e-mail]
>> For additional commands, e-mail: [e-mail]
>>
>>
>>
>>    
>
>  
Wow, if we could get this in Base, it would be like reaching some sort
of a Gold Standard or something.

Have a great evening!  :-)


 

[Andreas Saeger]

Frank Schönheit - Sun Microsystems Germany wrote:

> Hi Ulf,
>
>> One of my favorite things i miss in Base is, to open a form or
>> report from inside the database, without knowledge from macro
>> programming. This was also on the Feature Poll list.
>>
>> So i want to give something back an tried to make a detailed feature
>> wish. My second step is now to find someone who is interested to
>> have a look and could give me feedback. Who will help to take a look
>> if this idea is "releaseable".
>
> Interesting. I don't have too much time for a detailed review, not to
> mention a comprehensive discussion, but would definitely be interested
> in having a look.
>
> Perhaps uploading your ideas to some public place
> (http://dba.openoffice.org/servlets/ProjectDocumentList?) is a good
> idea? (Personally, I think the Wiki would be a good place, too. But
> editing a Wiki article is more cumbersome than writing a text doc, so
> .... your decision.)
>
> Ciao
> Frank
>

Hi,
2 Cents from a hobbyist (ex-)macro programmer:
There should be a protocol handler for embedded stuff...
vnd.sun.star.embedded:forms/subfolder/My%20Form"
...to be used just like any other URL as a hyperlink field or button
like you can do with any other GUI-command, for instance .uno:CloseDocument

Additional command line arguments may use that protocol handler as well.
$ sbase -form "My Form" ~/inventory.odb
may internally trigger vnd.sun.star.embedded:forms/subfolder/My%20Form"
on the Base doc's frame.
http://www.openoffice.org/issues/show_bug.cgi?id=85120 (desktop links)

On the other hand: Base is such a bad tool that loading forms from the
main window is just a miniscule annoyance. I don't really care anymore.
Instead I store all my database forms as stand-alone documents. This
gives far more advantages than disadvantages.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Andreas Saeger]

egwjens wrote:
> Hi Guys,

>
> It must be so easy, to offer such an functionalitiy, and lots of questions
> in the forums would just disapear.

Would you please elaborate on this? Or even better: If it is so easy,
can you please do  it or provide the small amount of money to pay
someone for a completely rewritten database component?


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[egwjens ()]

Hi

I want to apologize for my critic. I was just frustrated about so many posts, which I red, when I wanted to find an answer to my small problem. These posts were send, but i have not found in one of it a simple solution.

I apologize for my inappropiate emotional words, but I dont apologize for my wishes and ideas.

I was a Software developer once, and worked with a kind of database on a mainframe.

I would like to see a simple function like

1.) Tools-> Open Form -> New Form Controller

Here the user can write the name of the "kind-of-macro", from which Form A to which Form B the switch should happend, and which variables - mostly the key - should be passed on, or the relation of variables in the new data sentence. (simple version)

2.) in the button prefs. under URL, the User can then choose Form2Form, and in the next field he types in the name of the "kind-of-macro", which he has given in step 1.  

For Example:

At tools...

Name: Client2Customer
From Form A: ClientForm
To Form B: CustomerForm
Key:Yes, one
Variables: (Form A:ClientID (key), Form B:CustomerClientID(n))

Then in button prefs...

Under URL: Form2Form
FormSwitchName: Client2Customer

So when I am on form A, datas of one client, and want to take a look in the customer relations of this client, then I press a button, form B is loaded with the datas of the customers, related to the client of form A. That is all.

I saw many functions, also in the extentions, and i guess, everything is there, for such a small function.

The sun-programmers, and the community did a good job, and hopefully the users can specify their needs and wishes.

User- and Front-end-user friendlienes is important. Because when I need a programmer, to solve my problem, then I would speak of marketing, not of open source anymore. Many programms are written by techies for techies, not users.

So, a good understanding of the wishes of a normal user would help to make a better programme. Even when the normal user has difficulties to express his wishes in programming terms.

I dont want to bother you, but I read somewhere, that someone is collecting ideas for the next version of OO. And someone else wrote, that this questions belongs to the developer corner. It does not!

It belongs to the user.

I really dont want to bother you, but for version "over-the-mOOn 6.0" (2012), I would guess, that OpenOffice is able to be installed on a server, with MySQL, and the users (and front end users) are using just an interface, for receving datas, or sending datas or commands. (A local version should exist too, using the same interface)

Why?

Now: Google is going this way, MS will sooner or later follow, and OO? For Admins (Commercial, or NFP) is a maintance of a server incl. Office Software easier, than by paying for local installations (and lots of running).

Thats why!
 
Start with a vision, and then with the version.... (my credo?)

Thanks for reading my LONG post, should not happend again,


Jens

Andreas Saeger wrote:

egwjens wrote:
> Hi Guys,

>
> It must be so easy, to offer such an functionalitiy, and lots of questions
> in the forums would just disapear.

Would you please elaborate on this? Or even better: If it is so easy,
can you please do  it or provide the small amount of money to pay
someone for a completely rewritten database component?


---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]

[Andreas Saeger]

Hello Jens,
No offense taken. Everybody assumes that Base is related to MS Access
like Writer/Word and Calc/Excel. I do not even acknowlege Base as a
database application. At least I can not produce anything that could be
used outside the OOo context (OK, not counting flat dBase files).
Base is a configuration bridge to import tabular data into ODF
documents. Tabular data can be anything you have a driver for, from csv
up to database servers.
The abstract control containers (forms) you can attach to ODF documents
provide a reversed data flow from the office to the writable database.
But there are no forms in dialogs or application windows other than
office document windows.
Oh, and we can write scripts hacking on this awkward office-API. All
those features had been in StarOffice long before Base started in 2005.
Clever recombination of existing office features plugged to 3rd-party
software (HSQL, Pentaho) does not make a full featured database
application, IMHO.
Take it as is. Call your forms from the main window or store them as
independent office documents with desktop links and everything. Explore
what you can do with the combination of tools. It may be more than you
think by now.
Just don't waste your energy with perfectly ergonomic and good looking
poser stuff. You can not impress your boss with a Base database at the
same level as you can do with MS Access so easily.

Greetings,
Andreas


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...