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: Toolscustomiseopendocument 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 tomc...@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 lodg...@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 lodg...@gmail.com On 27 October 2014 19:08, Peter Goggin petergog...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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
[Solved] Re: [libreoffice-users] Setting Base to open with a slected form
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 tomc...@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 lodg...@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 lodg...@gmail.com On 27 October 2014 19:08, Peter Goggin petergog...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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
Re: [Solved] Re: [libreoffice-users] Setting Base to open with a slected form
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 tomc...@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 lodg...@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 lodg...@gmail.com On 27 October 2014 19:08, Peter Goggin petergog...@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+unsubscr...@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+unsubscr...@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 -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Setting Base to open with a slected form
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 lese 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 lodg...@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 lodg...@gmail.com On 27 October 2014 19:08, Peter Goggin petergog...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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
[libreoffice-users] Setting Base to open with a slected form
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+unsubscr...@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
Re: [libreoffice-users] Setting Base to open with a slected form
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 lodg...@gmail.com On 27 October 2014 19:08, Peter Goggin petergog...@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+unsubscr...@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+unsubscr...@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
