Lembit Soobik
lembit.dbamail at t-online.de
Fri Jan 25 06:05:35 CST 2008
Hello All, with the following code in Access 2002 I get a compile error that reads(translated from German): Only user-defined types, which are defined in public Object-Modules, may be converted to or from type Variant or passed to a function which is resolvable at runtime. ---------------start code----------------------------- Option Compare Database Option Explicit Public Type Verzeichnis VzID As Long VzPfad As String VzParent As Long End Type Public Function testCollect() As Boolean Dim ColPath As New Collection Dim dirPath As Verzeichnis With dirPath .VzID = 1 .VzPfad = "J:\" .VzParent = 0 End With ColPath.Add (dirPath)<-------------------------Error: dirPath is marked ----------------------------------------------------------- This code is in a module, not behind a form. Do I have to make this module public? if so, how? thank you Lembit