Can't Group On Memo

Jan 18, 2006

I have a field on a table that is a memo field. I am trying to write a query to include this field but get the "Can't group on memo or OLE object. Any ideas on why and how can I query with this memo field included?

View Replies


ADVERTISEMENT

Reports :: Sum Group Items By Specific Item And Hide Details Of Group Summing

May 29, 2015

Despite Google I can't seem to figure this out.

I have some data in a format similar to:

Name / Style / description / speed / distance
john / driver / careful / 80 / 5500
mary / driver / careful / 70 / 7000
pat / racer / reckless / 100 / 6000
anne / driver / careful / 75 / 1000
peter / racer / reckless / 110 / 6500
don / snail / slow / 60 / 6000

I want my report to total by style, without details and to look like:

driver careful 13500
racer reckless 12500
snail slow 6000

How do you get a report to sum the group items by a specific item and to hide the details of that group summing?

View 2 Replies View Related

Reports :: Control Group Expression For Group In Report?

Mar 28, 2013

Is there a way to have an expression in the control source of a text box in a report, that re-starts or is exclusive for every group within the report?

View 5 Replies View Related

Forms :: Option Group - Warn User When Neither Of 2 In Option Group Not Ticked?

Jul 25, 2013

I stumbled upon the Option Group function just yesterday and, happy as a clam, I created a group with 2 options in radio button style. I assigned the values to a field called Registration_Type as the 2 options are "Confirmed Registrants" and "Prospective Attendees".

[Great. That part works well. When I look at the table, a 1 or a 2 is in that field so it's great to know how to control accidental ticking of radio buttons (previous 450 records or so didn't have this option group functionality so one might easily tick one of the buttons. So one part of controlling option group I know I can handle via the table itself for now.]

The challenge is how to ensure the user always ticks one or the other ... I went back to the main table and tested the 'required entry' option for the Registration_Type field but forcing an action like this is not ideal in my mind. The usual error message vagueness for the average user is no good and I don't want to limit the user so much.

Is there a way to simply have a popup come up warning that neither radio button was ticked? Perhaps something linked to the form - i.e., maybe "after update"?? I only learned about attaching code to before and after update on controls a couple of days ago, so not sure if this would be best approach.

Just something to let the user know that nothing has been ticked in the option group as that controls in which of 2 reports the data will show up in so any record not ticked might mean a registrant being left out, which would be rather disastrous <g>.

View 1 Replies View Related

Asking Memo

Nov 28, 2006

Hi,

I create the table, and fieldname,

What is the datatype, memo?

Datatype: Text
Fieldsize : 255 (max char)

Datatype: Memo

For the memo datatype, what is the size for that?
Is it unlimited size?

Please let me know, thanks.

View 4 Replies View Related

Memo Datatype And DAO

Sep 21, 2006

Hi all

I've posted this in my usual Excel forum without any response so I figure someone here might be able to help. I'm using an SQL query in an Excel VBA macro to extract info from an Access table and dump it into an Excel worksheet, which works fine except for a Memo field, which is truncated to one character length - text fields are fine, just this one Memo field. I'm using the Microsoft DAO 3.6 library. Any ideas?

Cheers
Col

View 2 Replies View Related

Memo Fields

Aug 15, 2007

Hi All,

This is probably the simplest question to answer but alas I can't find the answer in any of my books!

I have a memo field which when made into the form is for a comments box (therefore has to be a memo box). However, the end user wants to be able to type in the comments and have this is paragraphs but of course the field doesn't want to do it.

I've tried various commands in the properties and also in the formats etc. and now I'm at a loss - can someone please give me some much needed guidance, and I really am sick of looking at this database and would like to get rid of it!

Thanks in advance guys.

Donna :eek:

View 2 Replies View Related

Append Memo

Nov 1, 2005

ok, I have been searching for a while, and no luck. I think I have come close, but not experienced enought to adapt code. I have a memo field on my form. I want to append new comments to this field without erasing the current data in the field. I want to do this through code. Can this be done?

View 2 Replies View Related

Update Memo Value

Sep 19, 2006

Is there a way to populate the value of a memo field with the push of a button. What I am trying to do is have a few default items that can be automatically entered into a memo field. When I attempt to change the value of the memo field either thru the wizard, macro or by using a simple code like me.[memofield]="test" I get the error that you cannot assign a value to this object or by using setvalue through a macro i get the error "Object doesnt support this property or method"

Any help with this would be greatly appreciated

Thanks

Ricky

View 4 Replies View Related

Memo With Date

Sep 28, 2006

Seem to be having a brain fade here, I have spent all day trying to figure this out.
I am trying to add notes to one of my forms with a date stamp. The form will be viewed every week so new notes will be added with new date stamp any ideas of the best way to do this.

Thanks in advance Kim

View 3 Replies View Related

Memo Fields

Jan 18, 2005

How can you use a memo field in a combo box.

How can you edit a memo field used by the combo box once it has been selected in a form.

View 1 Replies View Related

Memo Fields

Nov 2, 2006

I have a memo field in my database, as the data is too long to be a text field. The data in this field has been pasted in from other sources, and somehow it seems to have remembered the original pasted formatting, which was like a newspaper column. So when I include this field on a report, I get a thin column of text, even though the text box on my report is much wider. Is there a way of getting the text from my memo field to wrap to fill the width of my text box, so I get a neat-looking report. Thanks.

View 3 Replies View Related

Memo Box New Lines?

Nov 7, 2006

Is there any way of making a comments box (memo) have the functionality to press return and start on a fresh line as it all seems to run into one 'indecipherable blob'

View 1 Replies View Related

Memo Extraction

Dec 28, 2007

Using Access 2007 - My (Data Type) Memo field contains the following type of data ...

First Name: Jake
Last Name: Pies
Phone: 123-456-7899
Email: jakepies at apple dot com
Comments: Interested in all more information

How do I parse these records, about 400, located in the memo field column to multiple column fields: FirstName, LastName, PhoneN, Email, Comments.

Thanks, James

View 11 Replies View Related

Filtering A Memo Box

Apr 11, 2015

Just wanted to know if filtering a memo box was possible. I know it's not the best idea to do so but I could really find this feature for my database useful.

View 1 Replies View Related

Truncating Memo Field

Jan 26, 2006

I am using

DoCmd.OutputTo to export a query but this truncates the memo fields, but in the db window,right clicking and choosing to export does not truncate the data.


How do I code to output all the data without truncating?

View 1 Replies View Related

Memo Field Not Showing More Than 255

Jun 23, 2006

Hi guys and Girls

I have a txt box on a report which should show comments..
In the background table the field this txt box is bound to has a data type of memo. Yet the txt box on the report stops showing any more than 255 characters! any clues? I know 255 is the field size set for my Txt fields but memo fields should be able to display 65000000000000000 trillion characters with no problems.

When I look at the table the memo field has all the txt in it, it just wont display all the txt on the report.

Thanks for any help guys.

View 1 Replies View Related

Hyperlinks In Memo Fields

Dec 9, 2007

I have been asked if is possible to highlight some text in a memo field and make it a hypertext link.

A memo field can be changed to a hyperlink field, this is not what is wanted.

View 1 Replies View Related

Compare Memo Fields

Feb 5, 2008

Can someone tell me if this can be done somehow.

I have a date field, ID field and a memo field (I have to have this memo field).
I want to compare the memo fields by two certain dates and find out what doesn't match and if the ID field is blank. I have been trying with quaries but no luck.

I am not sure what forum this would fall under so I put it in general. feel free to move.

View 7 Replies View Related

Should I Avoid Memo Fields

Jul 18, 2005

I've read on this forum that memo fields can be a spot of bother. I only saw this after I put several memo data types in my tables. I wasn't going to do that much with them; it was intended as a electronic scratch pad of sorts for the user. Where does the trouble arise from with them? Should I just leave them or should I change them to text fields with 255 chars and hope that's good enough?

scratch

View 1 Replies View Related

Text Vs. Memo Field

Jul 28, 2005

Are there any other advantages in using a text field verses a memo field other than memory allocation? Memory allocation seems like such a small issue these days.

View 3 Replies View Related

Imported Memo Field

Mar 1, 2007

Hi, i have a fox pro memo field that has bill of materials information in like so:EACH KIT COMPRISES

1 CR10070SW £29.60 HALLITE PRODUCT
1 RBS24690 £0.82
1 RBS354 £0.95
2 RBS345 £0.75
1 S95MMEXT £3.90


£36.77 PER KIT

I need to take out the carriage returns but keep the items delimited in some way so they all apear on the one line. These are the child parts for kits so i need to keep them on one line as i import them or via a query so i can see the parent part they belong to.

Many Thanks

View 3 Replies View Related

Memo Field Length

Mar 26, 2007

Hello,

If I read the documentation then memo field in a Access table can be 65.000 chars long.
I have three memo fields in a linked ODBC table which is filled by a append query from SQL-server database. The text in these field is cut off by 255 chars.
Does somebody know what the cause of this can be?

1. Is there a limitation/property where I can configure the length of Access memo field? DAO? I have read something about this but I don't understand this.

2. How can I trace that everything is send from the source? Maybe it's cut off at the source site. On this moment I don't know something about a Linked tabel.
Is there a sniffer or trace tool so that I can see what kind of data is realy send?

Thanks in advance

Nico

View 2 Replies View Related

Query A Memo Field

May 31, 2005

Greetings All -

Let me say first I am a novice Access user, just trying to teach myself a few things to make my job easier. So take it easy on me with any feedback.

This is my situation. I am using a web based help desk ticketing software that has an Access DB. I have created a couple of queries and linked them together that seem to be working and giving me the data that I want with one exception.

I am tring to query a memo field, which is the description of a ticket, and the output is only a small portion of what is actually entered in to the table. Is there a way either in my query or report builder to make a change that will output all of the data from the description field?

A couple of things that I've tried on my own are to change the data type for that field from memo to text, however that that puts limits on the amount of data that can be entered in and causes the help desk software to function incorrectly. I've also turned on Can Grow and Can Shrink for the text box for the output in my form.

Any help you can offer would be greatly appreciated.

Thanks.
Jason

View 1 Replies View Related

Memo Field Truncating :s

Nov 23, 2005

Hi,

Ok, firstly i have search google and this forum from top to toe and no-1 has an answer that works for me.

I am running a query, now i have completely simplified it. The query is now just picking up a field called recommendations. Recommendations is a memo field with no formating or index on at all. Now, when i run the query as normal it works fine... everything is there. But when i have to group by it. It cuts it off at 255 charactors. The thing is i need to do some sums and counts within the query aswell so it has to be.

I have checked microsoft and there suggestions are not any use.

Any ideas???

View 2 Replies View Related

How To Query A Memo Field?

Dec 8, 2007

Hello,

I have Custormers table.

Name : Text
Address : Text
BDate : Date
Notes : Memo

Sometimes, I need to query Memo field.

I have a CForm which has a field named Search.
I want to query all Notes fields in Customers table via CForm!Search field.

Should I make a query like this? I use IN but I doesn't work.

SELECT Customers.Notes, Customers.Name, Customers.BDate
FROM Customers
WHERE (((([Forms!CForm!Search]) In (Customers.Notes)));

Thank you for your help,

Osman

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved