Re: [Solved] Re: [libreoffice-users] Setting Base to open with a slected form

The solution to getting LibreBase to open with a particular form 
involves several steps:
1. Create a macro
/Sub Menu_Main( )
Dim ObjTypeWhat
Dim ObjName As String
ObjTypeWhat = com.sun.star.sdb.application.DatabaseObject.FORM
ObjName = "MainMenuForm" 'The name of the form you want to open at Base 
start-up, this needs to exist.
If ThisDatabaseDocument.FormDocuments.hasbyname(ObjName) Then 'Check the 
form exists
ThisDataBaseDocument.CurrentController.Connect() 'If the form exists 
connect to the database
ThisDatabaseDocument.CurrentController.loadComponent(ObjTypeWhat, 
ObjName, FALSE) 'Open the form
Else
MsgBox "This is embarrassing, sorry, can't find the requested form to 
open!"+chr(10)+"Form Name = " & ObjName + chr(10)+"Check the details." , 
48, "DS4A SBM encountered a problem!"
End if
End Sub/
2. Call the macro when the data base is opened:
From the top tool bar  select: Tools>customise>opendocument
Add macro Main_menu to this selection.

When the data base is opened there is a delay of about 1 second before 
the form named in the macro opens.
This isn't quite as fast as Access, but in many other areas I found 
LibreBase to be more intuitive and than MS Access. I was able to convert 
my data bases from Access to LibreBase with all of the functionality the 
original Access databases, including reports, and in some cases with 
improved functionality.

Regards


Peter Goggin



On 05/11/14 12:51, Mark LaPierre wrote:
> Hey Tom,
>
> It would be nice to post the solution here on the string that is
> labelled "[Solved]" so that people searching for the solution can find
> it.  Maybe Peter should do that since he seems to have a better grip on
> the solution.
>
> On 11/04/14 04:33, Tom Davies wrote:
> > Hi :)
> > Peter has let me know, off-list, that he solved the problem.  Details are
> > sketchy (ie i didn't understand) but he's working on the Base Handbook at
> > the moment so this is a distraction.
> >
> >
> > Anyone who fancies their chances of being able to proof-read a chapter or 2
> > would be a huge help in getting the Base Handbook published more quickly.
> >
> > Most chapters have been reviewed (tested for technical accuracy) already
> > and been kinda proof-read once but a final round of proof-reading would
> > help reassure those who have been involved with getting the guide/handbook
> > this far.
> >
> > There are still a few chapters that need reviewing but it's tough work so
> > just proof-reading those already done would be great and could be done by
> > almost anyone.
> >
> > Regards from
> > Tom :)
> >
> >
> >
> > On 3 November 2014 21:40, Tom Davies <tomcecf@gmail.com> wrote:
> >
> > > Hi :)
> > > Has anyone had any luck trying to find the thread Noel was referring to?
> > > Is it possible to give a link to specific threads?
> > >
> > > Has anyone here been able to convert a database from Access?
> > >
> > > Has anyone been able to set-up a database file so that when it opens it
> > > goes straight to a main form instead of into a design view?  Is this
> > > something that might be better done using a form that is made in Writer?
> > >
> > > Regards from
> > > Tom :)
> > >
> > >
> > >
> > >
> > >
> > > On 27 October 2014 09:26, Marion & Noel Lodge <lodgemn@gmail.com> wrote:
> > >
> > > > Hi Peter,
> > > >
> > > > This question was asked recently.  If you go to -
> > > >       http://www.libreoffice.org/get-help/nabble/
> > > > and search for "How to open a particular form at startup" you will find
> > > > the
> > > > thread.
> > > >
> > > > Noel
> > > > --
> > > > Noel Lodge
> > > > lodgemn@gmail.com
> > > >
> > > > On 27 October 2014 19:08, Peter Goggin <petergoggin@bigpond.com> wrote:
> > > >
> > > > > I have completed the conversion of my Access contacts data base to
> > > > > LibreBase. The only problem I have not solved is to get the database to
> > > > > open with my main menu form. This could easlly be set in MS Access ut so
> > > > > far I cannot find the mechanism for doing this in Base.  Is rhere a way
> > > > of
> > > > > doing this? Or do I have to open the data base and manully select the
> > > > for i
> > > > > want to start with?
> > > > >
> > > > > Regards
> > > > >
> > > > > Peter Goggin
> > > > >
> > > > > --
> > > > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > > > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> > > > > unsubscribe/
> > > > > Posting guidelines + more:
> > > > http://wiki.documentfoundation.org/Netiquette
> > > > > List archive: http://listarchives.libreoffice.org/global/users/
> > > > > All messages sent to this list will be publicly archived and cannot be
> > > > > deleted
> > > > --
> > > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > > Problems?
> > > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > > > List archive: http://listarchives.libreoffice.org/global/users/
> > > > All messages sent to this list will be publicly archived and cannot be
> > > > deleted


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted