|
 |
access thread: Switchboard manager: error creating
Message #1 by "patrick slesicki" <patrick_slesicki@d...> on Thu, 13 Dec 2001 23:52:15
|
|
Hi I'm using the Switchboard manager in Access 97. After creating a
switchboard, I get an error message when I try to open it. The message box
reads "Compile Error: User type not defined. Additionally the FillOptions
procedure is highlighted yellow and the statement "Dim dbs as Database" is
highlighted blue. Does anyone know what's causing this? I do have sp2
installed if that's important.
Message #2 by Patrick_Slesicki@d... on Thu, 13 Dec 2001 15:52:23 -0800
|
|
PS the database I'm creating the switchboard for was initially created in
2000 then converted to 97. Only 2 tables were present at the time of the
conversion.
Message #3 by "John Ruff" <papparuff@c...> on Thu, 13 Dec 2001 15:56:40 -0800
|
|
Patrick,
It sounds as if you have lost a reference. Open a module and go to
Tools > References and see if any of your references are missing.
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: patrick slesicki [mailto:patrick_slesicki@d...]
Sent: Thursday, December 13, 2001 11:52 PM
To: Access
Subject: [access] Switchboard manager: error creating
Hi I'm using the Switchboard manager in Access 97. After creating a
switchboard, I get an error message when I try to open it. The message
box
reads "Compile Error: User type not defined. Additionally the
FillOptions
procedure is highlighted yellow and the statement "Dim dbs as Database"
is
highlighted blue. Does anyone know what's causing this? I do have sp2
installed if that's important.
Message #4 by "patrick slesicki" <patrick_slesicki@d...> on Fri, 14 Dec 2001 00:21:27
|
|
John
Thanks, that what it was. I was missing one to DAO 3.5, additionally I had
to turn off references to ActiveX. I don't know what the 2 do exactly, but
it seemed to work. Are there any possible dangers in doing this, and where
can I find a good primer on references in Access? Many thanks again.
> Patrick,
>
> It sounds as if you have lost a reference. Open a module and go to
> Tools > References and see if any of your references are missing.
>
> John Ruff - The Eternal Optimist :-)
>
>
>
> -----Original Message-----
> From: patrick slesicki [mailto:patrick_slesicki@d...]
> Sent: Thursday, December 13, 2001 11:52 PM
> To: Access
> Subject: [access] Switchboard manager: error creating
>
>
> Hi I'm using the Switchboard manager in Access 97. After creating a
> switchboard, I get an error message when I try to open it. The message
> box
> reads "Compile Error: User type not defined. Additionally the
> FillOptions
> procedure is highlighted yellow and the statement "Dim dbs as Database"
> is
> highlighted blue. Does anyone know what's causing this? I do have sp2
> installed if that's important.
>
>
>
|
|
|
View Cart
