[AccessD] adding field to table via code

Charlotte Foust cfoust at infostatsystems.com
Wed Feb 5 13:49:00 CST 2003


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



More information about the AccessD mailing list