Glad you got what you needed, sorry it wasn't easier. I guess part of the
problem is that "file" is a pretty slippery beast in a relational database,
where you have the overall database, the tables, the queries, the reports,
etc. It would be nice if there were more context sensitivity for File menu
functions, but I can see where it might not be the easiest thing to do.
As to where I was looking -- from Base main menu Help -> OpenOffice.org
Help -> Index tab, search on queries, double-click printing. The way all the
programs are interrelated means that the help topics range over the whole
set, so it can be kind of confusing for those of us who are used to
single-app help files. Can feel like we're playing a text adventure game
sometimes!
----- Original Message -----
From: "Ron Ferguson" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, February 20, 2007 4:49 PM
Subject: Re: [users] [moderated] help
Thanks, Barbara and Dan, I now have every thing where I want it. I would
still like to see it being possible to transfer a DB file direct to Calc
though and possibly the saving/exporting to a csv file direct from the DB.
BTW, Barbara, you mention help for query printing - where did you find
that please? I've been through many of the help sections, most of which
seem to refer to Calc, over the past couple of weeks and searched the OOo
website for anything on DBs and found very little to help. I ended up
learning the basics of MySQL and then writing some structures in MySQL in
order to be able to follow what the Starting Guide was trying to say!
Probably worth it though.
Thanks again.
Ron Ferguson
Barbara Duprey wrote:
Oops - just looked again at the help and it was there. But I was looking
for an icon or something, not just the far left of the column headings
row.
----- Original Message -----
From: "Barbara Duprey" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, February 20, 2007 1:54 PM
Subject: Re: [users] [moderated] help
Thanks, Dan! I've tried various kinds of clicks (cell, column header,
Ctrl-A (and double Ctrl-A), never found that one. But when I looked in
Help for query printing, I didn't see that - just the technique of
dragging the query name. By the way, I'd be glad to help with
documentation (I've done a LOT of technical writing!) but I got no
response to my offer on the site a week or so ago, when I saw a
recommendation to somebody else that they should do that. Are the
documentation folks just too busy to even check their mail? :-)
----- Original Message -----
From: "Dan Lewis" <[EMAIL PROTECTED]>
To: <[email protected]>
Cc: "Barbara Duprey" <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2007 1:31 PM
Subject: Re: [users] [moderated] help
On Tuesday February 20 2007 12:45 pm, Barbara Duprey wrote:
The dragging occurs with the name of the query (from clicking the
"Queries" icon on the initial Base screen for the database), not
with the query results showing. That picks up the whole query
result as a unit, which you can then drop onto either a Writer
document (to get a table) or a spreadsheet. Sorry I wasn't clear
enough about that.
If you have the query results showing in the Data window at the
top, you can click the top left corner of those results. This will
highlight all the results. Then click this corner square and drag to
where you want the query results to be.
Dan
----- Original Message -----
From: "Ron Ferguson" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, February 20, 2007 11:06 AM
Subject: Re: [users] [moderated] help
Thank you, Barbara,
I had already created all the queries which I thought I would
need so do have the tables which I need and also the various
reports from the data.
I have looked at your suggestion regarding dragging, but it would
seem that only one cell at a time can be dragged - and I have far
too many to do each - if you know how to overcome this by
dragging a column at a time I would be grateful. This is by no
means an ideal solution but I can live with it, at least for now.
One of the problems with the DB may be that there is only the
totally inadequate "Getting Started" instructions and, even
worse, the Help Files associated with the DB are those for Calc -
which simply do not apply.
What I would like to know is how commercial concerns (of which
thankfully I am not one) manage these problems.
Ron Ferguson
Barbara Duprey wrote:
If I'm understanding your problem, it sounds as if you have a
table from which you want to select out specific fields for
another purpose. If so, have you looked at using queries? One
such query could be your Integrated Mailing List, for example.
Then you can open a new spreadsheet, and from the database view
that lists your queries, drag and drop the query onto the first
cell of the spreadsheet. From the spreadsheet, you can Save As
to csv.
----- Original Message -----
From: "Ron Ferguson" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, February 20, 2007 8:17 AM
Subject: Re: [users] [moderated] help
I wouldn't imagine that would be too much of a problem but I am
simply staggered that it should be necessary. To create a DB in
an office program that has little funtionality other than that
of a searchable catalogue is beyond my comprehension.
It never entered my head that once I had created the DB and
entered my data that I would not be able to fully use it. There
should be a big warning notice.
I will however have another look.
Ron Ferguson
Andis wrote:
I'm not expert in the field of databases, but may be it's
better to try
to start from another side and use mysql database instead of
openoffice.org native format. There should be lot of
documentation and templates for your needs in developer sites
like sourceforge.net. It should be also possible to reach and
manage mysql databases from openoffice.org.
But it's only my personal suggestion...
Andis
Ron Ferguson wrote:
Andis wrote:
Surely, Andis, that cannot be correct.
I have created a data base comprising what may be described
as Customer Details (addresses etc), Products, Orders, and
despatch. I can produce any report I wish.
However I wish to do two things more:
1. Create a cvs file so I can select from the Customer
details the records which I can import into my email program
either Thunderbird or
OE
2. Create an integrated Mailing List, again from the
Customer Details.
Without these to facilities the use of the DB for other than
playing with is very, very, limited.
Ron Ferguson
---------------------------------------------------------------
------ To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
----------------------------------------------------------------
----- To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/693 - Release Date:
19/02/2007 17:01
-----------------------------------------------------------------
---- To unsubscribe, e-mail: [EMAIL PROTECTED] For
additional commands, e-mail: [EMAIL PROTECTED]
-------------------------------------------------------------------
-- To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/693 - Release Date:
19/02/2007 17:01
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
