473,322 Members | 1,403 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 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 2822
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Danny | last post by:
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...
6
by: Robin S. | last post by:
**Eric and Salad - thank you both for the polite kick in the butt. I hope I've done a better job of explaining myself below. I am trying to produce a form to add products to a table (new...
6
by: Cro | last post by:
Dear Access Developers, The 'Allow Additions' property of my form is causing unexpected results. I am developing a form that has its 'Default View' property set to 'Continuous Forms' and am...
1
by: rickn | last post by:
Being new to VB and programming, I'm not sure how to modify the following or if required have a Select statement to NOT allow any duplicates. I'm trying not to have any duplicates in the LOTNUM_72...
22
by: MP | last post by:
vb6,ado,mdb,win2k i pass the sql string to the .Execute method on the open connection to Table_Name(const) db table fwiw (the connection opened via class wrapper:) msConnString = "Data Source="...
2
by: Mark Roughton | last post by:
I have a form where the users need to view records for various criteria, one of which is a date field on which they may wish to view all related data for the selected date, for all dates upto and...
6
by: blouie | last post by:
Is there a way that a bound ddl control can: 1. display the bound data, even if it does not match a selection in the DDL? 2. allow the user to enter something other than the look up values? I...
1
by: Sunray | last post by:
I have a form called the sales form and i have 2 sets of listboxes So what happens is. i add items form the bottom set of list boxes which are bound to a data base to the top set of list boxes which...
2
by: Steve | last post by:
I've developed a database that will be used by my team (25 people) The database is based on the Resource Planner template The database will reside on a shared drive. What I'd to do now is create...
45
by: dizzydangler | last post by:
Hi, I'm new to access (2007, running on XP), but I've gotten some great help from this site on my project so far. However, the more I know, the more complex the problems seem to become.... I'm...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.