Khalil Alsheyadi
asked on
Compile error? ??
I am making code in access
Dim db As Database
Dim rs As Recordset
Whin I click debud.. compile database..
Coming message
Compile error:
Expected user-defined type not project
What's problem that...? And what is wrong?
Khalil98
Dim db As Database
Dim rs As Recordset
Whin I click debud.. compile database..
Coming message
Compile error:
Expected user-defined type not project
What's problem that...? And what is wrong?
Khalil98
It would be helpful if you posted the entire procedure and highlighted the line where the error occurs.
Post your code, indicate exactly where the Error is occurring (line of code) ... and good things could happen :-)
In the Visual Basic Editor, you'll probably see an item Database Properties... in the Tools menu.
Select this item, change the Project Name to something different than Database (for example My Database), then click OK.
Select this item, change the Project Name to something different than Database (for example My Database), then click OK.
Have you tried Dim rs As dao.Recordset
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.