Subform in DataSheet view

[Steven]

I have a form with a subform which is in DataSheet view. I want the user to
be able to select all records so they can copy and paste easily in their
worksheet.

But I dont want them to be able to move the columns or resize the columns or
rows.

I tried a couple things but it seems that to be able to select the records
to copy then you have to give them enough rights that they will be able to do
those things.

I do not want to export the records becuase that is too long of a process
for this procedure.

Thank you for your help.

Steven

 

[Jeanette Cunningham]

Hi Steven,
use a continuous form instead.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Steven]

Jeanette,

Thank you, One other question. I would like to make a command button and
on the click event I want it to select all the records in the form and do a
copy (like Control+C) on that button click.

Is that possible?

Thanks,

Steven

 

[Jeanette Cunningham]

Yes that's possible. I have always used export to move data into Excel.
There are code solutions that will do copy and paste. Do a search on the
windows clipboard.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia