Re: [TCLUG:15227] <OT> M$ Access rant and bug warning

[George Swan <g-swan@maroon.tc.umn.edu>]

At 12:51 PM 3/27/00 -0800, you wrote:
>serious bug: If you try to export the data in a report to a .txt file;
 I never, never, never export reports or forms!  ^^^^^
(I assume this is what you meant.)

>Access will spontaneously _"lose"_ every fourth record. this is a completely
>repeatable problem I have with Access 97; and it's cost the company a few
>thousand $ on one occasion. :(
>        if you output to an .rtf file; it will keep all the data, but will
>choose a font for it *AT RANDOM*. (of course, it'll usually be one of the
>exotic, hard to read ones).
>
>right now; I have a Select query that outputs 559 records. I tried exporting

I ALWAYS double check my numbers and counts when doing queries... 
even when I'm not exporting.

>it to an Excel spreadsheet (which one would think is a common; easy thing
>that Office should do perfectly..)
Not only that....  The field type assignments between the two
can drive you batty.  I most often feel safest when I pass through
an ascii phase when going from one to the other.

>        somehow the spreadsheet now as 640 records in it. ;<
>        and they're not sorted in the order that they were in the query
MakeTableQuery to a Table,
Sort the table, and THEN add an autonumber to signify the sort
Export as comma, tab, or ~ separated fields
Use UltraEdit to sort if moving towards a flat dataset for perl
Or Import into EXCEL and sort on the autonumbered field...

I could go on.....and on ... about these neurotic behaviors...

gs

>output. ;(
>        ah, found the problem.... it didn't exclude "some" of the records
>that I told the query to exclude. ~~;< (steaming from ears).
>
>oh, btw; this is on SR-_*2*_ of Office 97. ~~~~;<
>
>argh.
>it's this sort of thing that *really* makes me hate M$ with a passion.
>
>Carl Soderstrom
>System Administrator    307 Brighton Ave. 
>Minnesota DHIA	        Buffalo, MN	
>carls@agritech.com      (612) 682-1091
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tclug-list-unsubscribe@mn-linux.org
>For additional commands, e-mail: tclug-list-help@mn-linux.org
>
>
>
******************************************
George Swan
Collection Development Support Unit	VOICE:	(612) 624-5860
Room 170B, Wilson Library			FAX:	(612) 626-9353
University of Minnesota Libraries		g-swan@tc.umn.edu
309 19th Avenue South			cdm-web@tc.umn.edu
Minneapolis, MN 55455			colldev@tc.umn.edu
USA						http://www.lib.umn.edu/cdm/