modules outside of access (1 Viewer)

S

Smiths101

Guest
I am able to get a module to work if I create it in ACCESS, which it DOES NOT access any tables within ACCESS. However, when I copy and paste the code within VB outside of ACCESS if will not work. Here is the error it references:

Option Compare Database <--

"No createable public component detected"

Can someone help me here?

Thanks!
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:03
Joined
Feb 19, 2002
Messages
42,990
The obvious answer is that Option Compare Database is unique to Access VBA and not included in VB VBA.
 

Users who are viewing this thread

Top Bottom