Office Systems Developer

Joao Livio (Portugal)

Browse by Tags

All Tags » Access 2007 » Microsoft Access (RSS)
VSTO (Access) How to Backup the Current project?
Access.Application oAccess = ((Access.Application)                 (Marshal.GetActiveObject("Access.Application"))); // ---------------------------------------------...
Posted: Wed, Apr 22 2009 22:40 by Joao Livio | with no comments
Filed under: , , , ,
VSTO (Access) How to execute a SQL Statement from a File?
public bool ExecuteSqlFromFile(String MyConnectionString, String MyTextFilePath) { using (OleDbConnection sqlConnection = new OleDbConnection(MyConnectionString)) { OleDbCommand cmd = new OleDbCommand(); try { using (StreamReader fh = new StreamReader...
Posted: Wed, Apr 22 2009 22:37 by Joao Livio | with no comments
Filed under: , , ,
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...
Posted: Wed, Apr 22 2009 22:33 by Joao Livio | with no comments
Filed under: , , , ,
Sample Function to Translate a Access Database IDE (ADODB)
Just an idea to support multilanguage IDE in a Access Database, what i do? i create a Table with the FORM NAME, CONTROL NAME and LANGUAGE, i am selectin the Language and comparing the Control Name with the Table Description, if you want you can ByVal...
Posted: Wed, Oct 29 2008 20:11 by Joao Livio | with 1 comment(s)
Filed under: , ,