Results 1 to 4 of 4
  1. #1
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618

    User-defined type not defined.


    For reasons I work on an old computer for the last two weeks. My system has more than 200 forms. Every form has a button when clicked it opens a word document that informs the user about the form. The button worked fine. I do not know of something I changed but all of a sudden every form gives this error when I click on the button. It opens the VBA that opens the Word document. I read something about "Microsoft ActiveX Data Objects" and changed the settings as suggested, but the problem stays. What is this?
    Click image for larger version. 

Name:	Error01.png 
Views:	13 
Size:	31.9 KB 
ID:	41519

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If this issue was resolved, do you want to post your solution or have me delete this thread?

  3. #3
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    I opened any VBA page, then Tools and then references. The box for "Microsoft Word 16.0 Object Library" was not checked. I checked that box a few years ago. I do not know why it was unchecked, but it works now. I thought transferring my database to another computer the setting will come with. I assume it didn't.
    Last edited by Perfac; 04-11-2020 at 12:27 PM. Reason: Add something

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thanks for posting your solution! It will help others with the same issue.

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

Similar Threads

  1. Replies: 4
    Last Post: 10-16-2017, 09:09 AM
  2. DAO ERROR - User Defined type not defined
    By adamtate94 in forum Programming
    Replies: 2
    Last Post: 09-08-2016, 05:42 AM
  3. mydb - User-defined type not defined
    By adams77 in forum Forms
    Replies: 4
    Last Post: 07-22-2015, 08:43 AM
  4. Replies: 3
    Last Post: 11-12-2013, 04:13 PM
  5. user-defined type not defined
    By markjkubicki in forum Programming
    Replies: 3
    Last Post: 05-09-2013, 05:15 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