Professional Web Applications Themes

Select /Deselect checkboxes - Microsoft Access

Hi In a continious form I have a checkbox named OK. As I can filter the records by date and only show the records for a particular date , I'd like to automaticly select or deselect the checkbox for all records filtered. Is there a way to do this ? Thanks for replying Mario...

  1. #1

    Default Select /Deselect checkboxes

    Hi

    In a continious form I have a checkbox named OK.
    As I can filter the records by date and only show the records for a
    particular date , I'd like to automaticly select or deselect the checkbox
    for all records filtered.

    Is there a way to do this ?
    Thanks for replying

    Mario


    Mario Guest

  2. #2

    Default Re: Select /Deselect checkboxes

    Alan

    thanks a lot
    Mario
    "Allen Browne" <abrowne1_SpamTrapbigpond.net.au> wrote in message
    news:#gCJ9ggQDHA.1040TK2MSFTNGP12.phx.gbl...
    > Use an Update query limited to the same conditions as the form's filter:
    >
    > Dim strSQL As String
    >
    > If Me.FilterOn Then
    > If Me.Dirty Then 'Save any changes
    > Me.Dirty = False
    > End If
    > strSQL = "UPDATE MyTable SET [OK] = True WHERE " & Me.Filter & ";"
    > dbEngine(0)(0).Execute strSQL, dbFailOnError
    > Me.Requery
    > Else
    > beep
    > End If
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
    > Reply to the newsgroup. (Email address has spurious "_SpamTrap")
    >
    > "Mario" <MRMcns.be> wrote in message
    > news:e897XXgQDHA.3020TK2MSFTNGP10.phx.gbl...
    > > Hi
    > >
    > > In a continious form I have a checkbox named OK.
    > > As I can filter the records by date and only show the records for a
    > > particular date , I'd like to automaticly select or deselect the
    checkbox
    > > for all records filtered.
    > >
    > > Is there a way to do this ?
    > > Thanks for replying
    > >
    > > Mario
    >
    >

    Mario Guest

Similar Threads

  1. Select all checkboxes in datagrid via code
    By GeorgeWS in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: April 16th, 03:39 PM
  2. select checkboxes
    By FinanceCF in forum Macromedia Flex General Discussion
    Replies: 7
    Last Post: January 16th, 04:32 PM
  3. Hiding Checkboxes Based on Select Option
    By smilingriverman in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: July 15th, 04:48 PM
  4. Select multiple checkboxes
    By Ken Silanskas in forum ASP.NET Data Grid Control
    Replies: 2
    Last Post: May 11th, 07:06 PM
  5. How to select all or deselect all checkboxes in datagrid...
    By Al Knowles in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: December 1st, 06:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139