[Solved] Running Forms

[williaba]

Is there any way of running a form, in isolation, just by clicking on a desktop icon?

The intention is not to let a user have access to other forms, and especially to the tables, as defined in the application.

Solved.

[QuazzieEvil]

you can save your form as a writer doc, and link the form(s) to the database--goto Data tab of form properties dialog and select a 'Data Source'

[williaba]

Hey Quazzie, Thanks for the help. But just one more thing.
How do I keep the Form (in Writer) in run only mode. That is, how do I prevent a user from going into 'Design Mode'.

[Hagar Delest]

How do I keep the Form (in Writer) in run only mode.

Put the fields in a section and then protect it with a password.

Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.

[DrewJensen]

Hagars advice is correct - with one problem - you can still edit the properties for the controls. You can't move them, add new ones, or delete the old ones.

An Issue has been entered about this
http://www.openoffice.org/issues/show_bug.cgi?id=85818

One thing to note is that this protecting of sections works for embedded forms as well as separate Writer documents..

[williaba]

Thanks for the advice, Hagar, but would you mind expanding on how I put the fields in a section and then protect with a password?

[Hagar Delest]

1. Menu Insert>Section.
2. Create your form.
3. Open the Navigator (F5), right click on the section listed in the tree for sections, Edit entry. Check the right box in the dialog.

[williaba]

My form is already created.

I can't see what I'm supposed to do in Navigator <F5>.

So in edit mode or in run mode I create a section using 'Insert > Section', but I end up with a narrow rectangle above the fields of my form.

I can't seem to get the fields inside the Section, even if I select all of the fields in Edit mode.

But to return to my original question about running a form in isolation. Is there not a command that can be run at Operating System level, of the format :

$ runform db='db_name' form='form_name' exclude=('toolbars')

It seems silly that a user should be given access to the whole workings of the database when all you want them to do is run a form, which after all, is why you created it (the form).

[JCR]

The folks above are right about "locking" a form to prevent modification, but you seem to be asking about aspects of "displaying" the form namely withough tool bars, menus and so forth.

I posted an aswer here.
http://user.services.openoffice.org/en/ ... =39&t=2134

[williaba]

But, what is the answer?
How and where does one create the code?

[Hagar Delest]

Copy the code given in the post and paste it in a module (Tools>Macros>...) and run it.

See here also: How to install a macro found here (on oooforum).

NB: add '[Solved]' in your first post title (edit button) if your issue has been fixed (not in the message).