[libreoffice-users] LO Base Colour settings in Form design.
Hi All I have a Membership Database running on MySQL 5.1 with an LO Base Front end Ver 3.6.2.2. All running on PCLOS 2012. My Members fall into two or three different Categories and I would like to be able to show this on screen. SO - Is it possible to add in a statement to the Form design so that the background colour of the Form will change depending on the value set in a field called 'Cat'? Something like IF 'Cat'="abc" THEN Bgd Colour = "" OR IF 'Cat'="cde" THEN Bgd Colour = "" Thanks for any help!! IanW Pretoria RSA -- For unsubscribe instructions e-mail to: users+h...@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] LO Base Colour settings in Form design.
Ian , When using macro's to add the data to your form it can easly been done, without macro's ?? Greetz Fernand Hi All I have a Membership Database running on MySQL 5.1 with an LO Base Front end Ver 3.6.2.2. All running on PCLOS 2012. My Members fall into two or three different Categories and I would like to be able to show this on screen. SO - Is it possible to add in a statement to the Form design so that the background colour of the Form will change depending on the value set in a field called 'Cat'? Something like IF 'Cat'="abc" THEN Bgd Colour = "" OR IF 'Cat'="cde" THEN Bgd Colour = "" Thanks for any help!! IanW Pretoria RSA -- For unsubscribe instructions e-mail to: users+h...@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] LO Base Colour settings in Form design.
Ian , or maybe just place a listener on the filed who contains "Cat" data. on changing the field content place a event who run a macro: The eventlistner produce a oEvent object who contains the "source" = field object and the source.context = Form object IF Oevent.source.model.text = "abc" THEN Oevent.source. context . backgroundcolor == "" OR ... hope it helps Hi All I have a Membership Database running on MySQL 5.1 with an LO Base Front end Ver 3.6.2.2. All running on PCLOS 2012. My Members fall into two or three different Categories and I would like to be able to show this on screen. SO - Is it possible to add in a statement to the Form design so that the background colour of the Form will change depending on the value set in a field called 'Cat'? Something like IF 'Cat'="abc" THEN Bgd Colour = "" OR IF 'Cat'="cde" THEN Bgd Colour = "" Thanks for any help!! IanW Pretoria RSA -- For unsubscribe instructions e-mail to: users+h...@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] LO Base Colour settings in Form design.
On 11/23/2012 10:24 AM, Ian Whitfield wrote: Hi All I have a Membership Database running on MySQL 5.1 with an LO Base Front end Ver 3.6.2.2. All running on PCLOS 2012. My Members fall into two or three different Categories and I would like to be able to show this on screen. SO - Is it possible to add in a statement to the Form design so that the background colour of the Form will change depending on the value set in a field called 'Cat'? Something like IF 'Cat'="abc" THEN Bgd Colour = "" OR IF 'Cat'="cde" THEN Bgd Colour = "" Thanks for any help!! IanW Pretoria RSA To do this you will have to create a macro. Use the Events tab of the Control tool to assign the macro to 'Cat'. I don't know how well you understand macros nor how to create them. I don't have any experience in using macros, so I can not make any suggestions as to the required macro's content. From what little I have seen, it may contain some lengthy lines of code. Others with macro experience may be able to point you in the right direction. --Dan -- For unsubscribe instructions e-mail to: users+h...@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