471,078 Members | 807 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,078 software developers and data experts.

How to allow user to select records and modify field

How to allow users to select a set of records and then let them change a
field for all these records at once?
I would like to do this in code on a form.
I will have a form with tabular view of records, and I guess they will
select more than one record with the SHIFT key, then they can modify a whole
bunch of records at once.

Thanks
Nov 12 '05 #1
2 2653
If the users are knowledgeable on Access, allow them to create update
queries. Otherwise, you'll have code a form that does the same thing..
--
Dean Covey
www.coveyaccounting.com

MS-Office Certified:
http://www.microsoft.com/learning/mc...st/default.asp

"Danny" <da********@hotmail.com> wrote in message
news:kg*********************@news4.srv.hcvlny.cv.n et...
How to allow users to select a set of records and then let them change a
field for all these records at once?
I would like to do this in code on a form.
I will have a form with tabular view of records, and I guess they will
select more than one record with the SHIFT key, then they can modify a whole bunch of records at once.

Thanks

Nov 12 '05 #2
Add a field called Selected to your table. Create two side-by-side multiselect
listboxes like the wizards use for selecting fields. Display all the records in
your table in the left listbox. The rowsource for the left listbox should have a
criteria of False for Selected. Use code so that as you select records in the
left listbox Selected for those records will become True. The rowsource for the
Right listbox should have a criteria of True for Selected. If you requery both
listboxes after each selection, the record will move from the left listbox to
the right listbox. Once you have made all your selections, use an update query
to bulk change the field in all records where Selected is True.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Danny" <da********@hotmail.com> wrote in message
news:kg*********************@news4.srv.hcvlny.cv.n et...
How to allow users to select a set of records and then let them change a
field for all these records at once?
I would like to do this in code on a form.
I will have a form with tabular view of records, and I guess they will
select more than one record with the SHIFT key, then they can modify a whole
bunch of records at once.

Thanks

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

22 posts views Thread by MP | last post: by
2 posts views Thread by Mark Roughton | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.