I don't think you can trap it. The action is not in a form event as far as I know. It's a JET/ACE error. The only place that might work is the form's Error event. Is the default value set in the table or the form? If it isn't at the table level put it there because it sounds like the boolean (bit) is getting passed as a null which Access can't handle in a bit field. Bill --- In ms_access_professionals@yahoogroups.com, <desertscroller@cox.net> wrote: The table is a linked Access 2010 table. There is no code in the LOAD or OPEN events. Will be trying to find a way to trap the message but at this point not sure where to put the code. Rod --- In ms_access_professionals@yahoogroups.com , <wrmosca@...> wrote: Rod Is the table in an SQL database? Regards, Bill Mosca, Founder - MS_Access_Professionals http://www.thatlldoit.com Microsoft Office Access MVP https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E My nothing-to-do-with-Access blog http://wrmosca.wordpress.com --- In ms_access_professionals@yahoogroups.com , < JohnV@... > wrote: 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
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar