| View previous topic :: View next topic |
| Author |
Message |
masirib5
Newbie
Joined: 03 Sep 2010
Posts: 1
Location: Makati City, Philippines
|
 Posted: Fri Sep 03, 2010 5:28 am Post subject: Newbie - Base multiple forms - how to navigate between forms |
 |
|
I have just one large table and 4 associated forms for the end user to input data.
Is it possible to include some sort of navigation between the 4 forms?
Thanks!
--Jeff |
|
| Back to top |
|
 |
dacm
Super User
Joined: 07 Jan 2010
Posts: 734
|
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sat Sep 04, 2010 10:56 am Post subject: |
|
|
3) Store your forms as independent Writer documents and link them through hyperlinks. This allows desktop links as well.
1 Open the form
2 Save the Writer document on disk (File>Save As..).
3 Close the form
4 Open the document you saved
You've got to reconnect all the forms and subforms to the database:
5 Get the form properties, tab "Data"
6 Hit the [...] button and browse the database file (property "Content Type"). If the databse is a registered one you can also select the database by its registered name.
7 Set the table, query or SQL statement respectively as it used to be in the embedded form (property "Content").
Repeat 5-7 for all forms and subforms in the document.
8 Save, close.
When you revoke write access to that file, the user can still work with the form without the ability to turn on design mode so the layout is protected.
Now you can link the form document by means of Windows links and you can connect the forms and reports by means of hyperlinks (Insert>Hyperlink...File)
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
erneichan
General User
Joined: 09 Aug 2010
Posts: 13
|
| Posted: Mon Sep 06, 2010 4:54 pm Post subject: |
|
|
Hi! Villeroy,
I really like your idea of the separations the form and the database. However, I am not able to continue from number 5) of your instructions. i.e. Get the form properties, tab "Data". I tried to get the form design, form control, form navigation set up from the toolbar in writer and it will not show.
Just wonder if you can help me with it. Thank you in advance for all your help!
Ernie[/img] |
|
| Back to top |
|
|
dacm
Super User
Joined: 07 Jan 2010
Posts: 734
|
| Posted: Mon Sep 06, 2010 8:48 pm Post subject: |
|
|
| Villeroy wrote: | 3) Store your forms as independent Writer documents and link them through hyperlinks. This allows desktop links as well.
1 Open the form
2 Save the Writer document on disk (File>Save As..).
3 Close the form
4 Open the document you saved
You've got to reconnect all the forms and subforms to the database:
5 Get the form properties, tab "Data"
6 Hit the [...] button and browse the database file (property "Content Type"). If the databse is a registered one you can also select the database by its registered name.
7 Set the table, query or SQL statement respectively as it used to be in the embedded form (property "Content").
Repeat 5-7 for all forms and subforms in the document.
8 Save, close.
When you revoke write access to that file, the user can still work with the form without the ability to turn on design mode so the layout is protected.
Now you can link the form document by means of Windows links and you can connect the forms and reports by means of hyperlinks (Insert>Hyperlink...File) |
Very nice Villeroy!
I was searching for a link to this technique but ran out of time. Thank you for adding it and outlining the steps because I've been considering this hyperlinked-Writer-forms approach for my own use. But in the meantime, I did find the particular post on the subject that I was searching for here, in case anyone finds it helpful..
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Migrating 'Embedded databases' |
|
| Back to top |
|
|
|
