Michael Kolowicz | 1 Aug 13:46 2014
Picon

SubSubForm in LibreBase

I working with libre Base 4.2. I have a MainForm. There can a user select from a list a domain. On the MainForm
is a Subform. In the subform the user can select a Usergorup. Now I create a Subform in the first subform
(User can select a username - many to may relation table). But I cannot connect the subform with the subsubform.

I using ODBC to connect with a MS SQL-Server 2012

All Table Relations and FK a set on the MSSQL-side and shown in libreBase under the Relations-View

Where can I find a working example for my szenario? 

Freundliche Grüße / Best regards

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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

Tom Davies | 1 Aug 11:35 2014
Picon

Re: Base questions

Hi :)
Sorry!  I hadn't realised this was addressed to me only as a personal,
off-list message.  I was wondering why no-one responded!

This mailing list is set-up so that you have to use "Reply to all" or
"Reply to List" or similar option.  The familiar "Reply to" doesn't work as
it tyakes the message off-list.  It's something we keep on having to
explain to pretty much every new person who starts posting here, or seems
like it!!

Luckily there is nothing personal, inflammatory, embarrassing or anything
so it was easy to see it could be forwarded back to the mailing list.  The
question is a good one imo and it's one i still haven't got a good answer
to - despite it being an obvious question and probably handled quite a few
times already.

I think that if your current database IS working just fine then now is a
good time to create a back-up of it.  By that i simply mean right-click on
the file and do "copy" and then in an empty space in amongst the files,
beside the existing one just do "paste".  Any other copy&paste of the file
would do the same trick.  There are all sorts of fancy back-up options but
at core a back-up is just a copy.

At work i tend to put a sub-folder in all of the main folders i use and
call it "OldVersions-BackUps" and use it/them to dump all such backups and
works-in-progress other than the most recent copy of a file.  That way the
main folder is, hopefully, less cluttered&confusing.  I do tend to rename
back-up files to put the date in reverse order at the end and maybe a v1 at
the end so i can quickly tell which are newer and which are too ancient.

(Continue reading)

dave boland | 31 Jul 21:22 2014

Base questions

All,

Was reading the FAQ at https://wiki.openoffice.org/wiki/FAQ_%28Base%29
and came upon some insight that worries me.  Under the heading "So why
should I avoid 'embedded databases'?" it goes on to say the normal Base
file is not reliable, so use a split file, the points to Microsoft docs.

My questions are:
1. How robust are embedded Base files created by the GUI?
2. If they are not that reliable, what is the LO Base procedure to
create a split database?
3. Anything else I need to know?

I'm going ahead with using Base for a project for now.  Once the data
has stabilized (fields, field type, number of tables), I'll move to
either Mysql or Mariadb.

Thanks,
Dave
-- 
  dave boland
  dboland9 <at> fastmail.fm

-- 
http://www.fastmail.fm - Access your email from home and the web

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
(Continue reading)

Gordon Burgess-Parker | 31 Jul 11:53 2014
Picon

IF statement question

Hi Gurus!
I'm getting all in a twist over nested IF statements.
Here's what I want to do.
I have three columns A, B and C.
There is a list in Columns A and B and a result in C, but with gaps in 
each list as under:

A
	B
	C
Fred
	Fred
	
George
	
	X

	James
	Y
Jones
	Jones
	
Smith
	Smith
	

What I'm looking for is a nested IF statement in Column C that says "if 
A=B do blank, otherwise do "X" OR, if A="" then do "Y"
I can do the first condition, but I'm running into trouble combining the 
second in one statement.
(Continue reading)

Jon Harringdon | 31 Jul 11:26 2014
Picon

Re: LO Writer: Highlighting; setting page properties; some more nitpicking

Brian Barker <b.m.barker <at> btinternet.com> wrote:

> At 15:40 30/07/2014 +0100, Jon Harringdon wrote:
> >I often highlight some text and have to un-highlight it a little 
> >later. This should work like setting/resetting italic or bold 
> >attributes: pressing the highlight icon does highlight the marked 
> >text and pressing it again (with the same text marked) should remove 
> >the highlight.
> 
> Surely toggling makes sense only if there are only two choices 
> available: highlighted or not highlighted? But that's not so: 
> instead, there is a wide range of colours available for highlighting. 
> You'll notice that the chosen colour does stick. Evidently the 
> designers though it was more likely that users would want to 
> highlight other parts of the text with the same colour than to change 
> their minds and remove previous highlighting.

I completely understand what you're saying and I agree. The point here
is that your idea how it should work and my idea are not at all
incompatible. I'd simply like an extension to how highlighting is
implemented:

if (selected_text_is_hilited && selected_text_hilitecolour ==
  current_hilitecolour)
    remove_hilite_from_selected_text();

That's all.

> It occurs to me that you are probably misusing this facility. 

(Continue reading)

NoOp | 31 Jul 06:44 2014
Picon
Picon

LibreOffice Still?

While we're on 'nitpicking'...

OK I give... the download page/link is confusing enough with the
'Download' link going directly to
<http://www.libreoffice.org/download/libreoffice-fresh/> 'LibreOffice
Fresh', but now I see that 'LibreOffice Stable' has changed to
'LibreOffice Still' <http://www.libreoffice.org/download/libreoffice-still/>
what the heck is this all about? What next, LO Stale?

list: what version and OS are you using?
user: still have Windows 8 installed
list: you have what still installed?
user: still Windows
list: still Windows what?
user: still Windows 8
list: have you tried fresh?
user: say what?
list: try fresh
user: I still don't understand
list: install fresh
user: OK I did a fresh install, but still doesn't work

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
Steve Edmonds | 31 Jul 06:39 2014

Re: [Getting replies]

Hi Brian.
On 2014-07-31 16:04, Brian Barker wrote:
> At 19:34 30/07/2014 -0700, Wanda Moore wrote:
>> I have tried to email questions, but they have never been responded to.
>
> This seems to be untrue:
> o Your message of 25 May 2012 ("Documents do strange things") resulted 
> in thirteen list replies, and you must have seen these, as one reply 
> was from you!
> o Your message of 15 March 2012 ("Problem with LibreOffice-text won't 
> stay put") resulted in eight list replies, including three from you.
>
>> I have been getting everyone else's emails, which is in the hundreds.
>
> That is the nature of a mailing list.
>
>> I don't know why I haven't gotten through about my questions . . . . 
>> Please let me know how I can do this.
>
> Er, improve your recall?! (And note that you will not see your own 
> messages to the list echoed back to you, but that is a quirk of Gmail, 
> your mail provider, which sees trashing these copies as helpful!)
 From one computer I see my own replies and from another computer I 
don't, there is a definite quirk there. But to make up for sometimes not 
seeing my own replies I always get your replies in stereo, although I 
haven't figured out which is the left and right channel.

Steve
>
>> I no longer want to receive everyone else's emails.
(Continue reading)

Wanda Moore | 31 Jul 04:34 2014
Picon

(unknown)

I have tried to email questions, but they have never been responded to.  I
have been getting everyone else's emails, which is in the hundreds.

I don't know why I haven't gotten through about my questions . . . .

Please let me know how I can do this.  Thank you.

I no longer want to receive everyone else's emails.

Wanda Moore

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
Scott Jones | 30 Jul 21:20 2014
Picon

LO 4.3.0.4 Crashing

Anyone else having constant startup crashing?

32-bit System the problem causes LO to crash constantly when starting 
soffice.exe which is what runs when quickstart.exe is run. Can 
intermittently get soffice.exe and swriter.exe etc to run.

64-bit System the problem is that I can run soffice.exe seemingly no 
problem but the quickstart utility doesn't show in the system tray.

Neither of these allows quickstart utility to run in the system tray.

Going back to 4.2.5 for now as these issues make 4.3 unusable.

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
Jim Byrnes | 30 Jul 18:30 2014
Picon
Picon

No database option

Using LibreOffice 3.5.7.2 on Ubuntu 12.04.

I am working with a ooBasic tutorial. It says to choose 
File-->New-->Database to create a new database.  The problem is there is 
no Database item on that drop down menu.  Also, on the opening screen 
the Database entry is grayed out.

I actually have a database on my system that I was experimenting with a 
couple of years ago. If I go to 
Tools-->Options-->LibreOffice-->Databases it shows there but I can't 
open it.

Anyone have any idea of what could be wrong and how to enable databases 
again?

Thanks, Jim

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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

Jon Harringdon | 30 Jul 16:40 2014
Picon

LO Writer: Highlighting; setting page properties; some more nitpicking

I am reposting this message as the first never did show up. Sorry if
some of you see it twice.

----original message----
From: Jon Harringdon <jonathan.harringdon <at> virgin.net>
Date: Wed, 30 Jul 2014 12:24:22 +0100
Subj: LO Writer: Highlighting; setting page properties; some more
nitpicking

Hi,

I've run into two small problems with LO Writer (on XP/SP3+updates; LO
4.2.5 portable) for which I've found no obvious help online.

The first is a simple convenience thing. I often highlight some text and
have to un-highlight it a little later. This should work like
setting/resetting italic or bold attributes: pressing the highlight icon
does highlight the marked text and pressing it again (with the same text
marked) should remove the highlight. Well, it doesn't. Either I'm too
thick to find out how to do that or it doesn't work as I expect. (I know
that I can remove any highlight by explicitly setting the colour box to
"no fill" but switching back and forth all the time is really annoying.)

Second, I want to set the page size (Format>Page>Page) to 0.5cm on all
sides. I enter 0.5cm in the first box and then press Ctrl-A/Ctrl-C to
then copy that into the other three boxes. After pressing Ctrl-C, Writer
completely hangs for three, four, sometimes five seconds (on first use
of this dialog, later on it seems to be OK). I've checked this with a
process monitoring tool and the Idle process at all time has around 95%
or more so I am not sure what is happening here.
(Continue reading)


Gmane