Office Systems Developer

Joao Livio (Portugal)

Browse by Tags

All Tags » English Related » C# (RSS)
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...
VSTO (Access) a Simple Database initialization
/// <summary> /// /// </summary> /// <param name="hideNavigationPane"></param> /// <param name="myUIName"></param> /// <param name="myUIXML"></param> /// <returns>True...
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...
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...
VSTO (Access) How to Backup the Current project?
Access.Application oAccess = ((Access.Application)                 (Marshal.GetActiveObject("Access.Application"))); // ---------------------------------------------...
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...
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;...
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# 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();