Hello,
when I update a form with a new record, that record will copy to any previous record that I click in the same form.
This only happens when I'm adding records to a table that contains a memo field...
Anything I need to keep in mind about memo fields?
Kind regards,
Hans B.
I can not beleve it I have just designed a data base with tables ,queries, a switchboard,apend table/querie, an delete table/querie etc (all self taught) but the last thing I have to do is take the data from 1 table and idata from another table and put it together BUT!! table 1(orders) has space(Key),Customer,Order date, use buy date,Quantity, Product, Discription(no data in this field after apend), Date out (no Data in this field after apend)and a yes no box for delete(no data in this field after apend),Table two(Deleted) has the same data except it has data in the discription,date out and deleted fields. When I fill out the form (orders) I put a date out and tick the check box to delete the order. my apend querie takes anything with a tick and puts it in the deleted table and then my deleted querie deletes it off the orders table.
Hope you are still with me!!
So I want to do a querie that gives me all orders both the current and deleted but not duplicate the customer name.
Hope that makes sence
Hey guys!
I've a database which have some confusing names for its reports and forms. So as I found myself very confused when applying group policy to all the objects I was wondering if there is a way to rename those objects in a way that ALL the references in the hole database for the renamed objects will change too.
E.g.
Form_old_name -> form_new_name
then all the references will change both in the VBA code and in subforms references
I tried doing that mannualy and then using the search & replace tool to update the rewferences in the vba code. Turns out that all the database become a mess and now I have constant "out of memmory" messages
Thank you!
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:
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.
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 RelatedI 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.
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.
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
I have a memo field on a form that I only want 800 characters. (text fields don't seen to work). I'm looking for a piece of code that monitors the typing into a memo field and alerts the user that they are overe quota for that field when 800 characters are passed.
Any ideas are appreciated.
Hello There,
I wonder if someone can clear up a problem I am having. We have a system under development which is heavily dependent on an existing MS Access database. Some of the queries in the Access version of the application query Memo fields and they work fine within Access.
If I try to use exactly the same query from an ASP/Vbscript web page the query does not return the expected results. I am using ADO and an ODBC DSN connection, all of the other queries seem to work fine.
I have a vague recollection of being told that you can not query Memo fields through an ODBC DSN, or that not all of the Memo field is queried, only the first 255 characters. Can anyone confirm this is true. I have tried searching the web, and some references that I have available, but it seems that there is nothing out there to confirm my suspicions.
Any direction anyone could give me would be hugely appreciated.
Thanks in advance.
I'm working on a sub-form set to continuous and would like to amend a memo filed so that it autoexpands when entered. Have tried amending the height of the field through the on enter an on exit functions but this alters the size of the form.
Any clues would be much appreciated.
Fozi
Hello people.
Im just after a bit of advice please??
I have created an audit trail for data held on a form so that when a field is changed it adds a line of text to a memo field with the date of the change and the old and new field values. The problem I have is that each time something is changed the line of text is added beneath the existing text in the memo field. This means that for users to view the most recent change they have to scroll all the way down to the bottom of the memo field. Is there a "Quick" way of me having the most recent entry first.
I am using the vbnewline command when adding the text. A sample is shown below:
Dim Response As Integer
Dim AnotherItem As Integer
Dim sqlstr As String
Set Myform = Forms![DataDetail]
Producer = Forms![ListOfProducers(Existing Data Item)]![LstProducers].Column(1)
Response = MsgBox("Are you sure you wish to add a Producer?", vbYesNo, "Data Dictionary v1.0")
sqlstr = "INSERT INTO DataProducers ( Data_Id, Producer_Id ) SELECT Data.Data_Id, Producers.Producer_Id FROM Data, Producers WHERE (((Data.Data_Id)=[Forms]![DataDetail]![Data_ID]) AND ((Producers.Producer_Id)=[Forms]![ListOfProducers(Existing Data Item)]![LstProducers]));"
If Response = 6 Then
DoCmd.RunSQL sqlstr
Myform!LstHistory = Myform!LstHistory & vbNewLine & "Changes made on " & Now & ""
Myform!LstHistory = Myform!LstHistory & vbNewLine & "The Producer '" & Producer & "' was added to this data item"""
Myform!LstHistory = Myform!LstHistory & vbNewLine & "-----------------------------------------------------"
MsgBox "Producer has been successfully added.", vbInformation, "Data Dictionary v1.0"
Thanks folks...
A quick question... is it possible to sort a table by a memo field? I have a table and am able to sort by other, non-memo fields, however when I place my cursor in the memo fielld I would like to sort, the sorting option becomes 'greyed-out'. Is there a way around this?
View 7 Replies View RelatedHi,
I have an old database for generating service reports which has:
Report No
Date
Customer
Site
In separate fields which is fine
but also
wrk1
wrk2
wrk3
etc.
with a separate field for each printed line on the page
I would like to merge all these into one memo field while retaining the previous data which goes back 15 years (it came from a MSWorks 2.0 DOS db which is the reason for the weird structure I think)
Is there any way to write a macro or code to selectively merge some but not all fields in a table?
I've already copied the db and modified it after clearing all the old data, it works fine but I'd like to have access to the old data in the new format
TIA
Kim
I have a query that is displaying exactly the correct results. However, when I export this to a text/tab delimited file (or even and XLS file) it truncates the memo field to 256 characters in the export file. I am sure it has something to do with this memo field being defined in part by a custom function. Below is the query and the function. The field in question is the "Formatting(First(description_text)) AS prod_Description" column. Any thoughts? Note: I know that if I don't perform the "First" on this memo field, during the group by, the query would truncate this to 256 characters becuase it has to be in the Group By clause. But by using the First function, this field does not need to be included in the group by and there for the query does not truncate it (even though the exporting does).
SELECT ProductList.cin_id AS prod_ID, Formatting([desc]) AS prod_Name, "" AS prod_Flag, "" AS prod_OverrideName, "" AS prod_SortName, Formatting(First(description_text)) AS prod_Description, "" AS prod_Bullets, ProductList.mfr AS prod_Mfr, "" AS prod_itemSort, "" AS prod_ProdGroup, "" AS prod_SubprodSequence, "" AS prod_Layout, "" AS prod_BaseProductID, "" AS prod_ItemSubheadAttr, "" AS prod_Keywords, "" AS prod_URL, "" AS prod_Type
FROM ProductList
GROUP BY ProductList.cin_id, Formatting([desc]), ProductList.mfr
HAVING (((ProductList.cin_id)<>''));
****
Public Function Formatting(Text As String) As String
Dim outString As String
outSring = ""
If Len(Text) > 0 Then
outString = Replace(Text, "<b>", "{")
outString = Replace(outString, "</b>", "}")
outString = Replace(outString, "<i>", "{i")
outString = Replace(outString, "</i>", "}")
outString = Replace(outString, "°", "°")
outString = Replace(outString, "™", "™")
outString = Replace(outString, "©", "©")
outString = Replace(outString, "'", "'")
outString = Replace(outString, "®", "®")
outString = Replace(outString, "<sub>", "{^/")
outString = Replace(outString, "</sub>", "^")
End If
Formatting = outString
End Function
I've got an issue pertaining to inner joins within an update query. This query will not run now (giving the expected "must use an updateable query" error) due to two fields involved in one of the inner joins are now both memo fields.
Is there any way (and I assume there must be in vba) to recreate this query so it will run with inner joins involving memo fields?If not, is there a way in vba to do a find and replace within a table? For example, replace the "A" in "A-001" with "B"?
I have a large Db Which contains A Couple of Memo fields which due to the amount of data being stored in the Memo fields is starting to show signs of slowing down.One table contains 75,000, with all memo fields above 255.I wont have a problem with adding the extra code but was wondering if there is anything that may cause me a problem or if there's any reason(s) why I shouldn't follow this path.Many ThanksMickP.S. One Option would be to create 1-1 Tables and move the memo fields into the new tables that way I would still have an easy way of serching but it would reduce the size of the main table also none of the memo fields are included in any of the querys used, the problem with speed seems to be adding data I have checked the indexs which seem OK I can't remove any indexes Otherwise it slows down searching ACT.A copy Of the DB Is available here but it is an 11Mb Download should anybody wish to take a look at the tables structure and be able to advise on any imporvments that would be great please remember it's designed to store very large amounts of data.http://chartheaven.9.forumer.com/index.php?showtopic=107best wishesmick
View 3 Replies View RelatedI'm trying to export my table using the following code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "incidents", "c:Incidents.xls", True
But unfortunatly I get truncated errors upon export via the vba above. is it not possible to export memo fields to excel via vba?
I have a query that is truncating a memo field to 255 characters. There is no distinct, group by, format, union or concatenate in the query which are the common cause for truncation.The truncated memo field is comments.
Code:
SELECT HearingAuditTbl.CASE_NUMBER,
Null AS appealcaseid,
HearingAuditTbl.HEARING_ALJ,
Null AS DecisionCode,
HearingAuditTbl.DECISION_DT AS ALJ_Date,
HearingAuditViolations.VIOLATION_NO,
HearingAuditViolations.COMMENTS,
"CATEGORY_B" AS CATEGORY,
NOW() AS DATE_ADDED
[code]...
I have a Make Table query that includes a new field concatenated from a numeric field and a memo field, with some assorted text elements -
Issue Description:"("&[number]&") "&[Description]
When I run the Make Table, the new field "Issue Description" is created as a text field, NOT as a memo field.
Is there any way to insure that this field is created as a memo field.
Thanks.
Susan
We are running many MS Access databases in a mixed estate - mostly Windows XP terminals. The databases are split with the front end on the desk top and the back ends on a server running Windows Server 2003. We have a chronic problem of crashes when users go back into memo fields to add data - all text. The problem is intermittent, not possible to reproduce and varies in frequency.
View 2 Replies View RelatedIn 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.
I have two questions.
I have a form with 2 combo boxes. The first pulls from a simple list. Once you make a choice, the second combo box is then filtered by the first. This works correct, except that once a choice is made in the first, the filter is locked. If you change the first combo box's value a second time it does not effect the second box. The query that I am using for the second combo box has two columns that pull the first 50 characters of a pair of memo fields. Quote: SELECT MSSS.SS_ID, Left([Application_Name],50) AS Expr1, Left([Description],50) AS Expr2, MSSS.Site_Code
FROM MSSS
WHERE (((MSSS.Site_Code)=[Forms]![Edit or Delete Requests]![Combo6])); These fields are then used to populate 2 text fields using an event procedure. Quote: Private Sub Combo10_AfterUpdate()
' Display Partial Application Name and Description based on choice
Me!txtApplication_Name = Me!Combo10.Column(1)
Me!txtDescription = Me!Combo10.Column(2)
End Sub This is working fine, but it starts the next problem.
I need to change the form to include the entire memo field into a text box. I was using the columns of the second combo box to fill them in. Since the combo box is limited to only 50 characters, i could only grab part of it. I am guessing there is a much better way to accomplish what I need, but I am too inexperienced with forms and vb to come up with it. Below are the fields I need from table MSSS
Business_Name
Application_Name
Description
Acronym
Level_1_Support
Level_2_Support
Escalation_process
Troubleshooting
Priority
Links
Modified
Disabled
Thanks in advance to any help!
I'm trying to concatenate two text fields into a memo field using an expression in a select query. My problem is that the text fields together end up more than 255 characters, so I need the resulting field to be a memo instead. I can't change the underlying text fields to memo fields because this is a large database used by others who need those fields to be text.
View 3 Replies View RelatedWhat should I do so I can use memo field in database as a memo field so I can write text in more than one row.
For example what is happening now when my user pres enter he does not go to a new row in memofield but he goes to new record.
In fact how can I get something similar to this wysiwyg type?