A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Class not registered" error received



 
 
Thread Tools Display Modes
  #1  
Old August 23rd, 2004, 04:19 PM
iccohen
external usenet poster
 
Posts: n/a
Default "Class not registered" error received

Hello-

I have Access 2000, and I imported an Excel spreadsheet as
a table in Access with no probs.

I tried to setup a field in my main table as a Lookup (no
problem), but when I attempt to bring the 2 columns across
in the Lookup dialog boxes and click Next, it states Class
not registered (as an informational dialog box), so I have
to stop.

Anyone know why this appears?

Note that the Field still shows the imported table as the
Lookup, and it still shows up in the Form, but the end
results in my Reports are incorrect.

Thanks,

-Steve


  #2  
Old August 23rd, 2004, 06:03 PM
tina
external usenet poster
 
Posts: n/a
Default

recommend you don't use Lookup fields in your tables. see the following link
for more info.
http://www.mvps.org/access/lookupfields.htm


"iccohen" wrote in message
...
Hello-

I have Access 2000, and I imported an Excel spreadsheet as
a table in Access with no probs.

I tried to setup a field in my main table as a Lookup (no
problem), but when I attempt to bring the 2 columns across
in the Lookup dialog boxes and click Next, it states Class
not registered (as an informational dialog box), so I have
to stop.

Anyone know why this appears?

Note that the Field still shows the imported table as the
Lookup, and it still shows up in the Form, but the end
results in my Reports are incorrect.

Thanks,

-Steve




  #3  
Old August 24th, 2004, 03:52 PM
iccohen
external usenet poster
 
Posts: n/a
Default

Interesting stuff. Unfortunately, they don't recommend
what to do. I have several hundred ports I need to setup,
and now I'm stumped!


-----Original Message-----
recommend you don't use Lookup fields in your tables. see

the following link
for more info.
http://www.mvps.org/access/lookupfields.htm


"iccohen" wrote in

message
...
Hello-

I have Access 2000, and I imported an Excel spreadsheet

as
a table in Access with no probs.

I tried to setup a field in my main table as a Lookup

(no
problem), but when I attempt to bring the 2 columns

across
in the Lookup dialog boxes and click Next, it states

Class
not registered (as an informational dialog box), so I

have
to stop.

Anyone know why this appears?

Note that the Field still shows the imported table as

the
Lookup, and it still shows up in the Form, but the end
results in my Reports are incorrect.

Thanks,

-Steve




.

  #4  
Old August 24th, 2004, 08:11 PM
tina
external usenet poster
 
Posts: n/a
Default

post detail of what you're actually trying to accomplish, maybe i or someone
else can help further.


"iccohen" wrote in message
...
Interesting stuff. Unfortunately, they don't recommend
what to do. I have several hundred ports I need to setup,
and now I'm stumped!


-----Original Message-----
recommend you don't use Lookup fields in your tables. see

the following link
for more info.
http://www.mvps.org/access/lookupfields.htm


"iccohen" wrote in

message
...
Hello-

I have Access 2000, and I imported an Excel spreadsheet

as
a table in Access with no probs.

I tried to setup a field in my main table as a Lookup

(no
problem), but when I attempt to bring the 2 columns

across
in the Lookup dialog boxes and click Next, it states

Class
not registered (as an informational dialog box), so I

have
to stop.

Anyone know why this appears?

Note that the Field still shows the imported table as

the
Lookup, and it still shows up in the Form, but the end
results in my Reports are incorrect.

Thanks,

-Steve




.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Class not registered Mato Nanjin General Discussion 3 August 2nd, 2004 06:23 PM


All times are GMT +1. The time now is 06:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.