Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Changing The Data Type Of A Field Through Code -- FollowHyperlink

Discussion in 'Information Technology' started by strive4peace, Jul 28, 2006.

  1. strive4peace

    Expand Collapse

    References: <1149541926.202767.295130@i39g2000cwa.googlegroups.com>
    In-Reply-To: <1149541926.202767.295130@i39g2000cwa.googlegroups.com>
    Content-Type: text/plain; charset=ISO-8859-1; format=flowed
    Content-Transfer-Encoding: 7bit
    Message-ID: <u7IzvvPiGHA.1260@TK2MSFTNGP05.phx.gbl>
    Newsgroups: microsoft.public.access
    NNTP-Posting-Host: pool-71-240-214-122.alt.east.verizon.net
    Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
    Lines: 1
    Xref: TK2MSFTNGP01.phx.gbl microsoft.public.access:234204

    Hi Janelle,

    Why change to hyperlink data type? You can do this with a

    Application.FollowHyperlink "string"

    to answer your question (I saw it awhile back too), I know
    of no way to CHANGE the data type through code (don't use
    ALTER), but here is one solution:

    1. add field though code
    2. use UPDATE query to move data
    3. delete field through code

    Warm Regards,
    Microsoft Access MVP 2006

    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com


    Janelle.Dunlap@ge.com wrote:
    > I have imported a table into Access using code, and I need to be able
    > to change the data type of one of the fields from text to hyperlink
    > using vb code (it cannot be done manually). I have found a few other
    > helpful postings that use the ALTER TABLE statement to do this but
    > still have yet to get anything working in my database. Any help would
    > be much appreciated!
  2. Loading...

    Similar Threads Forum Date
    S Asia Thinking About The Big Move: The Sikh Way Of Life Changing In Khyber-Pakhtunkhwa Breaking News Mar 22, 2014
    Opinion Haanji's Quick Takes On A Changing World (September 23, 2013) Breaking News Sep 22, 2013
    Changing My Last Name To Kaur Questions and Answers May 15, 2013
    Life-changing Inspirational Stories Mar 31, 2013
    USA Sikhism And The Changing Electoral Demographic Breaking News Mar 8, 2013

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page