Member Avatar for hell_tej

Hi Frends,
I m creating an access to VB6 connectivity Project.
I ahve problem that VB6 Gives not me permition to leave any field NULL so
when i save my record it genrate ERROR 94 That is invalid use of null value

In my project it is not necessary to fill all the fields.
PLEASE give me coading to leave alny field NULL in VB6
:S And yes, I was set all fields Required Value FALSE in ACCESS

PLEASE Send me some IDEA to leave any field null

  • 3 Contributors
  • 2 Replies
  • 127 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by manoshailu
Member Avatar for debasisdas

kindly post the part of the code that is throwing the error.

Member Avatar for manoshailu

Hi,

1) You can set the null value for the field by applying the value as "" or Not applying the value.

2) Check the Property for the Field

a) Required = No
b) Allow Zero Length = Yes


Shailaja:)

Hi Frends,
I m creating an access to VB6 connectivity Project.
I ahve problem that VB6 Gives not me permition to leave any field NULL so
when i save my record it genrate ERROR 94 That is invalid use of null value

In my project it is not necessary to fill all the fields.
PLEASE give me coading to leave alny field NULL in VB6
:S And yes, I was set all fields Required Value FALSE in ACCESS

PLEASE Send me some IDEA to leave any field null

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.