[AccessD] A2K:Create Fields via code - Solved

Thanks Susan
I struggle - and I mean struggle - with VBA
I have seen code examples in the 2000 Developer for ADOX. It looks quite relative to VB and VBA but I think I will give it a miss.
:-))
(Thanks but no thanks - luddite here)

Have a great day and a safe Easter

Thanks again for your help

Darren

----- Original Message ----- 
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com>
Sent: Thursday, April 08, 2004 11:35 PM
Subject: RE: [AccessD] A2K:Create Fields via code - Solved


> Actually, you can using SQL. So, if you don't have to use ADO/DAO, just use
> SQL. On the other hand, I think you may be able to do it with ADOX? Not
> positive on that one -- I know you can manipulate the field using ADOX, but
> don't remember for sure about creating it.
>
> Susan H.
>
> Hi Dave
> That was it
> It seems you can't create an autonumber from code You first create a  number
> field then change the attributes of that newly created field to  (drum roll)
> ***dbAutoIncrField*** Then that tells access it's an Autonumber
>
> No wonder the help wasn't
> I wouldn't have discovered/figured this by myself in a million years.
> Many many thanks
>
> and many thanks to those who responded
>
> (I was just going through variations on Susan's suggestion when your post
> came in)
>
> This list is brilliant
>
> Darren
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com