[AccessD] Changing Data Types - URGENT

Ryan, using VBA you can do it throght CDate()


> Charlotte.
>
> Access 2K. - and I would like to change a field in a table from
> (whatever  it is...text,numeric, etc.) to datetime.
> This change will take place after the table has been created.
>
> TIA
> Ryan
>
>
>
>
>
> "Charlotte Foust" <cfoust at infostatsystems.com>
> Sent by: accessd-bounces at databaseadvisors.com
> 05/03/2004 16:37
> Please respond to Access Developers discussion and problem solving
>
>
>         To:     "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
>         cc:
>         Subject:        RE: [AccessD] Changing Data Types - URGENT
>
>
> Are you asking about changing the table structure?  If so, you can't do
> that with a query, although you can with VBA ... And some effort.  If
> you provide more specifics about the Access version and what you want to
> do, someone should be able to help you.
>
> Charlotte Foust
>
> -----Original Message-----
> From: rsmethurst at uk.ey.com [mailto:rsmethurst at uk.ey.com]
> Sent: Friday, March 05, 2004 8:22 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Changing Data Types - URGENT
>
>
> Hi All,
>
> Is there a way I can programmatically change a datatype in a field,
> using
> either VBA or SQL?
>
> TIA
> Ryan
>
>
>
> This e-mail and any attachment are confidential and contain proprietary
> information, some or all of which may be legally privileged.  It is
> intended solely for the use of the individual or entity to which it is
> addressed.  If you are not the intended recipient, please notify the
> author immediately by telephone or by replying to this e-mail, and then
> delete all copies of the e-mail on your system.  If you are not the
> intended recipient, you must not use, disclose, distribute, copy, print
> or rely on this e-mail.
>
> Whilst we have taken reasonable precautions to ensure that this e-mail
> and any attachment has been checked for viruses, we cannot guarantee
> that they are virus free and we cannot accept liability for any damage
> sustained as a result of software viruses.  We would advise that you
> carry out your own virus checks, especially before opening an
> attachment.
>
> The UK firm Ernst & Young LLP is a limited liability partnership
> registered in England and Wales with registered number OC300001 and is a
> member practice of Ernst & Young Global.  A list of members? names is
> available for inspection at 1 More London Place, London, SE1 2AF, the
> firm?s principal place of business and its registered office.
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>
> This e-mail and any attachment are confidential and contain proprietary
> information, some or all of which may be legally privileged.  It is
> intended solely for the use of the individual or entity to which it is
> addressed.  If you are not the intended recipient, please notify the
> author immediately by telephone or by replying to this e-mail, and then
> delete all copies of the e-mail on your system.  If you are not the
> intended recipient, you must not use, disclose, distribute, copy, print
> or rely on this e-mail.
>
> Whilst we have taken reasonable precautions to ensure that this e-mail
> and any attachment has been checked for viruses, we cannot guarantee
> that they are virus free and we cannot accept liability for any damage
> sustained as a result of software viruses.  We would advise that you
> carry out your own virus checks, especially before opening an
> attachment.
>
> The UK firm Ernst & Young LLP is a limited liability partnership
> registered in England and Wales with registered number OC300001 and is a
> member practice of Ernst & Young Global.  A list of members? names is
> available for inspection at 1 More London Place, London, SE1 2AF, the
> firm?s principal place of business and its registered office. --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail