User Profile

Collapse

Profile Sidebar

Collapse
howard w
howard w
Last Activity: May 17 '21, 12:50 PM
Joined: May 14 '21
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • howard w
    started a topic RunSQL no longer recognizes RTRIM()
    in Access

    RunSQL no longer recognizes RTRIM()

    Code:
    DoCmd.RunSQL "UPDATE tmpVendorInventoryImport SET PartNumber = RTRIM(LTRIM(PartNumber))"
    fails -
    Error 3085 - Undefined function 'RTRIM' in expression

    ?? this works in 32 bit Office 365. Did I leave something out?
    See more | Go to post
    Last edited by NeoPa; May 15 '21, 09:29 PM. Reason: Added mandatory [CODE] tags.
    • howard w
      started a topic accdb shrinking
      in General

      accdb shrinking

      Finally get an accdb converted to 64 bit and noticed the file shrunk by 1/2. All good but it appears it saved some collection strings in places not available to me. Now the accdb can not be moved to another machine. I can move the file to another machine and change the source connection strings but the app fails with connection error. scanning the accdb shows instances of the old connection string. How can I recover?
      See more | Go to post
      No activity results to display
      Show More
      Working...