Data type

D

Dinesh

Hi,
I am maintaining a (VB) software which is connected to a MS Access data
base. One of the field in the software is set for entering some descriptions
(text/ number/special char, etc). The data type in the data base initially
setup for " text ". But I under stood using this Data type I can have max of
255 char's where I need more to have. So I changed the datatype to " memo ".
But the software is not working and displaing an err msg - run time error,
error code 91. Is some thing 2 do with the software or MS Access?
Thanks
DInesh
 
D

Dirk Goldgar

Dinesh said:
Hi,
I am maintaining a (VB) software which is connected to a MS Access
data base. One of the field in the software is set for entering some
descriptions (text/ number/special char, etc). The data type in the
data base initially setup for " text ". But I under stood using this
Data type I can have max of 255 char's where I need more to have. So
I changed the datatype to " memo ". But the software is not working
and displaing an err msg - run time error, error code 91. Is some
thing 2 do with the software or MS Access?
Thanks
DInesh
Click to expand...

The VB error number 91 corresponds to the message "Object variable or
With block variable not set". Is this the error message you're getting?
If not, it's pretty much got to be an error in the VB program. If that
*is* the error you're getting, it's still most likely to be the VB
program, but maybe if you post the relevant code we can figure out
what's wrong.

What exactly did you change, and how did you change it? Did you change
the code, or did you open the database in Access and change the design
of the table, or both?
 
W

Wolfgang Kais

Hello "Dinesh".

Dinesh said:
I am maintaining a (VB) software which is connected to a MS Access
data base. One of the field in the software is set for entering some
descriptions (text/ number/special char, etc). The data type in the
data base initially setup for " text ". But I under stood using this Data
type I can have max of 255 char's where I need more to have.
So I changed the datatype to " memo ".
Click to expand...

Correct, when you seed more than 255 characters, use "memo".
But the software is not working and displaing an err msg -
run time error, error code 91. Is some thing 2 do with the software
or MS Access?
Click to expand...

What's the err msg? I think it's the software that has to be changed.
 
D

Dinesh

Hi Dirk,
Thats the err msg Im getting. I havent change any codes, what I did was in
the Database I changed the datatype to 'Memo' from 'text'. After that I
couldnt run my software, I got the err msg which you have mentioned. What I
guess is the software is designed for 'text' and if I change the data type
from the Database it doesnt understand it! Correct me if I am wrong.
Thanks
 
D

Dinesh

Hi Kais,
"Object variable or With block variable not set" this is the err msg im
getting.
Thanks
 
D

Dirk Goldgar

Dinesh said:
Hi Dirk,
Thats the err msg Im getting. I havent change any codes, what I did
was in the Database I changed the datatype to 'Memo' from 'text'.
After that I couldnt run my software, I got the err msg which you
have mentioned. What I guess is the software is designed for 'text'
and if I change the data type from the Database it doesnt understand
it! Correct me if I am wrong. Thanks
Click to expand...

It seems odd that you should get that particular error when that's all
you changed, but I suppose it's possible. Can you debug the VB program,
identify the line that is raising the error, and post the code from the
procedure containing it? That would be the only way we could see what's
wrong with it.
 
W

Wolfgang Kais

Hello "Dinesh".

Hi Kais,
Click to expand...

My firstname is Wolfgang.
"Object variable or With block variable not set" this is the err msg
im getting.
Click to expand...

As Dirk said: Try to debug the VB app and post the code.
I guess that the VB code defines parameters for commands that have
specific datatypes.
 
D

Dinesh

Sorry about that Wolfgang, for not using your first name; please forgive me
mate.
Thanks for both of you! I found the error in the VB coding, The acctual code
was written for data type " text ", not for " memo ". Thats why it has given
that error! I spoke to the software people and corrected it.

Thank once again
 
Top