Hyperlink To Publisher Doco

Jan 17, 2007

In an access table I have hyperlinks to various documents mainly word docs. I have recently added a Publisher doc and when I H/L to it it will open the application but not the doco.

Obviously Publisher behaves differently than Word in this regard.

I do need the link to open the doc. Is there a way around this please?

Thanks

Peter

View Replies


ADVERTISEMENT

Publisher Could Not Be Verified

Jan 3, 2008

Is there any way to get rid of this message?

I am running an Access 2003 mde file across an intranet and want to remove this error so the users do not have to contend with it.

The users are going to gain access to the file via link on the "home" page.

I know this is an issue with IE but I only have limited authority so any "backdoor" way of getting rid of this would be greatly appriciated.

Thanks

tgi171:confused:

View 1 Replies View Related

Modules & VBA :: Bulk Update Of Hyperlink Text To Display Not Hyperlink

May 29, 2014

i have thousands of data records with hyperlinks that are correct. Each data record shows the actual link (google.com, foxnews.com, espn.com, etc.). However, i want to change all of the records to just say "link" instead of saying espn.com, etc. How can i do this automatically without having to manually right click, edit, and changing the text to display?

View 6 Replies View Related

Linking Photos To Publisher

Jan 29, 2006

Hi,
I've got some id card templates in publisher than i want to merge in access.
i can merge the text details into access but i dont know how to link the photos. should i store the file path of the image in the database or should i embed the file.

would this work with publisher or do i need to use some code?

any help on this would be appriciated as i have no experience with pictures in access.

Thanks

View 1 Replies View Related

Publisher Displaying Name.. Now Just Displays Numbers?

Apr 4, 2005

I have a list of publishers for software titles in a table.

1=Adobe
2=Macromedia

and so on and so forth.
I have a form that pulls the publisher name and displays it, and it used to display correctly with the NAME but now all of a sudden it's displaying the publisher number "1" instead of "Adobe"

what's going on?

View 1 Replies View Related

Modules & VBA :: How To Edit A Publisher Text Box

Jun 25, 2014

I'm currently using the following to edit a publisher document using access VBA.

Code:
For Each pubShape In pubDoc.Pages(1).Shapes
If pubShape.HasTextFrame Then
If pubShape.Name = "Text Box 440" Then pubShape.TextFrame.TextRange.Text = Item1
If pubShape.Name = "Text Box 441" Then pubShape.TextFrame.TextRange.Text = Item2
If pubShape.Name = "Text Box 442" Then pubShape.TextFrame.TextRange.Text = Item3
If pubShape.Name = "Text Box 443" Then pubShape.TextFrame.TextRange.Text = Item4
If pubShape.Name = "Text Box 444" Then pubShape.TextFrame.TextRange.Text = Item5
If pubShape.Name = "Text Box 445" Then pubShape.TextFrame.TextRange.Text = Item6
If pubShape.Name = "Text Box 446" Then pubShape.TextFrame.TextRange.Text = Item7
If pubShape.Name = "Text Box 447" Then pubShape.TextFrame.TextRange.Text = Item8
End If
Next

Obviously there are a lot of shapes/boxes etc in the document and this code is very inefficient and takes a few moments to complete. Is there a way to directly reference a text box and change its value. For word I have been using bookmarks but this doesn't seem to work with publisher.

I'm looking for something like pubshape.Value("text Box 440") = Item1 but cannot find the correct syntax.

View 2 Replies View Related

How To Add A Site Or Publisher To Trusted List

Oct 22, 2011

In 2007 how do you add a site or publisher to your trusted list.

View 1 Replies View Related

General :: MS Publisher And MS Access Mail Merge?

Feb 22, 2013

I am running windows 7 and access 2007 same with pub When I do a mail-merge from pub I can see some Queries but not all. and thoughts?

View 1 Replies View Related

Modules & VBA :: Open Specific Publisher Document If Criteria Is Met

Jul 16, 2014

The code below allows me to open a publisher document that is already merged to the current record. What I need is to allow the user to open the document according to the group they are reviewing. How to accomplish this?

For example:

IF Group = A1 OR B1 THEN OPEN AB_1.pub
IF Group = A2 OR B2 THEN OPEN AB_2.pub
IF Group = A3 OR B3 THEN OPEN AB_3.pub

Dim pubApp As Publisher.Application
Dim pubDoc As Publisher.Document
Set pubApp = New Publisher.Application
Set pubDoc = pubApp.Documents.Add.Application.Open("c:Publishe rAB_1.pub)
pubDoc.ActiveWindow.Visible = True

View 3 Replies View Related

General :: Pinned Database Won't Open - Unknown Publisher

Jun 16, 2015

I work in three different databases, but for one of them (the main company db), if I right clicked the pinned Access program on the taskbar and click the pinned database, it does nothing if someone else has the file open already. If the file isn't open, it'll pop up with an "Unknown publisher" warning (new, never happened before this), but it'll open the file. If someone has the database open, it doesn't flicker or even try, it just does nothing.

I am able to open Access and click on the database in the "Recent files" and have it open that way. I don't know what to troubleshoot, its like it's not seeing the file, but I can go to the properties on the pinned db and it shows the correct file location. I'm the only one having this issue, the other users here can right click the pinned program and open the file like normal.

I've rebooted my computer; unpinned and removed from list; compacted and repaired; nothing is making a difference.

View 3 Replies View Related

"unknown Publisher" Since Installing SP2

Sep 14, 2005

Hi all,

Our company is currently rolling out an SP2 update to all of our PC's and this problem has reared its head on all of the updated PC's so far.

Basically when someone opens a database from a shared drive, they get an error stating that the file was made by an unknown publisher (seems to be a security warning), they click ok and then can open the file fine.

However, once someone is in the database, if anyone else tries to open it on an SP2 machine, nothing happens, the double click the file and it refuses to open. If they open Access, then click file>open and navigate to the file, they can open it. They just can't double click the file.

People using the SP1 machines can open the database with no problems whether someone is already in the file or not.

I'm guessing this is something to dow tih the SP2 security measures.

To try to sort it out, I made myself a self signed digital ceritificate and signed my macros, thinking that once the macros were signed, it would then realise who had published the file.

The only thing this does is brings up a second notice (after the initial publisher message) which gives you the option to trust content from my signature. Once this has been done once, there's no need to keep trusting it but the publisher message still comes up.

I went into the database properties and under the custom tab changed the "publisher" value to my name "Rob Jones". This still didn't work and when the database is opened it still says it's an unknown publisher.

Does anyone know how to either turn off this check or publish a database?? I've tried google / MS but can't find anything on the subject.

Cheers,

Rob.

View 7 Replies View Related

Hyperlink?

Dec 2, 2005

I have created a very simple code to fill automaticly an hyperlink field when a text box is updated on a form:

Me.txtHyperlink = "F:DataCPPCPP PDF" & [TxtPipeSize] & "" & [DrawingFile] & "" & [PartNumber] & ".sht" & [TxtSheetNo] & ".Rev" & [TxtRevNo] & ".pdf"

TxtHyperlink is bound to the hyperlink field, when the code is executed the Hyperlink field is filled with the right address. but I think the code just fill the text to display "parameter" of the hyperlink field and not the actual adddress.
what should I do to get the result of the function to be saved as the Hyperlink address?

View 4 Replies View Related

Hyperlink - Need Help

Jun 28, 2007

Hey guys.
I am VERY new to Access, and trying to learn as fast as I can, but I have no idea how to do this.

I have a database, brand new, it will eventually be holding hundreds of docs. Anyway, we have it as a document naming machine. We insert all the data associated with our document, it stores it and gives us a name for the doc, we then save that doc as a pdf with the name given.

After this, we are going to put all the documents in one central folder on our network drive, as follows:

F:FolderAccessDocuments*.pdf

So, what I need is to create an automative hyperlink creater, that will take our document name once created, put it on the end of the "F:FolderAccessDocuments" and have the hyperlink sitting there ready to go.

One more thing, I need to be able to change my Initial Drive Directory (from "F" to "E") at any point in time, and the switch would have to go through and change every hyperlink.

If anyone can help with any part of this problem, I would appericiate it.

Thanks Guys!

Chris

View 4 Replies View Related

Hyperlink

Mar 22, 2008

Hi

is it possible to have a txt field which will contain an email address and once you input teh address it becomes a hyperlink, so you can just click it and send an email from outlook?

View 2 Replies View Related

Hyperlink

Feb 8, 2006

Hello ,
I have ListBox and I have put in ControlSource:
SELECT HorizontalniDrzaciKabela.Referenca, HorizontalniDrzaciKabela.Opis, HorizontalniDrzaciKabela.Visina, HorizontalniDrzaciKabela.Napomena FROM HorizontalniDrzaciKabela WHERE (((HorizontalniDrzaciKabela.PickFlag)=False));

Can I make column HorizontalniDrzaciKabela.Napomena as hyperlinks for each record when I open ListBox?

In design view I put Napomena as hyperlink (I have added hyperlinks) but it will not work,

thank you in advance

View 5 Replies View Related

Hyperlink Help

Sep 25, 2004

I have a Hyperlink field (can be a text field if necessary) that is intended to open the document listed in the field. I have all of these documents stored on a server and I have set up another field that contains the path to the server directory. So, at the time I click on the document link, I want to concatenate the path with the document name, so I can open the file. This will enable me to not have to type the full path everytime I enter a new document name.

I tried setting up the field as a text field and I can concatenate the path and document name, but then I cannot open the file. I want to be able to pass the concatenated variable to the Windows OS and have it launch the document, regardless of the file type.

Any thoughts?

View 2 Replies View Related

Hyperlink To A Form

Apr 20, 2006

I have been searching the forums and all I could find was how to hyperlink to outside url such as www.google.com and likewise.

I am looking for some kind of code or a direction that will help me hyperlink between records in my form.. best method probably would be using an ID number.

Any ideas?

View 2 Replies View Related

Hyperlink Problems, Please Help....

Apr 25, 2005

Hello. New to this, but am creating a hyperlink in a new form. Using Edit Hyperlink, I direct the program to open a PDF format file. All seems fine, the path is relative to the main file, (although it does display %20 between all separate words, why?), but when I click on it, the warning :
"No prgram is registered to open this file". This file itself is fine, and opens happily when dble clicked. The hyperlink works fine when opening a Doc file. Help as I need this working...

View 3 Replies View Related

Hyperlink On A Form

Sep 6, 2005

I want to have a hyperlink on my form, that when clicked it will open a specified webpage. It will be the same hyperlink every time so doesn't need to be stored in the database.

How do I do this?

View 2 Replies View Related

Creating A Hyperlink

Jun 6, 2006

I have an unbound field txtMyField which I want to fill with a hyperlink after entering data in another field. So I put the Is Hyperlink setting to yes, and some code to populate the field. But I cannot click the link. It is just like text.

How can I amend this so that it is clickable?

Thanks,

Dave

View 2 Replies View Related

Hyperlink Decomposition

Jun 6, 2006

I am about to be tasked to redesign a database which is a total dogs dinner.

Everything is wrong basically

I can handle that but there are also some 11000 hyperlinks

Some are relative and some have full path specified, However all have display text.

Is there a way that I can access the specified path and dump this into a text field.

Thought is to create text field alongside the hyperlink field, dump the text value of the hyperlink and I can then manipulate the hyperlink text as I wish.

Is there a function like

Hyperlink_Field.Path

so in an update query I could update the text field to Hyperlink_Field.Path

Len

View 3 Replies View Related

Hyperlink Not Working

Jul 12, 2006

I have a form with a Command button. i have a text box also which is
bound to my
Button. i have created a standard module and created an onclick event
for my button
which is something like this ( if a user clicks on the button it will
give an option
to user to add a file. The Path of that file will be copied to the
textbox which is associated
to my control or button.) i changed the data type also for my textbox
to
Hyperlink so then
when a user clicks on that path which is in the textbox it will
automatically open that document. Well for
some reason it is not working. any
help or suggestions will be really appreciated.
Thanks

View 3 Replies View Related

Jpeg Hyperlink Bug??

Aug 31, 2006

Morning everyone,
I have a really persistant problem with my database whereby whenever I click on a hyperlink (in the database) to a Jpeg file it will display an error message, "unknown file format" then open the file as normal. The access windows then crash.
Has anyone else encountered this problem? If so doe anyone have a solution or a way round it!?
Any help much appreciated, have a good day :)
Matt

View 6 Replies View Related

Hyperlink Security

Aug 23, 2007

Hello - thanks in advance.
I have buttons that link to external WORD and EXCEL files with the hyperlink property. I also use the Application.FollowHyperlink method to open some files.
I find that files with the .txt extension produce a pop up warning, that hyperlinks are potentially unsafe, do I really want to open the file.
If I click YES then the file opens.
It is not consistant. .xls files open without the warning, but .csv files do produce the warning, even though both open in Excel.
I've set the macro-->security option to LOW.
I want to get rid of those warnings if I can.
I've tried docmd.setwarnings false also.
Any idea?

View 1 Replies View Related

Hyperlink Download

Oct 4, 2007

Hi, I think this is only my second post (found i have made a few, lol) in over a year because I can usually find what im after on this site or I just hack stuff together till it works, lol.Anyway my question:How can I download a hyperlink (its an excel spreadsheet, CSV file to be exact i believe) to a certain place and name?I wish to do this roughly once a day for about 10-14 files. then these will be imported to the database. but first thing will be a fairly automated downloader if possible.any third party software will be fine but id rather have access do it with a code behind a button etc. Thankyou for any/all suggestions.

View 14 Replies View Related

Hyperlink Question

Feb 14, 2007

Sorry if this is a basic stupid question but I am new to access and developing a database for my company while I learn access from a book. I am using hyperlink in a table to allow quick access to job folders on our network, but everytime I click the hyperlink it uses windows explorer to open the folder and I would like to avoid this by having the folder opened in a new window, by its self. Windows Explorer opens the door too many mistakes happening so I want my user to see the folder they need to and that is all. I hope that explains it well enough. I greatly appreciate any help.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved