Select 1st row or "all" in datasheet

[LonghronJ]

I'm writing a procedure for users to paste rows of data to an empty form in datasheet view. Wanting to save the user a step, and afraid the user doesn't know how to paste data to a table, I'd like to select the 1st row or select top left corner (whatever this is called, which acts like selecting the first row when the table is empty), with codes that executes when the form opens, then the user just needs to press Ctrl V to paste the copied data. Does anyone know how to achieve this, selecting/highlight the first row?

[Perceptus]

when you click on the top left portion you are referring to, it hits the forms on click event. I use a similar function with the double click event on the form. I would use the double click event just the same, single click can get crazy.

Also you may be able to perform an Insert Into Select statement to achieve this in the background.

[LonghronJ]

I'm not sure I'm following you, Perceptus. The process is this...the user is copying rows of data from an Excel file. When the user comes to MS Access, they will go through a switchboard type form. When the user clicks on a button of "Paste Data", it opens up a empty table via datasheet form, then when the user closes the form, it will take that pasted data and insert the data to another table. I just need a method that highlights the top left corner, or the first row, upon opening the form. That's it.

[Perceptus]

like Ctrl + A?

[LonghronJ]

Unfortunately Ctrl A selects all cells with formulas, so even if a cell that is blank but has formula in it will be selected as well.

[LonghronJ]

Crap, wrong response to the thread. Ctrl A actually works. I thought I was responding to my Excel question in another forum

[Perceptus]

no worries. remember to mark solved!

[LonghronJ]

Wait, isn't it Ctrl A

SendKeys "^A"

It does not seem to work.