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

Share This Page