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 / General 1 / February 2006

Tip: Looking for answers? Try searching our database.

Spot the Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DFS - 08 Feb 2006 23:23 GMT
This one had me stymied for a minute.  Clicking the button it was attached
to seemingly did nothing.

=============================
On Error GoTo exitGetData

...code that threw an error...

exitGetData:
DoCmd.Hourglass False
Exit Sub

errGetData:
MsgBox "Error " & Err.Number & ": " & Err.Description
Resume exitGetData

=============================
Anthony England - 08 Feb 2006 23:26 GMT
> This one had me stymied for a minute.  Clicking the button it was attached
> to seemingly did nothing.
[quoted text clipped - 13 lines]
>
> =============================

Well I guess you know by now:  <On Error GoTo exitGetData> should probably
be <On Error GoTo errGetData>
Rick Brandt - 09 Feb 2006 00:20 GMT
> > This one had me stymied for a minute.  Clicking the button it was
> > attached to seemingly did nothing.
[quoted text clipped - 16 lines]
> Well I guess you know by now:  <On Error GoTo exitGetData> should
> probably be <On Error GoTo errGetData>

A good argument for always using the same labels for error handler and exit
point.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Wayne Gillespie - 08 Feb 2006 23:36 GMT
>This one had me stymied for a minute.  Clicking the button it was attached
>to seemingly did nothing.
>
>=============================
>On Error GoTo exitGetData

On Error GoTo errGetData

>...code that threw an error...
>
[quoted text clipped - 7 lines]
>
>=============================

Wayne Gillespie
Gosford NSW Australia
 
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.