VBA User-Defined type not defined

Question

Trying to fix the recent "Scriptlet.TypeLib" problem and tried to follow a solution outlined here: MS Access VBA Error: Run time error '70' Permission Denied in Access but I keep getting a "user-defined type not defined" error.

And which line of the VBA is highlighted when you get the error? — ThunderFrame
– ThunderFrame, Commented Aug 11, 2017 at 0:52

ThunderFrame · Accepted Answer · 2017-08-12 00:08:21Z

1

If you're using the code as posted in the other SO answer, and your compile error is occurring on this line,

Private Declare PtrSafe Function CoCreateGuid Lib "ole32.dll" (Guid As GUID_TYPE) As LongPtr

then it's likely because you're using an older version of Access (and a 6.x version of VBA), that is unaware of the LongPtr keyword. You should be able to just substitute Long for every instance of LongPtr.

edited Aug 12, 2017 at 0:08

answered Aug 11, 2017 at 0:54

ThunderFrame

9,5162 gold badges31 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ryan Over a year ago

I'm using access 2016. I'll give that a shot and see what happens.

Ryan Over a year ago

Thanks @thunderFrame, that worked. Like I mentioned this was Access 2016 but I still had to change it from LongPtr to Long. I don't know that I would have ever figured that out. Thanks again.

Collectives™ on Stack Overflow

VBA User-Defined type not defined

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related