Multiple record paste

[rob.lyles]

I'm sure this has been asked a hundred times, but i cannot find a good answer. In a table, I am trying to copy paste from one field, one record (cell), into multiple records of that same field or any field I wish. Basically, I would love to highlight any range, whether it is single or multiple records and rows, and paste over where I choose. So if in records 1, 2, and 3, I highlight and copy the values in field A, how do I paste these values in records 4, 5, and 6 of field A, B, etc. I know I'm thinking in Excel mode, but I generally do not manually input my data in Access, but rather dump reports through Monarch.

Any help is appreciated,
Rob

 

[gemma-the-husky]

you cant do this in access -and in event you dont want to do this directly in the table

you SHOULD be able to use monarch to produce a csv - import the csv to a temporary table

(docmd.transfertext ...)

and then use append/update queries to bring the imported csv into your dbs tables proper

 

[Mike375]

You can you do the copy of paste, a simple macro will do that.

However, you would need queries to select the records for both copy and then the paste. The query would also restrict the field that were displayed. A multiple paste would be a Paste Append

Macro have an action called RunCommand and among other things you can replicate Tool bar functions, commads such as SelectAll