Search results

  1. C

    Solved Where string

    :cool: :devilish::mad:(n):rolleyes:
  2. C

    Solved Where string

    I've worked all afternoon on this to find you nailed it all along: fAccountID = 47 AND (Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#) I had some old (really old) uncleared transactions. Thank you so much for all your help.
  3. C

    Solved Where string

    This form has been working on account and date but I was not getting the uncleared from before the date. Adding the cleared and uncleared messes it.
  4. C

    Solved Where string

    @cheekybuddha. That's exactly what I want. fAccountID = 47 AND (Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#) Doesn't limit the account... It's the WhereCondition on form open. the form recordset is" SELECT qryCkTransaction.TransactionID...
  5. C

    Solved Where string

    Cleared = False OR ((tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#) AND (fAccountID = 47)) Cleared = False AND ((tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#) AND (fAccountID = 47)) The first doesn't limit date The second doesn't return cleared withing date
  6. C

    Solved Where string

    fAccountID = 47 AND (Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#) Doesn't limit dates or account
  7. C

    Solved Where string

    Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And #2/25/2026# AND fAccountID = 47 Cleared = False Or tblTransactions.CkDate Between #1/1/2026# And #2/25/2026# Or fAccountID = 47 Cleared = False Or (tblTransactions.CkDate Between #1/1/2026# And #2/25/2026#) Or fAccountID = 47...
  8. C

    Solved Where string

    Oh Right! Where's my head? I'm getting All Accounts that aren't cleared. Else it's right. Thank you.
  9. C

    Solved Where string

    Private Sub btnReconcile_Click() Dim strWhere As String Dim cl As Boolean Dim strDateRange As String strWhere = "fAccountID = " & Me.Parent.txtAccountID strWhere = strWhere & " AND Cleared = False" strDateRange =...
  10. C

    Solved Where string

    How do I select all records with a boolean of 0 AND all records within a date range of boolean both 0 and -1? In other words all transactions that were not previously cleared in addition to cleared and uncleared of this month.
  11. C

    Syntax error "="

    Pretty sure this is a "WHERE" not an "AND" Code: Case 1<br> strWhere2 = " AND qryIncExp.[Hide] = FALSE" Oh so right! fixed it.
  12. C

    Syntax error "="

    thank you, arnelgp. After everyone's replies, I went back and reworked and fixed and finally got it. My problem wasn't what I though and I should have gone over the whole thing before bringing it here. Thank you all! Got me straight!
  13. C

    Syntax error "="

    Click on any letter or number in the form except all accounts in the options at the bottom
  14. C

    Syntax error "="

    Why does this work: If Me.selAlpha & "" = "" Then Else strStart = Left(Me.Controls("B" & Trim(Int(Me.selAlpha))).Caption, 1) strEnd = Right(Me.Controls("B" & Trim(Int(Me.selAlpha.Value))).Caption, 1) End If Returns null And this does not: If Me.selAlpha.Value = 30 Or...
  15. C

    Syntax error "="

    Ok I get it! So I'm back to this: If Me.selAlpha.Value = 30 Then Me.selAlpha & "" = "" Else strStart = Left(Me.Controls("B" & Trim(Int(Me.selAlpha))).Caption, 1) strEnd = Right(Me.Controls("B" & Trim(Int(Me.selAlpha.Value))).Caption, 1) End If How do I get this...
  16. C

    Syntax error "="

    The original form used A-Z to clear the filter but I added numbers and A-Z didn't work so well. Thus the All Accounts and I'll get rid of the A-Z
  17. C

    Syntax error "="

    selAlpha is an option control. See all the letters and numbers at the bottom of the form? It worked fine until I added an "All Accounts" button.
  18. C

    Syntax error "="

    Tom: If Me.Controls(Me.selAlpha).Caption = "All Accounts" Then Me.selAlpha = "" I thought that made sense but now I get "Object doesn't support this method" What I'm trying to do is simply clear the filter but I can't do a form filter because there are others.. It should be a very...
  19. C

    Syntax error "="

    I want it in a string: If Me.selAlpha & "" = "" Then Else strStart = Left(Me.Controls("B" & Trim(Int(Me.selAlpha))).Caption, 1) strEnd = Right(Me.Controls("B" & Trim(Int(Me.selAlpha.Value))).Caption, 1) End If '' Finish Where clause If strStart & "" = "" Then...
  20. C

    Syntax error "="

    This Works: If Me.selAlpha & "" = "" Then This does not work: If Me.Controls(Me.selAlpha).Caption = "All Accounts" Then Me.selAlpha & "" = "" I'm using Pat Hartman's form: I know I have a syntax error but I've looked at it and looked at it and I can't see it. Why does the...
Back
Top Bottom