Results 1 to 3 of 3
  1. #1
    DennyCampbell is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    1

    Access Code Limitations

    Hello! I am hoping someone can shed some light on this for me. I have a customer who was using the 365 version of access on a windows 7 machine. There were no issues with the report on the windows 7 machine. When we got a new machine that had windows 10 on it, I was receiving #name? errors on the last few text boxes that were created. It looks like a code limit error(meaning I have too much code in my text boxes). If I delete a text box created way earlier it frees up one of the boxes I created later and doesn't have the #name? error. My question is why is this only happening on the new windows 10 machine? When i upgrade the windows 7 machine to windows 10 I do not have this issue. It is only on the windows 10 machine that was not upgraded from windows 7. They are all using the exact same version/build of access. Thanks in advance!!

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you move from 32 bit to 64 bit you must fortify the code API calls via PTRSAFE, so it will run in any environment:
    Code:
    #If VBA7 Then
        Private Declare PtrSafe Function CallNextHookEx Lib "user32" (ByVal hHook As LongPtr)
    
    Private Declare PtrSafe Function NextAPi Lib "user32" (ByVal hHook As LongPtr)
    #else Private Declare Function GetCurrentThreadId Lib "kernel32" () As Long
    Private Declare Function NextAPi Lib "user32" (ByVal hHook As LongPtr)
    #End If


  3. #3
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I would also check references in the VBA editor: Tools/References. See if any say Missing. I've seen that happen when there was a reference problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Access/Sharepoint Limitations
    By Dana in forum Access
    Replies: 1
    Last Post: 02-23-2016, 04:56 PM
  2. Access Size limitations
    By WilliamB in forum Access
    Replies: 4
    Last Post: 02-03-2015, 09:33 PM
  3. Advice on limitations of Access
    By smz in forum Access
    Replies: 4
    Last Post: 09-11-2014, 12:23 PM
  4. Replies: 1
    Last Post: 01-24-2014, 11:42 AM
  5. Access Limitations
    By kketchum in forum Access
    Replies: 2
    Last Post: 08-24-2006, 08:21 PM

Tags for this Thread

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