Search results

I also tried this: Dim tmpStr As String Dim sMyFile As String sMyFile = "E:\Data\Sample Submittal - COCs\" & Me.OrderID & "_COC.pdf" tmpStr = "file:///" & sMyFile Me.Viewer.Navigate (tmpStr) this stalls on .navigate Thanks.

I should have given more info. Both are attached to onclick on a form button. FollowHyperlink works great. The web browser control on the same form is named "viewer". I want to use the browser in the form so a full screen copy of acrobat doesnt open to view the file quickly. I just need to...

Hi, Im terrible at VB. I cant see why this works: Application.FollowHyperlink "\\Server\Data\Sample Submittal - COCs\" & Me.OrderID & "_COC.pdf" And this does not: Me.Viewer.Navigate ("\\Server\Data\Sample Submittal - COCs\" & Me.OrderID & "_COC.pdf") .navigate will not recognize OrderID...

Hi, I felt that I had to contribute. This had me so frustrated I could not do any design work at all. The default printer change did not do it for me. Opening a small random (linked BE) table and minimizing did the trick! Whew! Such a simple solution once you know. Thanks! Ryan

This code runs, but the "validated" value does not change to true. What am I doing wrong? I know this is a novice question. Help is appreciated.:) Public Function BatchValidate() Dim qdfBatchValidate As QueryDef, dbs As Database, cntBatchID, cntValidated, cntValidateTag, rsBatchValidate As...

Thanks for the reply. I'll give it a try. :)

I am fairly new to coding. I have the following snippet of code adapted from another module. I need to edit each hyperlink field in the underlying query with a new path. Here's what I have so far, I just don't know how to make it loop through the entire recordset. Dim dbCurrent As...

I have a table with over 2000 hyperlinks contained in a field. We recently added a new server and moved the base location of all the files referenced in the hyperlinks. Is there a way to globally edit all the links to the new location? All comments appreciated. Thanks, Ryan Freeman