ClaraBarton's latest activity

  • C
    ClaraBarton replied to the thread 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...
  • C
    ClaraBarton replied to the thread Syntax error "=".
    Click on any letter or number in the form except all accounts in the options at the bottom
  • C
    ClaraBarton replied to the thread Syntax error "=".
    Why does this work: If Me.selAlpha & "" = "" Then Else strStart = Left(Me.Controls("B" & Trim(Int(Me.selAlpha))).Caption, 1)...
  • C
    ClaraBarton reacted to tvanstiphout's post in the thread Syntax error "=" with Like Like.
    "selAlpha is an option control" We have to use precise language. Access does not have an "option control". It has an Option Group, and...
  • C
    ClaraBarton reacted to MajP's post in the thread Syntax error "=" with Like Like.
    Here is a demo with the correct syntax showing why the OPs original syntax will be a random control on the form and not the caption of...
  • C
    ClaraBarton replied to the thread Syntax error "=".
    Ok I get it! So I'm back to this: If Me.selAlpha.Value = 30 Then Me.selAlpha & "" = "" Else strStart =...
  • C
    ClaraBarton replied to the thread 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...
  • C
    ClaraBarton replied to the thread 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"...
  • C
    ClaraBarton replied to the thread Syntax error "=".
    Tom: If Me.Controls(Me.selAlpha).Caption = "All Accounts" Then Me.selAlpha = "" I thought that made sense but now I get "Object...
  • C
    ClaraBarton replied to the thread Syntax error "=".
    I want it in a string: If Me.selAlpha & "" = "" Then Else strStart = Left(Me.Controls("B" &...
  • C
    ClaraBarton posted the thread Syntax error "=" in Modules & VBA.
    This Works: If Me.selAlpha & "" = "" Then This does not work: If Me.Controls(Me.selAlpha).Caption = "All Accounts" Then...
    • 1771259570610.png
  • C
    ClaraBarton replied to the thread self-referencing table with bridge.
    I gotta tell ya... I spent several months messing with my transfers and categories. Never quite right. I just spent 2 days going back to...
    • 1771037011034.png
    • 1771037700997.png
  • C
    ClaraBarton reacted to LarryE's post in the thread self-referencing table with bridge with Like Like.
    It was my understanding that the OP wished to use ACCESS to post entries to an accounting system that is as close to Generally Accepted...
  • C
    ClaraBarton reacted to MarkK's post in the thread self-referencing table with bridge with Like Like.
    Here are my accounting system tables. • Journal rows that are in Invoices and Bills require a linked Payee, enabling creation of a...
  • C
    ClaraBarton reacted to LarryE's post in the thread self-referencing table with bridge with Like Like.
    In this example, 2 transactions occurred on 2/12/2026: VISA credit card was used to purchase groceries at Costco for $100.00. A debit...
Show older items
Back
Top Bottom