ClaraBarton's latest activity

  • C
    ClaraBarton reacted to RonPaii's post in the thread bad bracketing with Like Like.
    Change all your cases from "[" & DateField & "] ..." to & DateField & The brackets are not needed unless DateField has spaces or...
  • C
    ClaraBarton replied to the thread bad bracketing.
    using the string "tblTransaction.Ckdate" has worked for a long time but I need it for a combination of tables so I pulled together a...
  • C
    ClaraBarton replied to the thread bad bracketing.
    Function GetDateRange(DateField As String, RangeType As Integer) As String 'Last Month Dim firstmonth As Date Dim lastmonth As Date...
  • C
    ClaraBarton replied to the thread bad bracketing.
    a vba call. It goes in a where string for a listbox row source.
  • C
    ClaraBarton posted the thread bad bracketing in Modules & VBA.
    I have a function that requires a field name as a string variable. Function GetDateRange(DateField As String, RangeType As Integer) As...
  • C
    ClaraBarton replied to the thread filter combo.
    Nevermind! figured it out. I was using the wrong function. :confused:
  • C
    ClaraBarton replied to the thread filter combo.
    ok ok I'll fix the dates. Not the problem I'm having though. My question is about the GetSql_filter and the dates are not run through that.
  • C
    ClaraBarton posted the thread filter combo in Modules & VBA.
    @MajP I'm struggling with the GetSQL_Filter. Everything was working well until I added in the filter combos. I've tried to work through...
    • 1767314032090.png
    • 1767314486494.png
    • 1767314700870.png
  • C
    ClaraBarton replied to the thread Rich text format.
    Public Sub SQLString() Dim tfFiltered As Boolean Dim tfOrderBy As Boolean Dim sql2 As...
Show older items
Back
Top Bottom