Thank you Robin! This will require more technical skills than I have. I will submit this code to someone at my company's helpdesk, because I am not sure where I should copy this too.
Thanks again, Mark --- In [email protected], "Robin" <[EMAIL PROTECTED]> wrote: > > Hello Mark, > > Don't know about this copy to clip board, this is how I would do it: > > Dim db As DAO.Database > Dim rs As DAO.Recordset > Dim tmp As Sting > > Set db=Currentdb > Set rs=db.OpenRecordset("SELECT fldMemo FROM tblMyTable WHERE > fldID=1") > > tmp=rs("fldMemo") > > Open "C:\MyPath\MyFile.txt" For Output As #1 > Print #1, tmp > Close #1 > > rs.Close > Set rs=Nothing > Set db=Nothing > > After that you should have a textfile in the path and name you enter > (make sure it does not exist or it WILL overwrite) that you can open > with NotePad. > > Hope I got all the code right, it's off the top of my head. > > Watch out for the word wrap. > > Regards > Robin. > > > > --- In [email protected], "Mark Hallgath" <mhallgath@> > wrote: > > > > Brett, > > > > I agree with your assessment. I normally do not store more than 40 > > characters in a field. But, I have recently taken a job at a > company > > that references US government files. They use MS-Access to > streamline > > their report breakouts. The Memo field in question is populated > with > > govnmt legal jargin that I am not allowed to manipulate, other > than > > to publish it in spreadsheet. > > > > I performed a search of previous messages in this group and was > not > > able to locate previous postings regarding this issue. I will > modify > > my search criteria and try again. > > > > Thanks, > > > > Mark > > > > --- In [email protected], Brett Collings > > <brett.collings012@> wrote: > > > > > > Mark, sorry I don't have the answer but one of the others does, > I > > just > > > can't remember who. You'll hear from them shortly for sure. > This > > > question comes up here at least every 10 days, I just haven't > taken > > > notice except to know it's something to stay away from. > > > > > > Basically a database is not the ideal place for large globs of > > > memo-field type information - especially if they're larger than > 255! > > > > > > Brett > > > > > > > > > > > > Mark Hallgath wrote: > > > > > > > I have an MS-Access which has a field datatype set to Memo. A > > datatype > > > > of Memo is supposed to hold up to 65,535 characters. > > > > > > > > While I am able to insert and view more than 255 characters > into > > this > > > > field, I am only able to copy/paste a max of 255 characters > from > > this > > > > field into Notepad and/or MS-Excel. > > > > > > > > I have also queried from MS-Excel against the MS-Access > database > > but > > > > got the same results (max 255 characters). > > > > > > > > Can anyone advise me how I can copy the total number of > > characters from > > > > an MS-Access table (Memo) field into Notepad or MS-Excel? > > > > > > > > Any assistance is much appreciated! > > > > > > > > Thanks, > > > > > > > > Mark > > > > > > > > > > > > > > > > > -- > > > Brett Collings > > > Strengthening Families Administrator > > > D2D 46422 > > > DDI (04) 916 3422 > > > > > > > > > ------------------------------- > > > This email message and any attachment(s) is intended only for > the > > > person(s) or entity(entities) to whom it is addressed. The > > > information it contains may be classified as IN CONFIDENCE and > may > > be > > > legally privileged. If you are not the intended recipient any > use, > > > disclosure or copying of the message or attachment(s) is > strictly > > > prohibited. If you have received this message in error please > > > notify us immediately and destroy it and any attachment(s). > > > Thank you. The Ministry of Social Development accepts no > > > responsibility for changes made to this message or to any > > > attachment(s) after transmission from the Ministry. > > > ------------------------------- > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
