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    
post Jan 6 2019, 01:24 AM

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.
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
post Jan 6 2019, 02:14 AM

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
post Jan 6 2019, 02:16 AM

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
post Jan 6 2019, 03:04 AM

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
post Jan 6 2019, 05:00 AM

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