Dave Sharpe
DaveSharpe2 at cox.net
Wed Apr 7 21:47:40 CDT 2004
Darren I think that this should help http://www.mvps.org/access/tables/tbl0016.htm Dave ----- Original Message ----- From: "Darren DICK" <d.dick at uws.edu.au> To: "AccessD List" <AccessD at databaseadvisors.com> Sent: Wednesday, April 07, 2004 9:41 PM Subject: [AccessD] A2K:Create Fields via code > Hello all > I managed to find in the help code for creating fields in tables. Excellent > I can see examples and general info on creating just about every field known to mankind....except Autonumber. > > I am importing a DBF file with no Autonumber > > The field I was going to use a PK in that file is TEXT. > > So..I'm open to suggestions- convert the text field to a number field or try and add an Auutonumber field and use that > > Any suggestions welcome > > many thanks > > Darren > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com