Girvin R. Herr wrote:
Barbara Duprey wrote:
Joe Grech wrote:
Hi. Is there a keyboard shortcut to enter a record underneath an
identical one in database without having to type the whole record
twice? TKS
I doubt it. In general, Base treats each field as an individual
entity, so a record's contents are not accumulated into anything like
a table row for moving, copying, or whatever. This whole area of
being able to select , copy, and paste things like full query result
sets, or records, or various other possibilities is one I'm really
interested in -- and I've been challenged to become a developer to
implement it! Probably will, if I can ever get out of crunch mode on
the project I'm on. Ideally, I'd like Base tables and query result
sets to be capable of acting as much as possible like Writer tables
for the kinds of operations that are supported. (By the way, I do
know about getting full result sets with Copy from the context menu
of a table or query, but it doesn't work for queries that request
parameters, which is one of the things I wanted to do.)
In this case, you're looking for something that is more or less
"insert record below current record and copy contents of current
record." But there is no real analog for "below" in a database table.
The closest possibility would be adding a new record using the last
displayed one as the pattern, probably with an auto-value primary
key. In that case, you could use the old "last" record, field by
field, using a combination of up arrow, Ctrl-C, down arrow, Ctrl-V to
populate it, then Tab to get to the next field -- marginally better
than retyping, probably.
Implementing this in a database would amount to "copy current record
(except for the key), create new record, paste into new record."
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Barbara,
Here is another option which may, or may not, be easier to implement:
It has been a few years since I last used MS Access, but it had a data
copy feature using Ctrl-' (single quote). Access must have kept the
previous record's data in the background (or produced a query for the
previous record's field data) and the user could merely click in a
field and use Ctrl-' to copy the previous record's field data into the
current record's field. If a whole record needs to be copied, this
can be more tedious, but in my admittedly limited experience, only a
few fields need to be copied and the remaining fields are new data.
Note that this copy worked for any subsequent record, not just a new,
unpopulated record, so data could be overwritten (changed) using this
feature.
Since OO.o Base does not yet have this copy feature, I have been using
the Ctrl-C / Ctrl-V process you suggest. It works, but is tedious.
Girvin Herr
That sounds like a special-case operation -- "I'm working on a record,
and I remember what the most recent other record I used had in this
field, so that's what I'll put in this current record's field with this
shortcut." Presumably as soon as you leave this new record, and it is
committed to the database, it becomes the "old" one. Not ruling out this
kind of thing, sounds handy in some cases, and it might be fairly quick
to implement. I think you'd still really be better off with a more
general-purpose record copying capability, though, it would be nice to
be able to paste more than one field at a time. In my very superficial
looking at this, the copy source would be any contiguously displayed
rectangular subset of fields in one or more records, as for Writer table
cells, and pasted into an analogous area, creating new records as needed
(if there is an auto-value primary key) or overlaying existing ones.
This same data could also go into a Writer table, for instance,
hopefully without the kind of multi-step operation currently required.
Actually, I'd probably want to use a Writer table as an intermediate,
anyway, similar to the way a report generates a Writer table, and allow
operations like search-and-replace, and .... You get the idea!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
