PASTING OVER MANY FIELDS

[MMC @ L&G]

How would I go about pasting the same piece of text over many fields? I have tried to do it like one would paste over multiple cells in Excel, but although I select multiple fields, Access will only paste in the first field. Do I have to use a paste special function or something else?

 

[Jeff Clark]

create a query

You can switch to sql view and type:

update YourTableName set YourColumnName = "MyNewTExt" where something

How would I go about pasting the same piece of text over many fields? I

have tried to do it like one would paste over multiple cells in Excel, but
although I select multiple fields, Access will only paste in the first
field. Do I have to use a paste special function or something else?

 

[John Vinson]

How would I go about pasting the same piece of text over many fields? I have tried to do it like one would paste over multiple cells in Excel, but although I select multiple fields, Access will only paste in the first field. Do I have to use a paste special function or something else?

Pasting isn't really all that appropriate for relational databases,
however well it works in spreadsheets.

If you want to update multiple fields, the most effective way is an
Update Query. You can put the same text on the Update To line of the
query in the design grid, optionally put criteria to specify which
record or records will be overwritten, and run the query.

 

[mmadani]

You can select the column you want and paste the value from Excel. It works
just fine , if you are not too sure how to write a query, but keep in mind
Access is a database all related information fall in a record.



M. Madani

How would I go about pasting the same piece of text over many fields? I

have tried to do it like one would paste over multiple cells in Excel, but
although I select multiple fields, Access will only paste in the first
field. Do I have to use a paste special function or something else?