[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/