Results 1 to 3 of 3
  1. #1
    tcheck is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    131

    Swithc board not working after upgrading to Access 2016 X64

    Yesterday I loaded Access 2016 X64 (we were on Access 2010 X32) and when I go into one of our databases that uses the older Switchboard Manager I get an error that the states;
    There was an error compiling this function
    The Visual Basic Module contains a syntax error.
    Check the code and then recompile it.

    Switchboard : Form : OnOpen : Embedded Macro
    Label1, 9, =DLookUp("ItemText","Switchboard Items","[SwitchboardID


    The error number is 2950

    Can anyone please help, the switchboard runs the whole database.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    the function is incomplete:
    =DLookUp("ItemText","Switchboard Items","[SwitchboardID]=" & me.id)

    but the switchboard does not need a Dlookup. It should work just by putting in the ID.

  3. #3
    tcheck is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    131
    IT works fine in Access 2010 X32 and 2016X32 but not 2016 X64. Do I need to compile it differently?

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

Similar Threads

  1. Not working in Access 2016
    By edm608 in forum Modules
    Replies: 13
    Last Post: 05-08-2018, 07:59 AM
  2. Can we create Discussion Board in Access 2016
    By prabakar in forum Forum Suggestions
    Replies: 0
    Last Post: 02-21-2018, 04:12 AM
  3. "Unable to Load DLL" after upgrading Office 2010 to 2016
    By NickMDal in forum Import/Export Data
    Replies: 3
    Last Post: 12-13-2017, 11:09 PM
  4. Replies: 3
    Last Post: 04-27-2017, 04:36 PM
  5. Replies: 1
    Last Post: 04-18-2016, 01:33 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