Work Order Report Help with field name

If this is the code to get a item description column, what is the field name for the item COMMENT that we entered when making the work order. We put the eBay item number in the item comments field-Ctrl F10 (not the transaction comment field-Shft F9).

Begin Column FieldName = "Item.Description" DrillDownFieldName = "" DrillDownReportName = "" Title = "Description" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2130 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Reply to
Mickie
Loading thread data ...

It's TransactionEntry.Comment You should be able to find a TransactionEntry.* column in your report to work from. The dataType should be vbString

Glenn Adams Tiber Creek C> If this is the code to get a item description column, what is the field name

Reply to
Glenn Adams [MVP - Retail Mgmt]

Thanks Glen, that did the trick!!

I just figured out how to attach to the database from MS access. Now I can see all the tables and field names. That will halp tremendoously.

Now, I just need a good XML WYSIWYG editor......

anyone?

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
Mickie

XMLSpy.

Glenn Adams Tiber Creek C> Thanks Glen, that did the trick!!

Reply to
Glenn Adams [MVP - Retail Mgmt]

? x?­VÁrÛ6½ó+6?´ÍÈt??ÄimÉr=ÉK×Óé"?$*`°,ÿ> ??lSlä?r|0??·»o:Ï\äì&àJ4??\8mh?9h??`KÝB§hý??n\Ý8Ð90H f(j¹6ÕÎeC`y?øÎF7ï_!S)À?«ºó·1( Ò!í@ï????Ü.V°ÖL

+Eò Îä[±ÌèýQ Lç?VtìïªÈI?\)?ÇKÓ4I®$*ç?U6Y? ?Ä-Lµ²t?ÎÕoOO?M·?A?é*)¼ó¯O6O?õ%?$2?0»å?±µV?&ÎÀ??ÏB­­ ¶·±h!ÖIù% [[ÝÔ`u?ÞÛfLQ???D¡bY?Vz²ÙV ´F;|?¼^î¬K¦¶|b&? ?!?/??_­-®?Hæ¢h r/ ðj¡`?s,+ý?3Ç6>êÜè ¨²,ËÐÚ?d}H?µ?!?@?m$?Î(I¹@ÉA± ÉÕóîõV2YY¬Pq­+»t?3]9ÙWH¬I?Zó »ûÕõÝýUßiø??ê´Â_Æ -^þÝh÷îüàÅçOp·?°(*÷g4ê+4?sï?km?²,ó¾TÎtéTW?7°¾§¤Nn(?>¥¾6¹P>þÊ+?l*åµF­kH?µ6? [m¶¡®¡$±Öë®Æ×ý³Y??TñÔw?õ ;?³ÃÍ:0m?å¡f=¯¹îÿS³p?ÛüßÊüà?G£âéi??ð4péÏ?i$U qá°?634¿?@¯§I| z?};TnÈÃ;?lz³X\.×ýÄ@"G?sÚ½[ÒB0r?£@ïêþ?Á ÖEpÕT^\1Ùq+?d#?©3æo^Ã÷JGï?ènßI;?`Uææ?ÿp?{p???d4 oîï[ú¬?õCç?JgûjÄÝ1ÿ?¡?:?éx¦Å3
Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.