By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

How to allow user to select records and modify field

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.