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]
