Select New Record Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Microsoft,

I have a DataEntry form that is set where the Properties/Format/Default View
is DataSheet.

This form is used to Paste information from an Excel spreadsheet and it does
verification/validation with some code on each record as it is being pasted
in.

With that said, I am trying to have the "On Load" event SELECT (and not
GoTo) the new record. Reason being is that it is required to SELECT the new
record row in order to paste the information.

I need to set this up so that I can complete a macro/automation I have that
will copy the information from the Excel spreadsheet and paste it to this
DataEntry form. I just haven't been able to figure out how to have this
macro/automation SELECT the new record row.

Please help.
 
That is not the way to do what you want to do. You don't import excel into a
form, you import it into a table.
Import your excel data into a table, then use this table as the recordsource
for your form.
 
Thank you for your response. I know how to do that but this a multiple user
database and for others reasons as well that I don't see the need for me to
explain, I have created this verification/validation form as I did. My
macro/automation is complete except for this one part.

Again, all I am asking is for the code on how to Select (not GoTo) new
record. If anyone can help me with I would really appreciate it, thank you.
I would all accept the code for "Ctrl+A", this would also work.
 
It being a multi user database has no bearing on this. I am also unclear
what you mean by Select a new record as opposed to GoTo.
As I said before, you are doing it wrong. If you are unwilling to accept
good professional advice, the flounder around by yourself until you figure
out how is should be done.

I feel sorry for your users.
 
Klatuu,

You are truly rude; there is no need for insults. If you don’t understand
then don’t make suggestions.

All I need is the code that will Select the New Record row. When you click
on the left arrow that selects the entire record row, that is what I am
referring to.

Can anyone other than Klatuu provide me the code for Selecting the New
Record Row?
 
My response was predicated on your rude an arrogant response. I understand
the problem better than you do. I tried to help you, but you seem not to be
interested. Figure it out yourself.
 
Klatuu,

As I said before, I created this for multiple reasons that I did not see the
reason for me to explain, with that said, there is NO WAY you could
understand something you don't know the full details on better than the
originator.

Thanks for nothing, I did figure it out, this is what I was looking for and
nothing more, especially rude comments:

DoCmd.RunCommand acCmdSelectRecord
 
There you go again. "no reason to explain"....
How rude and arrogant. And, yes, I do understand it better than you. You
are using bailing wire and chewing gum approach. Cutting and pasting from
one app to the other is kludge. I care more about my users than to force
them to do something like that. In addition, the possibility for errors is
significant.

If you can't design a better app than that, trade your computer for a shovel
and go join a road repair crew.
 
"Does anyone know where I can trade a Computer for a shovel????" HAHAHAHAHA
Good one Klatuu.
 
Back
Top