Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old January 6th, 2004, 11:23 AM
lbrown61 lbrown61 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 2 lbrown61 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Runtime error 53

I have a database setup to open html links that are stored in a table using the VB code below:

The problem is that it only works on some people's computer and not others depending on which version of windows they have. An alternative was setup to try and open on everyone's computer...it worked on a one system but not all systems. Any more alternatives recommended?

-------------------------------------------
Private Sub Command55_Click()

Dim Link As String
Dim Quoted As String

On Error GoTo Alternate1
Link = "netscape " & DLookup("[WebLocation]", "Procedures", "[ProcedureID] = " & [Forms]![SignOff Sheet]![Procedure])
Call Shell(Link, vbNormalFocus)
Exit Sub

Alternate1:
On Error GoTo Alternate2
Link = "start " & DLookup("[WebLocation]", "Procedures", "[ProcedureID] = " & [Forms]![SignOff Sheet]![Procedure])
Call Shell(Link, vbNormalFocus)
Exit Sub

Alternate2:
MsgBox "Cannot Open Netscape. Please open manually and locate the desired spec for review"
End Sub

Reply With Quote
  #2  
Old January 7th, 2004, 09:57 PM
msprenz msprenz is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2003
Location: Knoxville, TN
Posts: 91 msprenz User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 11 h 1 m 26 sec
Reputation Power: 5
I looked up your problem on Google and by all accounts, a referenced dll can't be found. It's my experience that not all computers have the same DLL's even if they have the same software installed. That's why it works on some and not others. Check your references on your's and all the computers you install on.

HTH
Marty
__________________
marty

Reply With Quote
  #3  
Old January 8th, 2004, 02:15 PM
lbrown61 lbrown61 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 2 lbrown61 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I copied all the dll files from the office folder as well as the netscape folder and it still didn't resolve the issue...gave the same error. Are there any other dll files I should be copying over....I thought about the ones in the windows folder, but two of the users that have the issue have different versions of windows.

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > Runtime error 53


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway