topic Re: field for last row in atable----robert bell specially in VBA Forum

field for last row in atable----robert bell specially

Anonymous — Fri, 30 Mar 2007 18:07:18 GMT

hi ,
sorry for calling robert specifically..i m stuck with this prob.i posted same type of question,but did not get answer.i have seen robert has solved field probs many times.i know robert "U have a job too" .but pl help me.
what to do to work in a field for diff. rows in a column?if i want to sum or multiply columns such as sum(D3:D5). but what about last row which is n no.
if n=6
"%<\AcExpr (Sum(D3:Dn)) \f ""%lu2"">%" or
"%<\AcExpr (Sum(D3:D(n))) \f ""%lu2"">%"

this field doesn't work.
pl help me .i m finding solution for reasonable amount of time.pl just give hint atleast.

thank u

Re: field for last row in atable----robert bell specially

Anonymous — Fri, 30 Mar 2007 19:59:26 GMT

You'll have to update the field's expression if you add new rows past the
previous range.

--
R. Robert Bell

wrote in message news:5536731@discussion.autodesk.com...
hi ,
sorry for calling robert specifically..i m stuck with this prob.i posted
same type of question,but did not get answer.i have seen robert has solved
field probs many times.i know robert "U have a job too" .but pl help me.
what to do to work in a field for diff. rows in a column?if i want to sum or
multiply columns such as sum(D3:D5). but what about last row which is n no.
if n=6
"%<\AcExpr (Sum(D3:Dn)) \f ""%lu2"">%" or
"%<\AcExpr (Sum(D3:D(n))) \f ""%lu2"">%"

this field doesn't work.
pl help me .i m finding solution for reasonable amount of time.pl just give
hint atleast.

thank u

Re: field for last row in atable----robert bell specially

Anonymous — Fri, 30 Mar 2007 20:18:39 GMT

thank u robert.
what i was asking was if i have rows 1 to n.what will b sum of these rows.i just got answer after long search.
"=Sum(D3:D" & CStr(AreaTable.Rows - 1) & ")"
this will probably solve many of my problems i encountered.
field expression has many aspects,and not good material is available in help files.
thanks for taking pain always.

Re: field for last row in atable----robert bell specially

Anonymous — Sat, 31 Mar 2007 19:32:33 GMT

hi,
i want to divide a field in to two parts.some questions wr asked of same type.but thr r no answers.

Lvl = "%<\AcObjProp Object(" & CStr(adBlockAttributes(4).ObjectID) & ").TextString \f ""%bl2"">%"
Lvl1 = Split(Lvl, "Lvl. ", 2)
AreaTable.SetText RowNum, 3, Lvl1(1)

as Lvl is referenced to attribute i want new field (lvl1) also referenced to attribute value.for some reasons i dont want to divide attribute value in to two in block itself.
thank u

Re: field for last row in atable----robert bell specially

Anonymous — Sat, 31 Mar 2007 21:35:44 GMT

If "Lvl. " is consistent, you could use the substr DIESEL expression in the
field to remove "Lvl. ".

--
R. Robert Bell

wrote in message news:5537546@discussion.autodesk.com...
hi,
i want to divide a field in to two parts.some questions wr asked of same
type.but thr r no answers.

Lvl = "%<\AcObjProp Object(" & CStr(adBlockAttributes(4).ObjectID) &
").TextString \f ""%bl2"">%"
Lvl1 = Split(Lvl, "Lvl. ", 2)
AreaTable.SetText RowNum, 3, Lvl1(1)

as Lvl is referenced to attribute i want new field (lvl1) also referenced to
attribute value.for some reasons i dont want to divide attribute value in to
two in block itself.
thank u

Re: field for last row in atable----robert bell specially

Anonymous — Sun, 01 Apr 2007 19:21:51 GMT

hello robert.thank u for reply.
i did this,i inserted field in to a field with diesel expression.
AreaTable.SetText RowNum, 3, "%<\AcDiesel $(substr,%<\AcObjProp Object(" & CStr(adBlockAttributes(4).ObjectID) & ").TextString \f ""%bl2"">%,6)>%"
the field expression is one field for example is,
%<\AcDiesel $(substr,Lvl. +2'6,6)>%
the result is 2'6
1....i can not update field by UPDATEFIELD command.i have to manually go and select and update specific field.
2.when instead of 2'6 it is 2'6" it gives XXXX.bcos of " character.
what is wrong in this.give suggestion.
pl also suggest whether we can use object.handle instead of object.objectid in field expression.
thankx