Work Order Report Help with field name

Oct 02, 2006 4 Replies

Rate this thread:

Mickie 19 years ago

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

Vote

Glenn Adams [MVP - Retail Mgmt] 19 years ago

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

Vote

Mickie 19 years ago

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:

Vote

Glenn Adams [MVP - Retail Mgmt] 19 years ago

XMLSpy.

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

Vote

Glenn Adams [MVP - Retail Mgmt] 19 years ago

? x?VÁrÛ6½ó+6?´ÍÈt??ÄimÉr=ÉK×Óé"?$*`°,ÿ>??lSlä?r|0??·»o:Ï\äì&àJ4??\8mh?9h??`KÝB§hý??n\Ý8Ð90Hf(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æ¢hr/ð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*åµFkH?µ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

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required