[AccessD] adding field to table via code

Don't know why Help's not helping. Try going via the TableDef object,
cos it's one of its methods. BTW what version of Access?

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 19:33
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] adding field to table via code
> 
> 
> yeah, I made it :))
> If i type it in one word in help (like u did) i get no 
> results, if i tpe 2 words it tels me how to add a field in 
> design view or datasheet view (which I had basically known 
> for the last couple of years :))
> 
> ----------------------------------------------
> 
> > 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
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> 
> 
> 
> -----------------------------------------
> 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