Thanks Jeff, even though I am not using a parent/child relationship, the idea made me re-examine how I implemented the form being called and found the issue. I had used a different template that was the problem so I started the form over from scratch and everything appears to be working. Thanks John, Bill and Jeff I think the project is just about complete, will be working on user and support manuals. Rod --- In ms_access_professionals@yahoogroups.com, <jpjones23@...> wrote: Hi Rod,
Are you working with a parent / child table relationship? When I read "associated table" I get the impression that the table is not the primary table but that it's a child table to the primary. If this is the case, what table relationships exist between the 2 tables. I've seen something like you are getting when a child table record is trying to be created before its time.
Just a thought.....
Jeff
----- Original Message -----
From: desertscroller@...
To: "MS Access Professionals" < MS_Access_Professionals@yahoogroups.com >
Sent: Friday, August 30, 2013 5:00:52 PM
Subject: [MS_AccessPros] RE: Help with system message
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
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar