invalid property value

greetings!

had been encountering this problem nowadays...

Runtime Error : '380'
Invalid property value


what am trying to do is just retrieve the fieldsize of a field from a query

am still using vb6, mysql, and crystal report 8.5 since it's all what my
company had...

we seldom encounter this problem but still, i wanna know what's going on
with this problem and what the heck does triggers it.

here's my code...

Private Sub Form_Load()
OpenQueryDNS "SELECT * FROM DI2360 LIMIT 1", objdbRs, False
frmLogin.txtUserName.MaxLength = objdbRs.Fields.Item("USERID").DefinedSize
End Sub

OpenQueryDNS is my UDF just for query purposes, i store the result in a
RecordSet named objdbRs...

what i always get is a -1 value, but on most of the computers we installed
this customized application, we never encountered such. it should return a
value equivalent to the size of the field "USERID", lemme say 6.

any help is of great use.

thanks in advance...

--
mckouleith
.

Relevant Pages

  • RE: invalid property value
    ... "mckouleith" wrote: ... > had been encountering this problem nowadays... ... > Private Sub Form_Load ... > OpenQueryDNS is my UDF just for query purposes, i store the result in a ...
    (microsoft.public.data.ado)
  • Re: DHookom AYS2000 - compiler error
    ... Don't have access to newsgroup in office:) and we can't take work with data ... except the little problem when I try to compile. ... However, I'm encountering a teeny ... Private Sub QstnText_BeforeUpdate ...
    (microsoft.public.access.tablesdbdesign)
  • DHookom AYS2000 - compiler error
    ... I successfully implemented the survey database to do the Mental Status Exam ... I'm encountering a teeny weeny ... problem when I try to compile. ... Private Sub QstnText_BeforeUpdate ...
    (microsoft.public.access.tablesdbdesign)
  • Re: DHookom AYS2000 - compiler error
    ... I'm encountering a teeny weeny ... problem when I try to compile. ... Private Sub QstnText_BeforeUpdate ... encountered in other applications problems when I used the IsNull function ...
    (microsoft.public.access.tablesdbdesign)