I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardMS Access Interactive Topic   Print This     

simple select query blowing up on memo field

simple select query blowing up on memo field in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: blowing   simple select   simple select query   blowing up   memo field  
wrBodine
-- USA
Hi,

In Access 2000, a query performing a simple select statement is giving the following error:

Cannot include Memo, OLE, or Hyperlink Object when you select unique values (tblCustomers.Comments).

The Comments field above is a Memo field.

The interesting thing is that this error only occurs on one of our developer's workstations; the query works fine on the other 2. All 3 use Access 2000.

Any ideas??
Thanks,
Ray
 Posted 18 years ago (Thread Starter)
Comment Quote
About wrBodine -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5108, 1 replies
Thread Started 2/1/2002 11:51:00 AM
View Counter=2083
Location=-- USA 
Joined=18 years ago   MB Posts=4  
Most Recent Post
wrBodine
-- USA
Someone pointed out the answer to me; in the query properties "Unique values" had been set to "Yes" and needed to be "No"!! :)
 Posted 18 years ago (Thread Starter)
Comment Quote
About wrBodine -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5116 (Level 1.1)  Reply to 5108
Thread Started 2/1/2002 1:28:00 PM
View Counter=2
Location=-- USA 
Joined=18 years ago   MB Posts=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1242A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #5108 Counter
2083
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech