Andy Lacey
andy at minstersystems.co.uk
Wed Feb 5 13:08:00 CST 2003
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