Browse by Tags
All Tags »
Access 2007 (
RSS)
Nesta série de vamos compreender como criar, gerir e implementar um Biblioteca (Class Library) para o Microsoft Access. Vamos utilizar o Visual Studio 2008, C#, Visual Basic e o Microsoft Access 2007. Estes exemplos provêm da Class Library...
static ADOX.DataTypeEnum GetAccessFormats(DataColumn col) { switch (col.DataType.Name) { case "Boolean" : return ADOX.DataTypeEnum.adBoolean; case "Byte" : return ADOX.DataTypeEnum.adUnsignedTinyInt; case "Char" : return...
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...
/// <summary> /// /// </summary> /// <param name="hideNavigationPane"></param> /// <param name="myUIName"></param> /// <param name="myUIXML"></param> /// <returns>True...
public bool ConvertReportToXPS( string myReport, string XPSFileName) { Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject( "Access.Application" ))); try { oAccess.DoCmd.OutputTo(Access.AcOutputObjectType.acOutputReport...
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...
Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject("Access.Application"))); // ---------------------------------------------...
public bool ExecuteSqlFromFile(String MyConnectionString, String MyTextFilePath) { using (OleDbConnection sqlConnection = new OleDbConnection(MyConnectionString)) { OleDbCommand cmd = new OleDbCommand(); try { using (StreamReader fh = new StreamReader...
// ---------------------------------------------------------------------------------------- // Author: Joao Tito Livio // Company: MACL // Assembly version: 0.0.* // Date: 21-04-2009 // Time: 23:55 // Project Item Name: M3Data.cs // Project Item...
/// <summary> /// /// </summary> /// <param name="MyPath"></param> /// <returns>True/False</returns> public bool GenerateLogDatabase( string myPath) { CatalogClass cat = new CatalogClass(); string strSQL;...
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. -----------------------------------------------------...
Parece que têm havido alguns problemas com a actualização Security Update for Microsoft Office Excel 2007 ( KB958437 ). O resutado é um erro quando se tenta colar dados directamente do Excel 2007 para o Microsoft Access 2007 Os dados na Área de Transferência...
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...
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...
Funções Office 2007 VBA Por razões de motor de busca de páginas e pela importância desta informação em Português resolvi incluir esta secção no site para ser mais fácil o acesso à sua monitorização. Porque o autor deste Artigo não sou eu a página vai...