473,322 Members | 1,408 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.

Can i suppress Acess message ?

Is there any possibility to suppress a message box from Access ? I have
a complicated but a good code that calculates the possibilities in the
before update event, and if a condition is met, then it exits the
sub.In short, if this condition is met, then after the exit sub I get
the following message box:
Runtime error 2105 you cant go to the specified recod

END DEBUG

If I click on End, then the code is perfect,everything I cleared and I
can begin anew.If only I could auppress the appearance of the message
box.Can someody help me ?

Feb 13 '06 #1
2 4758
"solar" <sp*******@gmail.com> wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:
Is there any possibility to suppress a message box from Access
? I have a complicated but a good code that calculates the
possibilities in the before update event, and if a condition
is met, then it exits the sub.In short, if this condition is
met, then after the exit sub I get the following message box:
Runtime error 2105 you cant go to the specified recod

END DEBUG

If I click on End, then the code is perfect,everything I
cleared and I can begin anew.If only I could auppress the
appearance of the message box.Can someody help me ?


Yes, look up "Error Handling" in any good Access book. In your
case, I'd add a statement that handles error 2015, but We would
need to see your code before giving you specifics.
--
Bob Quintal

PA is y I've altered my email address.
Feb 14 '06 #2
"solar" <sp*******@gmail.com> wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:
Is there any possibility to suppress a message box from Access ? I
have a complicated but a good code that calculates the
possibilities in the before update event, and if a condition is
met, then it exits the sub.In short, if this condition is met,
then after the exit sub I get the following message box:
Runtime error 2105 you cant go to the specified recod

END DEBUG

If I click on End, then the code is perfect,everything I cleared
and I can begin anew.If only I could auppress the appearance of
the message box.Can someody help me ?


Well, if all you want to do is suppress the error message, you can
add an error handler in your code that ignores this error message.
It would be something like this:

Begin Sub
On Error GoTo errHandler

[code]

exitRoutine:
Exit Sub

errHandler:
Select Case Err.Number
Case 2105 ' can't go to specified record
' do nothing
Case Else
MsgBox Err.Number & ": " & Err.Description, ,"Error" &
End Select
Resume exitRoutine
End Sub

Now, that answers the question you asked, but I think it's
absolutely the wrong thing to do.

You need to determine which command is causing the error and figure
out how to avoid causing it. When the error message comes up, hit
DEBUG and then tell us which line is highlighted in yellow and one
of us can probably explain why you are encountering that problem and
how to avoid it entirely.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Feb 14 '06 #3

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

Similar topics

9
by: Doug Ly | last post by:
Hi, When I run this query using WinSQL to connect to a DB2 database, it gave me the warning: Error: SQLSTATE 01003: Null values were eliminated from the argument of a column function. ...
1
by: Uttam | last post by:
Hello, How does one suppress the "Object already exists" message when the following statement is executed in ADO? cat.Views.Append "Some_Query", cmd Thanks in advance. Uttam
4
by: Robert | last post by:
Is there some way to suppress the automatic line feed in the detail section of a report in Access? I would like the detail to print out to the right of the existing one. The next line would be...
1
by: Dan | last post by:
In a VS.NET 2003 project automatically generating the XML documentation on build I have some .CS files which lack comments as they are automatically created by tools (such as strongly typed DataSet...
6
by: Ron St-Pierre | last post by:
Is there a way 'within' psql to suppress output? One of our cron scripts calls a sql file which contains various database commands (ALTER TABLEs, UPDATEs, etc) and various user-defined functions....
3
by: Eddy Ilg | last post by:
Hi, I would like to suppress .pyc generation or have the .pyc generation in a speical seperate root (I found something about PYCROOT). Has this been implemented yet? Is there an environment...
1
by: jaishu | last post by:
When i try to insert data into a backend Oracle table (with ODBC) using a form, (i use docmd.runsql "insert....") Access gives me a message like"You are trying to append 1 row to the table are you...
2
by: ZeeHseez | last post by:
Hi, I have written a webbrowser application in VB .net Framework 1.1. I would like to suppress javascript error messages. However, the silent property of the webbrowser control suppresses the...
1
by: lokeshreddy16 | last post by:
'this is my code plz guys help how to save data from vb 2005 and other this that i am able to view the data from acess but i am not able save to acess i dont whether my code for save is correct of...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
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.