Cast Memo As Text

Posted on By David Kittell 
cstr(<mycolumn>)
Originally Posted on March 19, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Access Code

Related Posts

List Views In Database

Posted on

SELECT name FROM sys.views ORDER BY name SET NOCOUNT ON DECLARE @ViewName AS nVarChar(128) , @Query AS nVarChar(500) /* Declare Cursor */ DECLARE Cur_Views CURSOR FOR SELECT name FROM [sys].[all_views] x WHERE x.schema_id = 1 — Loop through the views. OPEN Cur_Views — Fetch the first view FETCH NEXT FROM…

Read More

Import Excel Spreadsheet into DataGrid

Posted on

Originally found at http://blueraiden.exofire.net/blog/import-excel-spreadsheet-data-to-datagridview-using-vb-net For the code to work you need to first add a DataGridView and a Button in design view and have a valid file path for the Excel file. Imports System.Data.SqlClient Public Class Form1 Dim MyConnection As System.Data.OleDb.OleDbConnection Dim ExcelDataSet As System.Data.DataSet Dim ExcelAdapter As System.Data.OleDb.OleDbDataAdapter Private…

Read More

PowerShell – IIS Remove Site

Posted on

clear # Check For WebAministration – Start try { $ImportSucceeded = import-module WebAdministration -ErrorAction Stop } catch { Write-Output "Unable to Import" try { $AddSucceeded = add-pssnapin WebAdministration -ErrorAction Stop } catch { Write-Output "Unable to Add PS Snapin" try { $AddFeatureSucceeded = Add-WindowsFeature WindowsPowerShellWebAccess -ErrorAction Stop } catch {…

Read More