473,322 Members | 1,610 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

trapping the untrappable ?

I hope someone can illuminate some error handling mysteries:
I read that if a func/sub doesn't do it's own error handling,
control propagates up the call stack to the sub that does have an
active "On Error", or failing that get's handled by the default access
handler(s).

I thought "Great, just what I need!", but from my experiments it
appears that this is not the case - that the scope of
"On Error" handling is strictly within the func/sub.

I am trying to trap the condition
"Cannot enter value into blank field on 'one' side of outer join."
but so far nothing I have tried successfully catches that error.
I have put OnError code into Form_Load, Form_Error,
TextBox_OnThisThatAndTheOther, but nowhere does
the above error get trapped.
If I could trap the situation in which a field-change was imminent, I
would create the (as yet non-existent) Detail record, link it to the
current Item record, requery, and proceed with the field change.

I have some forms which integrate fields from Item, ItemDetail,
ItemExtraDetail tables in a single, flat, design which looks just
like the eventual printed form. Many of the Detail fields are usually
blank. I am trying to resist fully populating the Details tables just
to avoid the above error condition
(which appears in the status line at the bottom of the access window).

At this point, the issue is one of trapping the apparently
untrappable. What am I doing wrong ? I am not doing
any weird or complex VBA coding or error handling, just the usual
stuff...
Nov 13 '05 #1
1 1697
Do you have referential integrity enforced between these tables, with
cascade updates?
- Turtle

"kurt klingbeil" <ku***********@fastmail.fm> wrote in message
news:6c*************************@posting.google.co m...
I hope someone can illuminate some error handling mysteries:
I read that if a func/sub doesn't do it's own error handling,
control propagates up the call stack to the sub that does have an
active "On Error", or failing that get's handled by the default access
handler(s).

I thought "Great, just what I need!", but from my experiments it
appears that this is not the case - that the scope of
"On Error" handling is strictly within the func/sub.

I am trying to trap the condition
"Cannot enter value into blank field on 'one' side of outer join."
but so far nothing I have tried successfully catches that error.
I have put OnError code into Form_Load, Form_Error,
TextBox_OnThisThatAndTheOther, but nowhere does
the above error get trapped.
If I could trap the situation in which a field-change was imminent, I
would create the (as yet non-existent) Detail record, link it to the
current Item record, requery, and proceed with the field change.

I have some forms which integrate fields from Item, ItemDetail,
ItemExtraDetail tables in a single, flat, design which looks just
like the eventual printed form. Many of the Detail fields are usually
blank. I am trying to resist fully populating the Details tables just
to avoid the above error condition
(which appears in the status line at the bottom of the access window).

At this point, the issue is one of trapping the apparently
untrappable. What am I doing wrong ? I am not doing
any weird or complex VBA coding or error handling, just the usual
stuff...

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Wugi | last post by:
I'm trying to find an equivalent of key-event trapping which is easy in QBasic. Several of my programs build up a geometric figure with two parameter line families, eg with two nested for..next...
8
by: Pete | last post by:
I'm trying to improve my code so that when I open a recordset object, I can absolutely guarantee it is closed and is set = Nothing. I have read some old threads and they all say to use the...
3
by: Paul | last post by:
I have an Access 2000 database with a form that is giving me some major headaches. When you open the form, it displays all records and allows editing, but has AllowAdditions set to False so that...
3
by: Nathan Bloomfield | last post by:
Hi there, I am having difficulty with a piece of code which would work wonders for my application if only the error trapping worked properly. Basically, it works as follows: - adds records...
3
by: windandwaves | last post by:
Hi Gurus Does anyone know how I set the error trapping to option 2 in visual basic. I know that you can go to tools, options and then choose on unhandled errors only, but is there a VB command...
13
by: Thelma Lubkin | last post by:
I use code extensively; I probably overuse it. But I've been using error trapping very sparingly, and now I've been trapped by that. A form that works for me on the system I'm using, apparently...
1
by: Chirag Malvi | last post by:
hello all, I am developing the web application using ASP.net and VS.2003 IDE. here is the situation which i want to implement. 1) User is browsing some webform. I want to trap this event....
2
by: Captain Nemo | last post by:
I'm still using Office 2000 myself, but some of my clients have Office 2003. I've recently added a piece of code to create an instance of Word, open a document, fill in the blanks and become...
9
by: 47computers | last post by:
Pretty new to PHP, I recently started learning about error trapping. As of right now, I include the following into a page in my website: -------BEGIN PASTE-------- error_reporting(E_ERROR |...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.