473,246 Members | 1,417 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,246 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 4754
"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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
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: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
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...

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.