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
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar