[libreoffice-users] Using a Button to activate Subform.

2013-03-29 Thread Ian Whitfield
Hi All I need some help again!! I did this a few months back but now can not remember how I did it!! I have a Main Form of Member details working well and this has a SubForm showing eMail to and from this Member. Now I want to add a Button to the Main Form that opens a window on top of the

Re: [libreoffice-users] Re: booklet printing problem

2013-03-29 Thread mcmurchy1917-libreoffice
I seem to remember I had a problem with priinting brochures a short while ago from within Libreoffice and I also seem to remember that Adobe Reader was OK, it all started happening after an upgrade of my system, I use Slackware. Changing the print driver in CUPs fixed it for me. Iain On

Re: [libreoffice-users] Re: booklet printing problem

2013-03-29 Thread Jeff Shrowder
On 03/29/2013 08:08 AM, Marc Paré wrote: Hi Jeff, Le 28/03/13 07:21 AM, Jeff Shrowder a écrit : Thank you for your suggestions. I've had no success. What is the LibreOffice profile and what is its function? I haven't found a way to change the margins when printing a booklet in acroread. The

[libreoffice-users] Re: booklet printing problem

2013-03-29 Thread Marc Paré
Le 29/03/13 05:11 AM, Jeff Shrowder a écrit : Marc, Thank you for your persistence. Unfortunately, having tried your suggestion above, I don't think we are any further advanced :-( Perhaps one minor difference is that the landscape printing is now flush with the left margin rather than centred

Re: [libreoffice-users] Re: booklet printing problem

2013-03-29 Thread Jeff Shrowder
On 03/29/2013 09:24 PM, Marc Paré wrote: Le 29/03/13 05:11 AM, Jeff Shrowder a écrit : Marc, Thank you for your persistence. Unfortunately, having tried your suggestion above, I don't think we are any further advanced :-( Perhaps one minor difference is that the landscape printing is now

Re: [libreoffice-users] Using a Button to activate Subform.

2013-03-29 Thread Ian Whitfield
Thanks Noel On 29/03/13 13:13, Marion Noel Lodge wrote: Hi Ian, Not sure if this is what you need, but it works for me. I got it from the Web. On the Events tab of my button under 'Mouse button pressed', I connect to the sub, OpenfMembers(). If you substitute your form name in place of

Re: [libreoffice-users] Using a Button to activate Subform.

2013-03-29 Thread Marion Noel Lodge
Hi Ian, Is there an error message showing in the Macro Edit window? You should be able to close the window after clicking on the Stop Macro button, (a red circle with the white 'X' in it, in the middle of the controls up the top.) Does the sub Form work if you run it manually? (Double click on

[libreoffice-users] Re: booklet printing problem

2013-03-29 Thread Marc Paré
Hi Jeff, Le 29/03/13 08:19 AM, Jeff Shrowder a écrit : Marc, OS: Scientific Linux 6.3, Kernel Linux 2.6.32-279.51.el6.i686, GNOME 2.28.2 Hardware: Memory 1.8 GiB Processor: AMD Athlon XP2800+ (yes, I know, old machine!!) LibreOffice: Version 4.0.1.2 (Build ID:

Re: [libreoffice-users] Re: booklet printing problem

2013-03-29 Thread Kracked_P_P---webmaster
I use Ubuntu and almost every time there is a printer package upgrade, like CUPS, I have to reinstall some of my printers again to get them to work properly again. I do not use the Adobe Reader on Linux. So I do not have its issue of margin changes. I do a lot of printing to CUPS-PDF or

Re: [libreoffice-users] Using a Button to activate Subform.

2013-03-29 Thread Ian Whitfield
Thanks Noel I appreciate the 'come-back'!!! On 29/03/13 15:13, Marion Noel Lodge wrote: Hi Ian, Is there an error message showing in the Macro Edit window? I didn't get one before but now when I try again I get BASIC runtime error. An exception occurred

[libreoffice-users] Inserting an empty string in Base

2013-03-29 Thread Dan Lewis
I have a form that requires first name, middle initial, and last name. Some of the people do not have a middle initial. For such people I want the field for the middle initial to contain an empty string. How do I accomplish this? (For this field, I have set the Data property, Set empty string

Re: [libreoffice-users] Inserting an empty string in Base

2013-03-29 Thread Tom Davies
Hi :) Errr, surely you want that empty string to be Null though?  At least when it's empty?.  Alternatively is there an equivalent of the Action Query that can rapidly fill all the rows of the field with .  Obviously you would want to filter-out all the rows that do have some contents first

Re: [libreoffice-users] Inserting an empty string in Base

2013-03-29 Thread Girvin R. Herr
Dan, You need to specify that NULLs are allowed in _both_ the table edit and the form control edit for that particular field in your database, if you allow Nulls. If you want an empty string instead of a NULL, you should be able to set the default field value to (note the space, a may be

[libreoffice-users] Automatic line creation

2013-03-29 Thread John Jason Jordan
I have been using OOo, now LibreOffice 3.4.6, currently on Fedora 16, x86_64 for many, many years. In fact, I started with StarOffice 0.91. Today I wanted to type three asterisks and center them in a line as a device to mark a change of perspective in a work of fiction. After I typed the three

Re: [libreoffice-users] Automatic line creation

2013-03-29 Thread John Jason Jordan
On Fri, 29 Mar 2013 19:26:34 -0700 John Jason Jordan joh...@comcast.net dijo: I have been using OOo, now LibreOffice 3.4.6, currently on Fedora 16, x86_64 for many, many years. In fact, I started with StarOffice 0.91. Today I wanted to type three asterisks and center them in a line as a device