[AccessD] adding field to table via code

Hi Oleg, you made it :-)

Yep to your question. See the CreateField method in Help. Post again if
you want help.

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com 
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of 
> Oleg_123 at xuppa.com
> Sent: 05 February 2003 15:34
> To: accessd at databaseadvisors.com
> Subject: [AccessD] adding field to table via code
> 
> 
> Hey, I have a query one of it's components is a table that I 
> convert daily from an Excel file (which is being sent 
> daily)In order for the query to operate that table must have 
> an autonumber (since they are always in the same order)So 
> every day I manually add that field with an autonumber, which 
> takes less then 2 min. However I am going for a couple of 
> weeks, and I don't want to confuse the person who's going to 
> be doing to be running reports while i am gone; So my questin 
> is, can I write a vba procedure on button click that would 
> add that field
> 
> oleg?
> 
> 
> -----------------------------------------
> Send a Xuppa Valentine to Your Sweetheart today! 
http://www.xuppa.com/greet/


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com