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?
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?
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.
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"
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.
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
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.
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.
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?
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.
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?
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,
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.
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.
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...
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.
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.
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
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
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
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?
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.
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.