![]() Set zprp = zdoc.CreateProperty("Hyperlink base", dbText, zstrPathApp) ' property not found in the collection so create it and add 'If we didn't error out on 3270 then remove the Hyperlink Base from the properties collection ![]() Set zprp = zdoc.Properties("Hyperlink base") Set zdoc = zdb.Containers("Databases").Documents("SummaryInfo") 'once I found that. this almost wrote itself! 'summary. and the value was, "SummaryInfo" 'Then reading thru my references, there was an example to set the title in 'Now, here's the stumbling block. I was using just "Summary" as it shows ![]() 'Set the pointers to the current database and properties collection 'set the base hyperlink file (could use the current database root) Public Function fnc_SetorClearHyperlinkBase() This is a modification of the code I use to set custom properties for my databases. It will return a "1" and popup a message block if any unexpected errors occured. Run the first time to set the value to the "File://" Here's a function that will toggle the value from VBA. because MS has really torqued my jaws on this. someone with a better understanding than I will have to handle the outlook attachments Now, because this is the home PC I haven't tried this on network files, nor have I tried this on outlook attachments. When that property is not set then the path returned on a drag and drop appears to randomly be either relative or absolute however, when I set the value to the "File://" then the path seems to always return the absolute path. in V2010 look to the right, click on the small line of text that says. Which led me to try that in the base hyperlink path property for the database. That led me to think about the "File://" pre-pend when I'm trying to open a HTML from the local drive. Reading thru my texts there is a base hyperlink path property that showed up in V2003 for sharepoint and other web uses. OK this took me forever to figure out and haveing the distraction of the kids didn't help (well, actually it did to some degree in that they kept me from getting too deep in any one direction). ![]() Sometimes MS really just gets under my skin with how they do things! Also, it doesn't include the starting part of the file path so I can't use Left(), Right(), or Mid() functions to parse it down to a usable file path. and then the file path inside pound signs and then duplicates that again. When tried, the hyperlink that gets added to the text box when the file is dropped onto it is not a regular file path that FileCopy can use. My idea was then to use that hyperlink to be able to do a FileCopy to the server and then change the value in the control to be the location on the server instead of the user's PC. In reading stuff online, I found out that the Hyperlink data type makes it so that you can drag a file onto a textbox and it will automatically create a hyperlink to that file. I want users to be able to drag and drop a file from their desktop (or anywhere else on their computer) onto a control of some kind and have the file get placed on the server with a hyperlink in the database to the file on the server. I'm trying to create an easy way to get references to files into my database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |