Display Text From One Memo Field And Multiple Records In A Report
Apr 10, 2008
I have an Access database where we grade reports. At the end of the grading form I have a memo field [Comments] for the grader to enter comments about why the report received the grade [Grade]. Each report is graded by multiple people. So for example, ReportNum 08-001 may be graded by 5 people and therefore will have 5 records in the database. I need a report to show all the comments for all the reports where the grade is <80. I know how to do this except for how to display all the comments from the memo field in the 5 records on one report for that ReportNum.
I hope I am making sense. I appreciate any help.
Jim
View Replies
ADVERTISEMENT
May 29, 2005
I use a memo field in a form. This memo field is used to store "steps" for doing something.
To keep things neat, I use ENTER between the steps so there is a blank line between each. This looks good in the form, however... I export this information (from the table) to a CSV/text file to use online. My online script requires that each record occupy only one line. But, the exported file has separated the "steps" into multiple lines just as it appears on the form.
I would like to use the HTML tag <BR> to separate the line feeds in the CSV file. I can enter these in the FORM instead of pressing ENTER, but then the form looks bad - harder to read.
Is this possible to do with code or filters or ??
Thanks for the help!
Mike
View 7 Replies
View Related
Nov 14, 2014
In 2002, I set up a database with Access 97 which included a table with a memo field. Through the years, the database has moved from Windows XP and Access 97 to Windows 7 and Access 2007.
Recently, the memo data has been difficult to edit (the display will move away from the cursor, or a new record will be inserted).
It appears to be logically straightforward to convert the memo data into multiple text fields as the memo field can be parsed for dates of entry.
View 3 Replies
View Related
Feb 1, 2006
I have a report based on a query. There is a field "comments" that is a memo type however on the report it does not display all of the text. I have the property "Can Grow" set to "yes" however it still only shows partial text. Any ideas? thanks in advance!
View 6 Replies
View Related
Mar 9, 2007
Hi All,
I can use some help with a jumping off poit.
*Please see attached file*
I have 2 tables tblSFDC and tblTheCall
tblSFDC (contact information) includes CustID (primary key) and a memo field "Notes"
tblTheCall (call information) includes CustID (relates to tblSFDC) and "activity data fields" ie "Live", Left Message" , Sent email".
tblTheCall may in some cases have multiple records for each CustID
I need to :
Concatenate from tblTheCall Field Names and field values (that are not null)
Insert into tblSFDC.Notes
Where tblTheCall.CustID = tblSFDC.CustID
*Please see attached file*
TIA
Detrie
View 8 Replies
View Related
Mar 14, 2013
I have an Access 2010 database with a memo field formatted for Rich Text.
I created a simple form. It accepts and shows paragraphs, i.e. I press Return and a new paragraph appears (with a blank line in between paragraphs).
I then created a report based on the same fields. In the memo field it shows the text entered in the form, but not the paragraph breaks. It just shows one big block of text without any paragraph breaks. I have looked for a field property in the report design and layout views that might affect how the text is displayed in the report but I cannot find one.
It is not much use if you can input paragraph breaks in a form but not see them in a report.
View 2 Replies
View Related
Jun 6, 2005
Hello Guys,
I am new to Access 2000 and issue is ,I have a field name product_name with datatype MEMO,when I chek my report at the place of product_name instead of the name of product it shows a squared symbol ,i dont understand how I can see the values of product_name.
SO anyone can help me out ,bcos of this I m stuck into my project.
Hope to get answer asap...
Thanks!
Vsap
View 14 Replies
View Related
Nov 9, 2013
How to display in a report a field with 50 records in two separate columns of 25 records.Is this possible or am I completely off the reservation?
View 2 Replies
View Related
Apr 1, 2014
I have a form with a memo field which is used by users to input transctiptions of Customer Contacts but the form is getting busy and the box now only 2.77 wide X 0.683 High.
this makes it impossible to read on the form even as a text box with scrolling..how to add a mouse over on it so that it fires up a large text/meg style box to display the contents?
View 1 Replies
View Related
Jul 24, 2015
We need to move rich text from an Access memo field to a Word text box. So far the best Ive been able to come up with is in the code below. In this code pprs!What is a record set field of a table memo field that is bound to a text box enabled for rich text. The rich text seems to be stored as html as so I can get word to convert it by enclosing it in html tags.
Dim What As Word.Shape
Set What = doc.Shapes.AddTextbox(msoTextOrientationHorizontal , doc.PageSetup.LeftMargin, 225, 534, 0)
Dim sPath As String
sPath = "G:Temp.html"
Open sPath For Output As 1
Print #1, "<HTML>" & pprs!What & " </HTML>"
Close #1
What.TextFrame.TextRange.InsertFile (sPath)
View 2 Replies
View Related
Aug 10, 2015
I have been unable to find a simple way to copy a text entry from a Table Field and paste it to multiple records in Datasheet view.The Toolbar 'Paste' procedure copies to the selected record only and I am unaware of how to select multiple records, as per a spreadsheet procedure.
View 2 Replies
View Related
Apr 21, 2014
My table:
tblHeatTreatment
- HeatTreatmentID - PK
- HeatTreatmentDesc - Text
- HeatTreatmentDetails - Memo
My form has a listbox (lstHeatTreatments - Multi-Select disabled) that displays Heat Treatment descriptions and an unbound textbox (txtHTDetails) that I would like to have display the corresponding memo field when a description is selected from the listbox.
This is my code so far:
Code:
Private Sub lstHeatTreatments_AfterUpdate()
Dim myConnection As ADODB.Connection
Dim myRecordSet As New ADODB.Recordset
Dim mySQL As String
Dim selectedRequirementKey As Long
Set myConnection = CurrentProject.AccessConnection
Set myRecordSet.ActiveConnection = myConnection
[Code]....
When I run the code I get an error:
Quote:
Run-time error '-2147352567 (80020009)':
The Value you entered isn't valid for this field
When I debug, it highlights:
Code:
Me.txtHTDetails = myRecordSet.Fields
View 3 Replies
View Related
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
Jun 27, 2007
Hello all,
I'm having a bit of a problem with a query that I am trying to run that searches a memo field, and I hope someone can help me!
Basically, I have a fairly simple database, 2 tables - 1 of the tables has a memo field which has 'keywords' listed in it (a mixture of words/phrases separated by commas, although I've tried with just spaces in between).
When I search using a Query box for 2 keywords using the following query, it can only find the correct records when I enter the keywords in the reverse order in which they appear in the memo field...
query: Like "*" & [Enter the 1st keyword to search for] And Like "*" & [Enter the 2nd keyword to search for] & "*"
If the memo field has data eg, "funding, teaching" (as opposed to "funding, nursing" for example) and I search for 'funding' and then 'teaching' - no results appear.
If however, I search for 'teaching' and then 'funding'... ta da! Result found.
Obviously, whoever searches the database isn't necessarily going to know what order the words were entered into the memo field!
So, is this a peculiarity to Access, or is there something I'm doing wrong?
Thank you in advance for your help.
View 4 Replies
View Related
Nov 8, 2005
Hello everyone - what I have is a a set of default text's that I need to be able to insert into a memo field - this is how I've set it up (Access 2000)
A table with the text fields in it called wordings
table comprises of
Id field
wordingnme (txt)
wording (Memo)
and I have a combo box on a form which looks up the wordingnme and hold this info - I need to have a button that will take this wordingnme and insert the wording that it relates to into the field of my record - Called Endor (memo)- I will have many text s say upto 50-60 but when I insert these into endor field I will probable only use say 5 or 6 at any one time on the record line so an example follows
line 45 in endor I wish to insert wordingnme "A" and then Wordingnme "B"
I also will do some free form type within this - any idea's :eek:
View 1 Replies
View Related
May 25, 2005
Hi,
Probably a really simple question, but is causing me problems! I need to be able to limit the amount of characters that can be entered into a field. For text fields I can just enter the relevant field size, but can not find an equivalent for a memo field. Validation rule warns you that there are to many characters, but doesn't seem to actually limit you.
Any suggestions would be appreciated.
J
View 8 Replies
View Related
Nov 21, 2006
Can anyone help....
I have a field on an Access db, this is a "Memo " type field which has many lines of text within it.
I need to run a query on this to get the last line of text within this field.
Aside from records where this memo field is filled in I also have records where the memo field is blank. So basically if the memo field is blank I want a blank field returned as well as fields with data.
I am using Access 2003 but also am running this on Access 2000 (not sure if there has been a change to function names)
This is seriously bugging me - can anyone put me out of my misery?
View 5 Replies
View Related
Jul 18, 2006
This is what is happening. I have created a data base that has a field that is set to be a memo field however when i linked that field to a form for entry it limits it to the 255 max characters for that the text field would have. has anyone ever come accross this problem and if so how do i over come it without starting over because the project is almost done.
View 7 Replies
View Related
Mar 10, 2006
Hi,
I have been searching and searching and cannot find any info on this specific problem.
I have a subform that users go into and enter data into the fields. Intermittenly, when a user closes out and then goes back in, the data in one of the fields (always the same field) is missing and has been replaced with ########.
Any insight or advice would be greatly appreciated!!
Thanks,
Krysti
View 1 Replies
View Related
Oct 21, 2004
I'm trying to save the contents of a text box into a memo field in a table, but after my code runs i look in the field and it is cut off after a hundred characters or so, and the last few characters are garbled. This is the code:
Code: DoCmd.RunSQL "UPDATE orderheaders SET orderheaders.Comments = [Text127] WHERE orderheaders.OrderNumber = " & GlOrderNumber & ""
orderheaders = table
Text127 = text box
GlOrderNumber = integer variable
Is there a way to do this with only code? (I dont want to do it by binding the text box to the field)
View 3 Replies
View Related
Dec 20, 2003
Hi
I'm new to forum and can't find an answer to this problem. I am using Access 2002 and have a memo field in a form that I want people to be able to type in as much text as they want. This is then displayed in a report. The form accepts the text with no problems however when I view it in the report it has been cut to 255 characters as if it is a text box. I have set the properties to 'can grow' to no avail. I have searched the MS Knowledge base for a solution with no luck. I admit I'm not an expert in Access and would really appreciate some help as I have been trying to overcome this problem for days.
View 2 Replies
View Related
Jan 6, 2013
The database contains the records of a collection of thousands of photographs and negatives.
One of the fields contains information on the subject matter of each pic and can sometimes be very long. The field was changed from text to memo so as to hold more characters but they appeared in one long string, which means a lot of scrolling to see the information. That has been changed back to text and we are adding a second or third record such as xxx-xxx-xxx cont1 xxx-xxx-xxx cont2 so as to get shorter strings. Is there a way to make the text wrap onto a second or third line automatically after a specific number of characters have been entered or can a carriage return be put in to force the text to a new line?
View 5 Replies
View Related
May 6, 2014
When I changed the memo field from plain text to Rich Text, I got the below divs and slashes. Is there any way to get rid of them?
<div>GC in process - EB1.</div>
<div> </div>
I had only "GC in process - EB1" in plain text.
View 1 Replies
View Related
May 10, 2013
I am having trouble creating a specifically formatted report.
Anyway, I have two fields: [Title] (plain text) and [Description] (memo). I want to combine the two but have the Title bold underlined but not the Description. I want it to look like this:
This is the Title. And this is the decription part that could go on for many, many more lines...
I have tried combining the two fields like: =[Title] & [Description] but if I set the properly to underline, then the whole thing is underlined.
Since the Title will vary in length, I cannot just underline the Title and then put the Description field next to it.
View 6 Replies
View Related
Apr 11, 2015
I want to create an app that works like Wikipedia. for example any word that have an explain and that's explain available in my database that word become hyperlink text with different color and so if operator click on that word open a new form and show the explain.
View 1 Replies
View Related
Nov 21, 2013
I have a Memo field in my table. I have changed the Text Format property to Rich Text. I can now change the formats etc of the values in the field.
However, I now want to see the Markup HTML tags in the table fields i.e. <b>test</b> in order for me to make changes manually as well.
View 5 Replies
View Related
