Regarding error Message in Access 2007.
Posted on 2009-12-25
This question is regarding Access 2007.
I'm using SQL Server 2008 as my database and
I created all my table's/Procedures/Functions/Cursor's in SQL Server 2008.
I'm designing my screen's in Access-2007 by linking them to the SQL SERVER 2008 DATABASE.
Now the Problem is,I have a Address Form where user can enter a new address.
I also wrote a VB code to check each and every field in my form so that user does not
leave any field empty and also to dispaly Error message when a field is left blank.
Since my Address fields are created and set to NOT NULL in sql server.
When a field is left blank instead of Displaying my message The Access is displaying the following message.
You tried to assign the null value to a variable that is not a variant data type.
If i leave a field blank im my form,It is checking with sql server.
Now,I want to display my Error,For example if Address city field is left blank,I want to display my message"Please enter A Valid City" Insted of this
"You tried to assign the null value to a variable that is not a variant data type".
Please Help me!!!!!!!!!!!!!