[AccessD] adding field to table via code

You need to be in the VB editor when you access help.  Otherwise, you get the help for the UI, not the help for code.

Charlotte Foust

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
Sent: 5. veljača 2003 11: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