copy field content

[bob muzik]

CTL + Shift + F is supposed to copy data from the same field in the previous record into the current record. It doesn't work the way I understand it. It copies the data from the last record that was entered into the table, not the previous record you were in. I'm looking for something like "Control '" in ACCESS which truly copies the data from the previous record into the current record. I know this has been discussed before but I couldn't find anything in a search.

[Peter.Wayne]

RE: copy field content

if it is a single table, not a set, you can write a short
button script like this one:

t_name=table.current().name_get()
t=table.open(t_name)
data=table.current().record_data_get()
t.enter_begin()
t.record_data_set(data)
t.enter_end(.t.)
t.close()

for a more complex example, and for a discussion of the
xbasic behind this script, look at

http://www.learn alpha.com/duplicate/duplicate.htm

[forskare]

RE: copy field content

Bob,

I have the following (provided by another board member)on my form's OnKey event:

if a_user.key.value = "{F12}"
a_user.key.handled = .T.
sys_send_keys("{CTRL-SHIFT-F}")
'{ENTER}")
'sys_send_keys("{RIGHT}")
end if

This works great. Better tha Access as you only have to press theF12 key.

kenn

[bob muzik]

RE: copy field content

Wow. You guys are up early this morning. You're also too used to doing programming. Please note that I am working in a browse of a single table. Quite often I want to change the content of a field to be the same as that in the same field of the previous record in the browse. I'm not necessarily adding new records. In ACCESS, one just presses CTRL ' and the contents are copied from the previous field.

[crimmelcp]

RE: copy field content

Ken:
i use this type of script also and it works well on a single computer.
Do you know of anything that will work on a network where multiple people are entering data at the same time.
Could this pick up user 2 data, instead of the record that user 1 wanted.
Charlie Crimmel

[CALocklin]

RE: copy field content

I don't have time to work it out right now but I think this could be done with a little Xbasic which uses the current index to find the previous record.

However, I find it easier to just use Ctrl-C to copy and Ctrl-V to paste. OK, it's two keystrokes but it saves all the Xbasic programming. (On the other hand, I'm aware of the difficulty involved with getting others to stay away from the stupid mouse and use the keyboard on seemingly simple things like this. Some people claim they can't remember something as complex as Ctrl-C and Ctrl-V even though they can remember the phone numbers for 25 friends.)

[forskare]

RE: copy field content

Charlie,

Well, isn't that interesting? I'm on a single computer so never thought it wouldn't work with the database on the server and the server being accessed by more than one user at the same time. They're all using the same form. I'm not the Xbasic genius but I don't see why it wouldn't work. I take it, for some reason, it only allows one user at a time to be the copy cat.

How about putting it on a button? A bit unhandy cause I don't like jumping back and forth from the keys to the mouse, but it should work. (Unless there is a limitation as above)

kenn

[bob muzik]

RE: copy field content

Are you saying that if I go into the field I want to copy and do a ctrl c and then go into the any field of another record (providing they're the same type) and press ctrl v, that will do what I want to do?