Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / September 2005

Tip: Looking for answers? Try searching our database.

Hide Code on Error?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peanut1 - 14 Sep 2005 20:28 GMT
hello, how do i prevent users from viewing code on error? there used to be
setting in previous versions in Startup, but thats gone in 03.
help !
Wayne Morgan - 14 Sep 2005 23:14 GMT
I believe the setting you're looking for is in the Options of the Code
Editor, not the main Access window. In to code editor, go to
Tools|Options|General tab.

However, the best way to keep the users from seeing the code is to put an
error handler in all of your procedures.

On Error GoTo LabelName
or
On Error Resume Next

For more information on using On Error, see this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/v
astmonerror.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/v
astmresume.asp


Signature

Wayne Morgan
MS Access MVP

> hello, how do i prevent users from viewing code on error? there used to be
> setting in previous versions in Startup, but thats gone in 03.
> help !
oozyscab - 14 Sep 2005 23:37 GMT
It's still in the startup options.  It's the 'Use Access Special Keys' check
box in the bottom left of the box.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.