The Ctrl + D command from Excel

F

Fredrik

Hello!

This is a quite simple thing I guess.

I want to copy a cell from one record and paste in multiple records but in
the same row. In Excel I use the Ctrl+D command.

For example when I have a date, I do not want to write this in every record,
I want to write it in the first record and the copy/paste into the others.
(Can be 100+).

I'm working in a form in "table-mode".
 
D

Dennis

Use an update query. Select the table you want to update. Select the field
you want to update in the query grid. Change the query type to Update and
then put your value in the Update To row.
 
F

Fredrik

Hi again,

So it is not possible to do this a bti easier? Without having to use queries.
The reason I want this is because when I put in 20 orders I do not write the
Loadingdate and Unloadingdate untill the last order is put in the form. This
is because saving some time.
 
D

Dennis

You could do it with a button on your form with some VB Code behind the Click
event
similar to this (not quite sure of the exact syntax)

DoCmd.RunSQL "UPDATE TableName SET Loadingdate = #" & Me.Loadingdate & "#
WHERE IsNull(Loadingdate)"

same for the other date field.
 
Top