Using Text Files Instaed Of Memo Fields

Mar 27, 2007

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 Thanks

Mick
P.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=107

best wishes

mick

View Replies


ADVERTISEMENT

Convert Memo Field To Multiple Text Fields?

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

Filtering With 2 Combo Boxes And Then Populating Text/memo Fields

Dec 14, 2004

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!

View 5 Replies View Related

General :: Concatenate Two Text Fields Into A Memo Field In Query?

Sep 5, 2014

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 Related

Modules & VBA :: Moving Rich Text From Access Memo Field To A Word Text Box

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

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

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

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

Formatting Memo Text

Mar 31, 2006

I have a database with a few large memo fields, used for storing methods for carrying out equipment tests. As I eventually want to output the methods in the form of reports, I want to be able to format selected text within each memo field (e.g. make the title bold, underline bits here and there, etc.) so that when output as a report, it looks like a nicely formatted document.

Does anyone know of an Access control that is basically a text entry box, but with formatting tools (maybe a row of buttons along the top?) associated with it that allow formatting of selected text only?

Incidentally, I have already tried linking Word documents as OLE objects, but this sems to require locating and selecting a Word file for each newly created record - something I don't want to do as this database will be used by people with few computer skills. I suppose I really want to be able to store an RTF file within the database.

Any suggestions much appreciated.

View 3 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

Memo Fields/boxes

Jan 23, 2006

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.

View 3 Replies View Related

Querying Memo Fields

Mar 22, 2007

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.

View 4 Replies View Related

Inserting A Text In To A Memo Field

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

Limiting Text In A Memo Field

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

Last Line Of Text From A Memo Field

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

How To Display MEMO Text In Reports..

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

Text Verses Memo Field

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

Long Text Or Memo Box Filtering

Feb 9, 2015

I have a long text box or memo box that I would like to filter but do not know how. How to set up a filtering feature to use for these types of boxes? I have no problems with short text boxes.

View 5 Replies View Related

Auto Expand Memo Fields

Apr 19, 2006

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

View 1 Replies View Related

Memo Fields - Order Of Data

Dec 6, 2007

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...

View 2 Replies View Related

Unable To Sort Memo Fields?

Mar 16, 2006

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 Related

Can I Merge 2 Txt Fields To 1 Memo Field

Apr 6, 2006

Hi,

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

View 3 Replies View Related

Memo Fields Mess Up My Database

Aug 8, 2007

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.

View 1 Replies View Related







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