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:
Newsgroups: microsoft.public.access
NNTP-Posting-Host: pool-71-240-214-122.alt.east.verizon.net 71.240.214.122
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
textfield:
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10862-re-changing-data-type-field-through.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10862
3. delete field through code
Warm Regards,
Crystal
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!
>
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
