Archive

Archive Collection: Field Descriptions

I'm on a short vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy this curated collection of articles. Today's topic: Field Descriptions.

Mike Wolfe

• 3 min read
Archive Collection: Field Descriptions

I've been writing a daily article here since September 1, 2020; that's over 1,000 articles.  I haven't missed a day yet, and that includes Christmas and Easter.  Well, I'm taking my first another (short) family vacation.

I'm writing this in the present tense, but I'm writing it for future publication with links to past articles.  Let's hope the time-space continuum holds up.

In any case, as the slacker Firstie says to the Stony Lonesome Gate guard twenty minutes before Taps, let me get to the Point.  I've got a daily publishing streak to keep up.  But I don't want to be writing and publishing articles on vacation.  And I still want to provide you with something of value to read each day.  So I settled on creating a series of curated article lists that I think you'll find beneficial.

I'm hoping at least some of these articles are ones you haven't read before.  And if you're so obsessed with me that you have read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.  

Enjoy!

Field Descriptions

Field Comments on Linked Access Tables in MS Access
In part 1 of this series on field comments, we discuss maintaining column descriptions on tables linked to MS Access back-end files.
No Longer SetMike Wolfe
Setting SQL Server Field Descriptions
There are two basic ways to set field descriptions in SQL Server: via SSMS and T-SQL. Let’s explore both.
No Longer SetMike Wolfe
Use VBA to Generate T-SQL to UPSERT a Column Description
Let’s combine the stored procedures to Update and Insert SQL Server field comments into a single, all-encompassing solution.
No Longer SetMike Wolfe
Easy Access to Field Descriptions
The ExtractFieldComments() function returns a dictionary of field names and their descriptions from a TableDef object.
No Longer SetMike Wolfe
Pushing Field Comments to SQL Server
A VBA routine that takes field comments from a front-end linked table and pushes them to the corresponding back-end table in SQL Server.
No Longer SetMike Wolfe

Never miss an article.

Sign up to receive a Sunday morning email with links and recaps of the seven articles published that week.
(I'll never sell your email. Unsubscribe any time.)


All original code samples by Mike Wolfe are licensed under CC BY 4.0