Latest activity

What's new Featured content New posts New profile posts Latest activity
  • A
    adamsro replied to the thread Solved Filter Report.
    days remaining is a calculated field based on 2 dates
  • DHookom
    DHookom replied to the thread Solved Filter Report.
    The key is whether or not the [days remaining] field is numeric or short text. If numeric, plog has provided the solution. If it is text...
  • The_Doc_Man
    The_Doc_Man replied to the thread DOGE.
    Might surprise you on that specific idea. If the workers are here illegally, and if illegal immigration is a felony, those who hire...
  • P
    plog replied to the thread Solved Filter Report.
    1. You don't need quotes around values when comparing numbers. 2. When compiling strings, you concatenate (put together) literal...
  • A
    adamsro posted the thread Solved Filter Report in Reports.
    Hello, I have a report i call to open but i would like to to only show items that are <= a numerical value that is entered before the...
  • The_Doc_Man
    The_Doc_Man replied to the thread Compile error again.
    The VALUES list is incorrect. You show ampersands (&) but first, I think you don't need quotes for anything inside that list, and...
  • A
    AccessBlaster reacted to Cotswold's post in the thread The Robots are Coming!!!! with Like Like.
    Apparently Elvis was seen wearing a Jewish Star on a chain around his neck. When he was asked about it, he explained that he wouldn't...
  • C
    ChrisLeicester replied to the thread Compile error again.
    Hi I will give that a go. Learning something new every day. Thanks I am getting this line as red; strAppSQL = "INSERT INTO...
  • C
    ChrisLeicester replied to the thread Compile error.
    Hi I should clarify The main form has two subforms, one being a child of the main form. ie. main form is transactions and subform is...
  • DHookom
    DHookom replied to the thread Compile error again.
    First, check the name of the shopping cart subform. I would do this a bit differently. Consider building an append SQL statement and...
  • Steve R.
    Steve R. replied to the thread DOGE.
    When faced with budget cuts and or government shutdowns the left loves to pull-out the crying towel...
  • C
    ChrisLeicester posted the thread Compile error again in Modules & VBA.
    Hi Taking advice from here, I am trying to move away from Macro's and use more VBA, although it is a learning curve. I have a main...
  • jdraw
    jdraw reacted to Gasman's post in the thread Extract part of a string with Like Like.
    Yes, I was thinking Right could pick up the last digit if a single character like that A example.
  • D
    dalski reacted to boblarson's post in the thread Getting active tab name from a form? with Like Like.
    This instead: Dim strTab As String strTab = Me.TabCtl14.Pages(Me.TabCtl14).Name MsgBox strTab, vbOKOnly, "Confirmation... "
  • isladogs
    isladogs replied to the thread Extract part of a string.
    I agree Mid is the right answer. Forgot about the first example
Show older items
Back
Top Bottom