Results 1 to 4 of 4
  1. #1
    dockeradz is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2020
    Posts
    2

    wherecondion max characters


    I have a docmd.openreport with a wherecondition that is throwing a size error. The wherecondion according to Len() is about 5k characters, and the max according to ms docs is 32,768 characters, so wondering if that changed in office 2019 (I'm using 2016) or if my DB is in an old format or something like that.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,345
    what kind of where are you trying to make? example?

  3. #3
    dockeradz is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2020
    Posts
    2
    It's something like this but has more "ComputerNames" in the IN() Statment. Basically it generates stickers for computers.

    [Machine Name] IN (ComputerName1','ComputerName2') AND [Out Of Service] = False AND [Disposed]=False

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,518
    Why don't you add all possible computer names to a static table that also has a IsSelected Yes/No field that you reset prior to running the report so you could use that in the report's recordsource?

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. I want exactly 10 characters
    By UT227 in forum Forms
    Replies: 7
    Last Post: 09-17-2018, 07:30 AM
  2. Replies: 5
    Last Post: 05-02-2016, 12:41 PM
  3. accented characters
    By linoreale in forum Access
    Replies: 1
    Last Post: 10-08-2014, 01:10 PM
  4. Only characters in field
    By Ruegen in forum Queries
    Replies: 13
    Last Post: 08-03-2014, 08:59 PM
  5. Replies: 9
    Last Post: 02-11-2013, 03:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums