Office Systems Developer

Joao Livio (Portugal)

Browse by Tags

All Tags » English Related » Access 2007 (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. -----------------------------------------------------...
New Access 2007 Courses provided by Microsoft Training
Datasheets I: Create a table by entering data New! Length: 40 min Rating: (779 votes) Datasheets II: Sum, sort, filter, and find your data New! Length: 30 min Rating: (307 votes) Datasheets III: Make data easier to read by formatting columns and rows...