T Tiff Oct 5, 2009 #1 I have created a macro that autopastes the rows but need to know how many rows I am autopasting. thank you tiff
I have created a macro that autopastes the rows but need to know how many rows I am autopasting. thank you tiff
J Jeff Boyce Oct 5, 2009 #2 Tiff "... that autopastes the rows ... " What rows? What is the source of what you are pasting? -- Regards Jeff Boyce Microsoft Access MVP
Tiff "... that autopastes the rows ... " What rows? What is the source of what you are pasting? -- Regards Jeff Boyce Microsoft Access MVP
T Tiff Oct 5, 2009 #3 The rows are as a result of a make table query which has date parameters. The table we are running it from are from a linked table. thank you tiff
The rows are as a result of a make table query which has date parameters. The table we are running it from are from a linked table. thank you tiff
J John W. Vinson Oct 5, 2009 #4 The rows are as a result of a make table query which has date parameters. The table we are running it from are from a linked table. Click to expand... Use VBA instead of a Macro, and use the Execute method; this gives you a RecordsAffected property. See the VBA help for RecordsAffected.
The rows are as a result of a make table query which has date parameters. The table we are running it from are from a linked table. Click to expand... Use VBA instead of a Macro, and use the Execute method; this gives you a RecordsAffected property. See the VBA help for RecordsAffected.
