UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> User Defined Type Not Defined, Access 2016    
 
   
rizmin
post Jan 6 2019, 01:24 AM
Post#1



Posts: 177
Joined: 10-August 17



HI All,

I have faced a sudden runtime error as in the attached, My application was worked fine but I can't guess why its suddenly appearing.

I have attached my access VBA preferences and i am using the following codes for DB connection.
CODE
Option Compare Database
Option Explicit
Dim db As Database
Dim rs As DAO.Recordset
Dim rs2 As New ADODB.Recordset
Dim rs3 As New ADODB.Recordset
Dim cn As New ADODB.Connection
Dim SQL As String
Dim status As String


Anyone can help me on this please
Thank you.
Attached File(s)
Attached File  Error.PNG ( 8.86K )Number of downloads: 6
Attached File  Error1.PNG ( 20.85K )Number of downloads: 0
 
Go to the top of the page
 
June7
post Jan 6 2019, 02:14 AM
Post#2



Posts: 529
Joined: 25-January 16



This procedure was working before? Didn't make any changes? What line errors?

--------------------
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
rizmin
post Jan 6 2019, 02:16 AM
Post#3



Posts: 177
Joined: 10-August 17



Yes It was working fine,

I just do the modification for another form. But after executing this form got error.

Cannot imagine what I did?
Go to the top of the page
 
PhilS
post Jan 6 2019, 03:04 AM
Post#4



Posts: 568
Joined: 26-May 15
From: The middle of Germany


Use the menu item "Debug" -> "Compile ..." in the VBA-Environment. This will most likely point to the actual cause of the problem.

--------------------
Go to the top of the page
 
rizmin
post Jan 6 2019, 05:00 AM
Post#5



Posts: 177
Joined: 10-August 17



I have found the solution,

Just I checked the MS VB for application extensibility 5.3 then it works well!!

Thanks for everyone
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    25th May 2019 - 02:36 AM