• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

creating interface form

Hi,

I have created 3 tables, and the relative forms to add, edit, and view the data, I need to create a single interface, from which to open the 9 forms.
How can I achieve this?

Thank you.
0
keneso
Asked:
keneso
  • 4
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
No idea about OpenOffice, but Access has a 'Switchboard Wizard' where you can make a custom switchboard / main menu / whatever you want to call it, with nine buttons that will take you to your nine forms.  

The table 'Switchboard Items' will contain whatever selections you want on your 'Switchboard'.  In your case it will be nine records, with their respective form names you want them to open, and perhaps a tenth button for Close.

You could run this and use it as a model within OpenOffice.

0
 
kenesoAuthor Commented:
Thanks, I'll look into it.
0
 
pitonyakCommented:
OOo Base will not read and/or use a form created in Access.

Let me repeat what I believe you desire:

1. You have a Base document
2. The Base document contains nine forms.

You want something that allows you to choose the form, and then open the form.

Download this document:

http://www.pitonyak.org/database/AndrewBase.odt

Look at Listing 9 in section 2.4. A macro (that I wrote) opens a Base document, and then lets you choose a form to open contained in the Base document.
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
kenesoAuthor Commented:
Thank you pitonyak, sorry for the delay.

I looked at the document, but being a total noob at this, I would need some guidance on how to use those macros.
0
 
pitonyakCommented:
I also added another macro

Sub onClickOpenForm ( oEvent as variant )
   OpenForm(oEvent, "Form Name")
End sub

Sub OpenForm( oEvent as variant, aFormName as string) as variant
  Dim args(1) As New com.sun.star.beans.PropertyValue
  Dim container as variant
  Dim oCon

  oCon =  oEvent.Source.Model.Parent.ActiveConnection
  container = oCon.Parent.DatabaseDocument.FormDocuments

  args(0).Name = "ActiveConnection"
  args(0).Value = oCon
  args(1).Name = "OpenMode"
  args(1).Value = "open"
  container.loadComponentFromURL(aFormName,"_blank",0,args())
End Sub

This demonstrates how to directly open a form given its name. I added this to AndrewBase.odt as well.

From where and how do you desire to run your script?

0
 
kenesoAuthor Commented:
Thanks.

I'd like to do it from the Base document, as the opening window/interface.
0
 
kenesoAuthor Commented:
Thank you all, and sorry for the delay.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now