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.
LVL 7
kenesoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
LibreOffice

From novice to tech pro — start learning today.