[AccessD] Check Box - "Select All"

I assume all the other records are true because they have already been
exported.

If so, you could do what Bobby said, but add a status field to the table
indicating whether these are "new" exports or not.  Whenever a record gets
exported update the status field to indicate that.

Then your recordsource query will look for all records where status = not
exported.  Do not use check box = false in this case.

Then all the check box is doing is allowing you to select which ones to
export and the status field is telling you whether is has or has not been
exported.  If check box = true and status = null then this record will be
exported next time.

Reuben Cummings
GFC, LLC
812.523.1017


> -----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: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
>