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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
