Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

VSTO (Access) – Convert a Field to Upper, Lower, Proper

public string ConvertFieldToUpper( string MyTable, string MyField) { Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject( "Access.Application" ))); try { string strSQL; strSQL = String.Format( "UPDATE {0} SET {1} = UCase([{1}])" , MyTable, MyField); oAccess...

Posted to Office Systems Developer by Joao Livio on Wed, Apr 22 2009
Filed under: Filed under: Access 2007, C#, VSTO, English Related
VSTO (Access) a Simple Database initialization

/// <summary> /// /// </summary> /// <param name="hideNavigationPane"></param> /// <param name="myUIName"></param> /// <param name="myUIXML"></param> /// <returns>True/False</returns> public bool InitializeDatabase...

Posted to Office Systems Developer by Joao Livio on Wed, Apr 22 2009
Filed under: Filed under: Access 2007, C#, VSTO, English Related
VSTO (Access) – Convert a Report to XPS

public bool ConvertReportToXPS( string myReport, string XPSFileName) { Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject( "Access.Application" ))); try { oAccess.DoCmd.OutputTo(Access.AcOutputObjectType.acOutputReport, myReport, Access.Constants.acFormatXPS, XPSFileName...

Posted to Office Systems Developer by Joao Livio on Wed, Apr 22 2009
Filed under: Filed under: Access 2007, C#, VSTO, English Related
VSTO (Access) Detect if tables are similar

public bool TablesAreEqual( string MyTableSource, string MyTableToCompare, string MyIndexField) { try { OleDbConnection cnn; using (DataSet ds = new DataSet()) { OleDbDataAdapter da; string cs = oAccess.CurrentProject.Connection.ToString(); string strSQL = String.Format( "SELECT * FROM {0} LEFT...

Posted to Office Systems Developer by Joao Livio on Wed, Apr 22 2009
Filed under: Filed under: Access 2007, C#, VSTO, English Related
VSTO (Access) How to Backup the Current project?

Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject("Access.Application"))); // ---------------------------------------------------------------------------------------- // Author...

Posted to Office Systems Developer by Joao Livio on Wed, Apr 22 2009
Filed under: Filed under: Microsoft Access, Access 2007, C#, VSTO, English Related
VSTO (Access) – How to return a RecordSet from a OleDb Provider?

// ---------------------------------------------------------------------------------------- // Author: Joao Tito Livio // Company: MACL // Assembly version: 0.0.* // Date: 21-04-2009 // Time: 23:55 // Project Item Name: M3Data.cs // Project Item Filename: M3Data.cs // Project Item Kind: Code ...

Posted to Office Systems Developer by Joao Livio on Wed, Apr 22 2009
Filed under: Filed under: Microsoft Access, Office System 2007, Access 2007, C#, English Related
VSTO (Access) how to create a Table with fields in a Access Database (ADOX and JET SQL)

/// <summary> /// /// </summary> /// <param name="MyPath"></param> /// <returns>True/False</returns> public bool GenerateLogDatabase( string myPath) { CatalogClass cat = new CatalogClass(); string strSQL; string cs; try { cs = "Provider=Microsoft.Jet...

Posted to Office Systems Developer by Joao Livio on Wed, Apr 22 2009
Filed under: Filed under: Access 2007, C#, VSTO, English Related
My recent project with Libraries to use in Access 2007

NOW MACL IS FREE AND IS IN CODEPLEX My recent project with Libraries to use in Access 2007 Project Description Improved Microsoft Access Class Libraries *DLL's* with utilities and Data Access. --------------------------------------------------------------------------------------------- C#, Framework...

Posted to Office Systems Developer by Joao Livio on Tue, Apr 14 2009
Filed under: Filed under: Office 2007, Access 2007, Office 2007 Developer, C#, Office, English Related
C# How to open a form only once in a MDI Envoirement

YourFormName xForm; foreach (Form childForm in this.MdiChildren) { if (childForm.GetType() == typeof(YourFormName)) { childForm.Focus(); return; } } xForm = new YourFormName(); xForm.MdiParent = this; xForm.Show();

Posted to Office Systems Developer by Joao Livio on Sat, Nov 17 2007
Filed under: Filed under: C#, English Related

Page 1 of 1 (9 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

Recent Posts

Tags

Browse Blog Posts by Tags