How do I disable a hyperlink warning?

[janabanana]

I have read previous answers to how to disable a hyperlink warning.
I have changed the setting in my registry (HKEY_CURRENT_USER...), but this
does not work for a link to a local file.
This problem was also brought up in previous discussions, but no one
answered this particular problem.
Can someone help?

I have a links in Access that take me to one of my Excel files. I keep
getting the hyperlink warning, do you want to continue y/n message. Please
help me disable this warning. It is very annoying.

 

[Klatuu]

Copy the code from this site:

http://www.mvps.org/access/api/api0018.htm

Into s standard module.

The call it like this (copied from a form I am working on at the moment).
strSaveFile is the full path and name of an Excel spreadsheet.

Call fHandleFile(strSaveFile, WIN_NORMAL)

 

[janabanana]

Sorry, I don't know enough about Visual to use this information.
Can I ask why a lot of the answers here are all about writing a program?
What ever happened to clicking?
I know to copy and paste this code, but I wouldn't know what needs changed
to make it "mine".

 

[janabanana]

ok, i copied the code.
at the very end it says: fHandleFile = 1Ret & _ IIf(stRet = "",
vbNullString, ", " & stRet)

am i supposed to change something in this line?

 

[Klatuu]

The reason you get answers that involve coding is you can only go so far with
clicking (even crickets can manage it <g>), and a bit further with Macros,
but you are asking for something that is a bit more advanced than that.

The code you can copy from the site I posted needs no change at all. In
fact, if you tried, you would probably break it. All you need to do is copy
it ito a standard module by itself.

Since fHandleFile is a function, it can be called from a Macro, so you don't
need to write any VBA. To call a function from a Macro, you use the RunCode
action. In the parenthises, you put the name of your path and file in qoutes:

FHandleFile("C:\SomeFolder\MySheet.xls")

As an example. Use your actual file name.

 

[janabanana]

before I start - yes, i am clueless.
But, i am learning...

where do i find the RunCode action?
i am in the macro and clicked Run, and then chose Run Sub/User Form (cause
that is the closest thing i can find), but when i type in the name of the
macro, which i called Disable Warning Message, it doesn't recognize it.
i even saved, and closed and re-opend Access. Same thing.

 

[Klatuu]

The name of the action is RunCode
But, it doesn't just turn off any warnings. What you are doing is sneaking
around the security that causes the message. You use the fHandleFile
function to open your spreadsheet.

 

[Klatuu]

No, do not touch the code.

 

[janabanana]

what do you mean "use the fHandleFile function to open my spreadsheet"?
(are you shaking your head right now?)

i am totally not following.
can i have step-by-step? With me, you can't assume I know what basic
manuevering is.

I have copied the code to a new macro. Named it. Saved it.
Closed Access.

Now...?
(By the way, I have to sign off until Monday morning. But rest assured, I
will return to this post then..)
Have a great weekend!!!

 

[Klatuu]

Okay
Step by Step

From the database window
Select Modules
Click on New
The VB Editor will open
Paste the code from the web site into the editor
Click Save
Give the module a name - I suggest modShellExecute
The VBE should close
select Macros
Click New
in the Action box enter RunCode
in the Function Name box (near the bottom) enter
=fHandleFile("C:\SomeFolder\MyWorkBook.xls")

Substitute the name of the excel file you want to open where I have
C:\SomeFolder\MyWorkBook.xls
Click Save
Give it name

Open your purse
Get out you checkbook
Write a large check
Send it to me

Well, you don't really have to do the last 4 steps. It should work with
them

Have a good weekend. See ya Monday.

 

[janabanana]

I kept getting syntax errors in my path. Who knows, maybe I just wasn't
holding my mouth correctly.
Anyway, I also got an answer to this question saying that I could change the
registry. I had already tried that route with no results, but this one and
one small difference. The post before had said to change from Hexadecimal to
Decimal. The latest post did not say to change from Hexa. This time it worked.

I want to thank you for all of the time you spent on my question. I then
would like to appologize for not being able to type a file path correctly (I
am sure that is what is wrong). The path is actually a shared drive and I
tried typing it a couple of ways, K:\..., then I tried file:///\\, then I
tried clms1\data\... - you get the picture.

Thanks again!!!!