Recent content by BButler

Re: How to prevent truncation of memo field (field > 255 char) on export to text file Solution appended: Short Answer - Confirm your Export Specification "Data Type" is set to Memo. Step "4)" should begin with -> In the Export Specification, confirm your Export Specification "Data Type" is...

Thought I'd post this extremely simple solution as I wasn't able to easily find it elsewhere. Solution thanks to thealy via BigResouce.com. Issue: Memo type table fields (or query generated strings) in excess of 255 characters are complete in Access but are truncated when exported to text file...

Another requirement that’s implied (but not called out) in the example is that the source table (see TBL) should reflect your desired groupings (i.e., the columns should be sorted by order of group levels – parent -> child) in such a way that your unique field (see PK) ascends sequentially...

vbaInet, Thanks for the welcome! Yes sir, both ways will work (and I didn't have numbering issues changing field order with either) but I'll defer to the one with the gazillion posts :D. And thank you for the attached example. As an homage, I've embellished your work by adding an additional...

Sequential Numbering within Groups with a Query Hi Alex, I'm sure you've long since cracked this nut but I thought I'd post a solution to your particular case because I wasn't able to find it elsewhere and needed the same thing. Enjoy, Bay Solution: 1) Your source table will require a...