Re: Can I open a .pdf file in Access using a table column with lin

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sorry, I don't know about Excel hyperlinks.

--
HTH
Van T. Dinh
MVP (Access)



"B.C.Lioness" <BCLioness@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:653060AD-AE85-49E5-BA1F-2CC288413FD7@xxxxxxxxxxxxxxxx
> Thank you very much, that worked.
> I am the only one allowed to manipulate the data, others just look and
don't
> have editing privaleges. I did not start this database (the person who
did
> does not work here anymore) and there are forms in it for data editting,
but
> they don't work right. For instance, I want to add that we received 100
new
> parts, but what the form for editting parts does is add a new line with
all
> the same information except for the amount in inventory instead of just
> lettimg me adjust the inventory amount. I don't know how to work with
forms
> and have found that I can work around them alright, so I haven't tried to
> make the forms do what I want. Maybe someday I'll get that ambitious.
>
> Thanks very much for your help.
>
> Oh hey! I am importing a query from this database into an Excel file, and
> have found that the hyperlink column converts to plain text in the excel
> file, would you know a way to keep the hyperlink so that the excel file
can
> access the same hyperlinks?
>
> Any help would be greatly appreciated.
>
> Thanks a bunch.
>
> Lori.
>


.

Relevant Pages

  • Hyperlinks Export to Excel Errors
    ... In Access 2003 I want to export query results to Excel. ... The data includes hyperlinks that are on company shared ... which creates an Excel file in Outlook open message. ...
    (microsoft.public.access.externaldata)
  • Re: How do I force a browser based excel hyperlink to open a new w
    ... can modify the other hyperlinks as explained below, ... MS MVP - Excel ... >> Hi Sean, ... >>> those hyperlinks causes the excel file to try to close. ...
    (microsoft.public.excel.programming)
  • Re: Hyperlinks Export to Excel Errors
    ... Usually this question is the other way round: how to import Excel ... use the HYPERLINKworksheet function to create a working hyperlink ... >The data includes hyperlinks that are on company shared ... >which creates an Excel file in Outlook open message. ...
    (microsoft.public.access.externaldata)
  • Excel Needs an Option to Toggle Activation/Deactivation of Hyperl.
    ... to enter Excel cells rapidly even if there's a hyperlink in that cell. ... ability to turn hyperlinks to active/inactive. ... removing me from my current Excel work window. ...
    (microsoft.public.excel.setup)
  • Re: Hyperlink Error in Excel when using #
    ... I wanted to create an automated directory in excel with hyperlinks linking ... when the folder name begins with"#" and it's located in the root ...
    (microsoft.public.excel.misc)