selecting all records on continuous form using vb

[Mclaren]

Is there a way to select all records on a continous form in much the same way as using ctrl + A ?



If so, how do i go about coding it ?

[RuralGuy]

What are you attempting to accomplish? The Recordset of the form contains all of the records.

[Mclaren]

well, this may come as no suprise, but some users do NOT know the keyboard short cuts, and have come to me asking for a way to select all records on the form for copy paste reasons. So i am including: Select all, De-select all, Copy and Paste buttons to my forms.

Just giving the users as many options on the form as i can.

[orange]

As RuralGuy asked What are you trying to accomplish? Options for what exactly?

[Mclaren]

Like I said:

I want to give the user more options with regards to selecting data for copy and paste reasons.

Remember, WE know how to use access, some users don't. Some users don't know the key board short cuts either to select all records currently being shown on the form. I know that if it was me being the end user and using the actual database, i would know how to easily accomplish a quick Select all using ctrl and A. I may want to point out that on some forms, not all records in the underlying table are shown and that the data is the result of a filter on the form.

My users often have to copy data from the database to excel or other applications, so i am giving the user visible options on the form to make it easier and more user friendly to use.

[orange]

Maybe you should be designing some automation to handle this stuff that the users are not familiar with

My users often have to copy data from the database to excel or other applications,

[Mclaren]

Automation ? Well yes i could but, I cannot say when and how much data will be copied and pasted, and to which apps. That is for the user to decide.

Look if it cannot be done I'm cool with that, i would just like to include it.

I am pretty sure i don't need to keep going over the why's of why i want to include this, i just need to know if it can be done or not, and; if yes, how ?

[Mclaren]

I think i will add a usage counter to see how often it is used, if it is not used too much or if it doesn't give users any benefit i can then remove it again.

[RuralGuy]

I'm pretty sure you will find that ^A does not work either.

[Mclaren]

yip it does, tested and confirmed working.

[RuralGuy]

In that case then maybe simply using a SendKeys statement will suffice.

[Mclaren]

Ah, I know about the send keys statement but never used it, Hence I haven't thought about it, will do a bit of research.

Thanks RuralGuy.

[Mclaren]

Easier than i thought:

DoCmd.RunCommand acCmdSelectAllRecords

[RuralGuy]

Thanks for posting back with your success and solution.