I have a form that is in datasheet view and each record contains about
10 fields. I would like to give the user an option to select records
they wish to copy by either clicking on them or having a "copy" button
somewhere that will allow them to select say 7 out of 10 records and
copy them back to a table. Ideally it would be nice to have the data
listed in a datasheet view, the user would select the records to copy,
the records would be inserted into a table and then a popup form is
displayed allowing them to change/add data to the records. Most months
the data is exactly the same, but there is a different service begin/
end date and the service type might change.

Any ideas?

On Oct 17, 1:38*pm, Annette <annet... (AT) co (DOT) saint-croix.wi.us> wrote:
You might want to look at the SelHeight and SelTop properties. Does
this link address your issue? http://kbalertz.com/294202/enumerate...ds-Access.aspx

"Patrick Finucane" <patrickfinucanetx (AT) gmail (DOT) com> wrote

I used that code in one form, and it does work. I did have a usability
issue, after the records are selected and the user presses a command button;
the highlighting on the records goes away. I have the function that works
with the selection highlight the records but it is not intuitive for the
user.

Thank you for the link. I downloaded the example and it appears to be
set up for a continuous form and not a datasheet. Has anyone gotten
this to work in a datasheet?

On Oct 19, 5:32*pm, Annette <annet... (AT) co (DOT) saint-croix.wi.us> wrote:
Hi Annette

One approach that may work for you is to create a new Yes/No field in
the table (called Selected, maybe). This would allow you to click in
each of the records you want to copy (or whatever) and then run a
query that has Selected = True as a criterion. You can clear all the
'Selected's easily with a bit of code or an update query.

HOWEVER ... this method is OK for single-user stuff. If there are
multiple users you can get some horrible complications when 2 or more
users are Selecting from the same table at the same time.

HTH

JB

"Annette" <annettem (AT) co (DOT) saint-croix.wi.us> wrote

Depending on the form, it can be structured to make a continuous form look
like a datasheet.

Move all your common controls into the form header or footer, leaving only
the repeating controls in the detail. Down side is the user will loose the
ability to change the column width and height; sort by clicking the column
and filter by data in the column.

On Oct 19, 11:32*am, Annette <annet... (AT) co (DOT) saint-croix.wi.us> wrote:
I'm at work and a lot of websites are blocked for me so I can't check
it out and I cann only go by the blurb of the page in Google.
http://access.mvps.org/access/forms/frm0033.htm. I've done what you
want to do long ago so I know it can be done. If this link doesn't
answer your question I suggest you do a search using your favorite
search engine,