DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Aug 22 14:04:08 CDT 2006
Are you applying a filter or criteria to this form? If so, apply the same criteria to the Update query. Drew -----Original Message----- From: Gould, Nanette [mailto:nanette.j.gould at Vanderbilt.Edu] Sent: Tuesday, August 22, 2006 1:32 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Check Box - "Select All" Unfortunately, this approach doesn't work. For the form's recordset I'm querying records where the check box value is False. That's maybe 100 out of 4000 records. If I run a query to set those values to True then the refreshed form would load all 4000 records. I need to keep their existing recordset after they've done a Select All. The records they select get exported to Excel for upload into our GL. Thanks, Nanette -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid Sent: Tuesday, August 22, 2006 1:16 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Check Box - "Select All" OTOMH, I'd run an update query against the underlying table and then refresh the form. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gould, Nanette Sent: Tuesday, August 22, 2006 2:03 PM To: Access Developers discussion and problem solving Subject: [AccessD] Check Box - "Select All" I have a continuous form with a bound check box on each record. I'd like to give the user a "Select All" option at the top and set the value of each record's check box to True if they click Select All. It seems like this must be fairly simple but I've never had to do it before. Any suggestions? Nanette Nanette Gould | Dept of Finance | Crystal Terrace | 3319 West End Ave, Ste. 700 | 615.322.3540 | nanette.gould at vanderbilt.edu <mailto:nanette.gould at vanderbilt.edu> The information transmitted with any attachments is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. If you have received this email in error, please contact the sender and delete the material from your system. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com