Re: [libreoffice-users] Incorrect font colour when printing in Base
Hi Robert, > Attachments aren't allowed here. Sorry. > If you wan't to print a letter with Base you could better use a report. I just want something quick and easy. When I tried making a report it was very slow and I ended up with a report made up from every letter I had ever written, which is not what I want. > What is the difference between the fields you could or couldn't print > with the choosen colour? I have discovered that the ones that work were all multi-line and the ones that didn't were single-line fields. By changing all fields to multi-line they print with my chosen colour. All except one, which is a date field with a drop-down box and cannot be changed to multi-line. Thanks, Adam -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Incorrect font colour when printing in Base
I have created three forms in Base; Clients, Letters and Letters_Print so that I can create and print out unique letters. I have changed the font colour of all fields in Letters_Print to Dark Blue 1 via Control > General > Font. All looks as I want except that when I go to print the letter only the address and text body fields are in dark blue. All others remain in black. What am I doing wrong? I include an example with the problem. Thanks for any help, Adam Fenn -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Option Buttons not working in Base
Of course! Thanks. > On 21 May 2019, at 15:15, Robert Großkopf wrote: > > Hi Adam, > > the option-field must have > - the same name or > - the same group-name > > Have a look at the properies of each field. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Option Buttons not working in Base
I have three option buttons (Confirmed, Enquiry, Cancelled) all linked to a status field (Control > Data > Data field). When I click on the Confirmed button it works as expected but I can not unclick it and the other two buttons do not work at all. Can someone tell me what I am doing wrong? I'm using Libreoffice 6.1.6.3 on a Mac. Thanks, Adam Fenn -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Getting a line break through a query
Ahh, thank you so much! > On 15 May 2019, at 22:42, Drew Jensen wrote: > > Howdy, > > The carriage return is in the string but in the case of the Query designer > the result grid only displays single line data so it appears it is not > there. > > If the query is used to populate controls on a form (grid or single field) > there is a property for the control 'MultiLine Input' and default is NO. > > For a Grid control you would select a column and change that 'MultiLine > Input' property for the column from No to Yes and the string will break. > > Best wishes, > > Drew > > On Wed, May 15, 2019 at 4:56 PM Adam Fenn wrote: > >> The base documentation states that you can get a line break using Char(13) >> e.g. >> >> SELECT "Firstname"||' '||"Surname"||Char(13)||"Road"||Char(13)||"Town" >> FROM "Table" >> >> >> However, when I run this I just get the concatenated query on one line >> with no line breaks. >> >> What am i doing wrong? >> >> Thanks for your help, >> Adam Fenn. >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> >> > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Getting a line break through a query
The base documentation states that you can get a line break using Char(13) e.g. SELECT "Firstname"||' '||"Surname"||Char(13)||"Road"||Char(13)||"Town" FROM "Table" However, when I run this I just get the concatenated query on one line with no line breaks. What am i doing wrong? Thanks for your help, Adam Fenn. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Summing currency fields in base
> On 11 Oct 2018, at 23:39, Girvin Herr wrote: > > I am not sure where you are wanting this total. I want it in the same form as fee1 and fee2. > First, you need to create a query, I'm familiar with this. > Then you need to have your form attach itself to the query rather than the > table. You do this by opening the form in "Edit" mode and selecting the > "Form" icon. At this time, you should have a popup called "Form Properties". > Select the "Data" tab and in the "Content type" list select "Query". Then > select your new query in the "Content" list. Then you can add the new "Total" > field to your form. When I try to add the field using the Add Field icon LO crashes without fail. Is there a way around this? Thank you for your help Girvin. > On 10/11/18 11:39 AM, Adam Fenn wrote: >> I have three currency fields - 'Fee1', 'Fee2' and 'Total'. How do I add >> fee1 and fee2 together and put the result automatically into the Total field? >> >> TIA >> Adam. > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Summing currency fields in base
Thanks Wade, but where do I put that? > On 11 Oct 2018, at 19:45, Wade Smart wrote: > > In field 3 > =field1+field2 > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > On Thu, Oct 11, 2018 at 1:41 PM Adam Fenn wrote: >> >> I have three currency fields - 'Fee1', 'Fee2' and 'Total'. How do I add >> fee1 and fee2 together and put the result automatically into the Total field? >> >> TIA >> Adam. >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Summing currency fields in base
I have three currency fields - 'Fee1', 'Fee2' and 'Total'. How do I add fee1 and fee2 together and put the result automatically into the Total field? TIA Adam. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Concatenating fields in related form
> There must be something wrong in your database-construction. Please load > up an example with some dummy-data to see what is getting wrong. If you > couldn't load it up anywhere please send the example direct to me so I > could see the problem, which appears. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Concatenating fields in related form
Thank you for taking the time to reply Robert. > If you will see this directly while input of values you have to set the > input of "ClientID" in the mainform and the query for the shown content > in the subform. "ClientID" will be the field connecting to the subform. > It could be set up as a listfield with the code > SELECT "FirstName"||' '||"Lastname", "ClientID" FROM "Table" > So it will show the "FullName" if the clientID is submitted from the > mainform. I can only get this to work (with a list box) if there is only one project for each client. If I have two separate project records with the same client id I get an error. > But: Do you really know all ClientIDs? I would prefer a listfield > instead, which directly shows the names. I have nearly 1000 clients. It would be tedious scrolling through those looking for a client, or am I missing something? I was hoping I could recreate my old Filemaker method of linking the records. Thanks, Adam -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Concatenating fields in related form
I have a Client form with ClientID, FirstName and LastName fields and a Project form with ClientID and FullName fields. In Filemaker I was able to type in a client id into the Project form and it would insert the first name and last name from the Client form into the FullName field of the Project form. How can I do this in Base? Hope that is clear. TIA, Adam. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy