ACCESS FEED: RE: [MS_AccessPros] Help with system message

Jumat, 30 Agustus 2013

RE: [MS_AccessPros] Help with system message

Rod-

Is there any code that runs in the Open or Load events?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rodbevill
Sent: Friday, August 30, 2013 12:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Help with system message

Good Morning John,
There is one field that has a default value. The field is BOOLEAN with a
default value of 0. I do use a couple of global variables but they are not
accessed until ready to post the new record. The rest of the fields are
strings and the autonumbered index.
Rod

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...>
wrote:
>
> Rod-
>
> I've seen that before, and I'm trying to remember the cause. Do you
> have Default Values set for any of the fields in the table?
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications SQL Queries for Mere Mortals
> http://www.viescas.com/ (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> rodbevill
> Sent: Friday, August 30, 2013 5:17 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Help with system message
>
> Hi All,
> I am receiving an information type message when entering data on a form.
> The form is launched by selection of a button. The form is used to
> enter information about a new owner to a parcel of land. When the
> associated table is empty and the first char is entered the following
> message is
> displayed:
>
> You tried to assign the Null value to a variable that is not a
> Variant data type.
>
> I am not sure where or why the issue is being generated. I have tried
> using break points in the code put they are never reached. There is
> no code associated with the OPEN or LOAD events or the CURRENT event.
> Only event being used is BEFORE UPDATE but it is triggered after the
message.
>
> ACCESS 2010 on Windows 7
>
> Rod
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

------------------------------------

Yahoo! Groups Links