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

update all currently showing records

P: 13
hi all,

how about this?


I want to allow users to click a check box on a form to 'flag for testing'
thats fine - works great

but
what if there is 100 records and the user wants to flag ALL of them for testing?

how can i have a checkbox that basically 'selects all'

however, the 'all' must only be the currently returned records, there could be lots of filters currently active...

how do i know what the currently showing records are?


thanks for any info.!
Sep 1 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,669
hi all,

how about this?


I want to allow users to click a check box on a form to 'flag for testing'
thats fine - works great

but
what if there is 100 records and the user wants to flag ALL of them for testing?

how can i have a checkbox that basically 'selects all'

however, the 'all' must only be the currently returned records, there could be lots of filters currently active...

how do i know what the currently showing records are?


thanks for any info.!
Here is one system that will work:
  1. Create your Filter(s).
  2. Execute an Update Query that duplicates your Filter(s).
  3. Recreate the Filter(s).
    Expand|Select|Wrap|Line Numbers
    1. Dim MySQL
    2.  
    3. 'Create your Filter
    4. Me.Filter = "[Rank]= 'FF'"
    5. Me.FilterOn = True
    6.  
    7. 'Run an Update Query that duplicates the Filter
    8. DoCmd.SetWarnings False
    9.   MySQL = "UPDATE tblEmployee Set [Checked]=True WHERE [Rank]='" & "FF" & "'"
    10.   DoCmd.RunSQL MySQL
    11. DoCmd.SetWarnings True
    12.  
    13. 'Re-create your Filter
    14. Me.Filter = "[Rank]= 'FF'"
    15. Me.FilterOn = True
Sep 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.