Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-25-2013, 12:19 PM   #1
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Error with FollowHyperlink

Okay, so I'm probably having a brain cramp. I have an application (2007 accde) that has been working for some time, this line specifically:

Application.FollowHyperlink Me.txtAttachment

On one users PC (XP Pro SP3), this has worked from day one. His PC got infected to the point that I had to wipe/rebuild it, and suddenly this code throws a warning and then an error. The warning I could live with (it's the MS Office "some files can contain viruses..." warning). However, after clicking on OK for the warning, I get an error that says "Can't print form image to this type of printer". Doesn't make sense, as this user has the same default printer he had before, plus I tried with a different default printer.

Any thoughts on why this is happening? Oh, and if I navigate to the file location on his PC I can open any of the files, so I don't think it's a permissions issue. The code works fine on my PC and a VM with a different OS, and it still works fine for other users.

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 07-25-2013, 01:34 PM   #2
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Error with FollowHyperlink

Paul,

Could Sandbox mode be enabled for him? I've found that some people accidentally click on the wrong thing when that initial dialog comes up when a new install of XP SP3 and Access. It's just a remote shot but I thought I'd mention it.

It sounds strange to be getting an error about printing a form image when it appears you are just opening a document.
boblarson is offline   Reply With Quote
Old 07-25-2013, 02:03 PM   #3
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Error with FollowHyperlink

Thanks Bob, I don't think so, unless I'm missing something. He has the runtime version of 2007, which I installed the same way I always do (there aren't really any options). I've run all the Windows and Office updates. I made the registry change that sets the trusted location, so no security warning comes up when the app starts. All other code in that app plus code in numerous other apps seems to be running fine.

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 07-25-2013, 02:04 PM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Error with FollowHyperlink

PS, here's the error that comes up.
Attached Images
File Type: jpg Error.jpg (32.5 KB, 129 views)
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 07-25-2013, 02:51 PM   #5
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Error with FollowHyperlink

Access Runtime errors are sometimes hard to figure out. It may have nothing to do with what it seems like it is. I once had one where I had to put code in to log each step just to see what was happening because I couldn't obviously debug in the traditional sense. I wrote a comment out to a text file for each step just before it occurred and it led me to that there was a required dll that wasn't installed on the machine. I don't know that would be your problem but just thought I'd mention it.
boblarson is offline   Reply With Quote
Old 07-25-2013, 03:37 PM   #6
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,306
Thanks: 13
Thanked 4,113 Times in 4,045 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Error with FollowHyperlink

I appreciate your thoughts Bob. Finally got it sorted, and sadly it was the user who did it. He said "gee, I just remembered that so-and-so had me load some software and it changed what program these files (.tif) opened in".

We changed the file association and that got rid of the error. I didn't consider that, since I could double-click on the file in Windows Explorer and it would open right up. FollowHyperlink uses the default program, so not sure why it would error when opened that way.

Any thoughts on the "potential virus" warning that pops up?
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 07-26-2013, 02:23 AM   #7
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,800
Thanks: 55
Thanked 1,028 Times in 994 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Error with FollowHyperlink

the virus warning may be connected with the path specification.

i have seen similar warnings, but cannot recall exactly what caused/solved tham

maybe files opened directly in C folder. or maybe paths with the wrong slashes in them. ie / instead of \ . vba still seems to understand what you want, but gives you a warning.

i am sure you know what you are looking for as much as anyone here.


__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with FollowHyperlink utzja1 Modules & VBA 8 04-15-2013 07:04 AM
Application.Followhyperlink Jacob Mathai General 3 03-01-2010 12:48 PM
Followhyperlink excel supmktg Modules & VBA 2 11-14-2006 01:23 PM
Followhyperlink problem tim huybreckx Modules & VBA 0 04-22-2004 11:41 PM
FollowHyperlink - runtime error # 429 ghudson General 0 11-21-2002 10:13 AM




All times are GMT -8. The time now is 01:14 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World