User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 402,975 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,639 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 424 | Replies: 2
Reply
Join Date: Apr 2008
Posts: 16
Reputation: hell_tej is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
hell_tej hell_tej is offline Offline
Newbie Poster

How to leave NULL value in access database table in VB6

  #1  
Jul 19th, 2008
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
And yes, I was set all fields Required Value FALSE in ACCESS

PLEASE Send me some IDEA to leave any field null
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,213
Reputation: debasisdas is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 78
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Nearly a Posting Virtuoso

Re: How to leave NULL value in access database table in VB6

  #2  
Jul 20th, 2008
kindly post the part of the code that is throwing the error.
Share your Knowledge.
Reply With Quote  
Join Date: Jun 2007
Posts: 78
Reputation: manoshailu is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 6
manoshailu's Avatar
manoshailu manoshailu is offline Offline
Junior Poster in Training

Re: How to leave NULL value in access database table in VB6

  #3  
Jul 22nd, 2008
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


Originally Posted by hell_tej View Post
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
And yes, I was set all fields Required Value FALSE in ACCESS

PLEASE Send me some IDEA to leave any field null
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 8:00 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC