I often do something like this:
I put Excel sourceSheet cells A1:c5 onto clipboard, then paste them to the bottom of MS Access table tTarget
After the paste operation, MS Access highlights the 5 new rows at the bottom of the table.
I want to write a generic Access macro that will "fix" those 5 highlighted rows.
excel and word have application.selection
Outlook has activeexplorer.selection and activeinspector.selection.
Does MS Access 2010 have something similar that would let me manipulate the 5 rows that are selected?
Something like this:
for each row in .rows
for each field in row.fields
if instr(field,"$p") > 0 then
field = replace(field,"$p",vbcrlf)