Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Selective Query Update (Access 2003)

    Scenario:

    Input Query: qry Inventory

    I
    Cheers,
    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Selective Query Update (Access 2003)

    What do you mean by "I

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selective Query Update (Access 2003)

    Sorry about that Hans.

    In my previous Post: 630,125 you had helped me with the identification of a range of bin numbers. As I mentioned it worked perfectly and I ended up with a filtered query which contained the aforementioned group of bin numbers.

    What I
    Cheers,
    Andy

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Selective Query Update (Access 2003)

    Filtering a form doesn't have any influence on the table or query it is based on. So if you run an update query on that table or query, you will update *all* records in the table or query, not just the ones that have been filtered in the form.

    If you still want to know how to update the filtered records: you could use something like this:

    Dim strSQL As String
    strSQL = "UPDATE [qry Inventory] SET [Inv_Mst_CycleCount] = True WHERE " & Me.Filter
    DoCmd.RunSQL strSQL

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selective Query Update (Access 2003)

    Hans,

    Many thanks again. Another arrow in my quiver of Han-inspired coding. That's the good news. The bad news is that sometimes I obviously forget where I put the quiver <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    Cheers,
    Andy

Posting Permissions

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