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.
----- 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]
