Office Systems Developer

Joao Livio (Portugal)

Browse by Tags

All Tags » Microsoft Access » English Related (RSS)
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...
Reparar Ficheiros Office - Repair Office Files
MDB, DBF, XLS, XLW and DOC Files Recover ENGLISH I am testing to recover files in format: Access (MBD) - Until now 0 Offers Dbase e FoxPro (DBF) - Until now 0 Offers Excel (XLS e XLW) - Until now 0 Offers Word (DOC)- Until now 0 Offers I'am going...
MDB Deleted Tables Recover
MDBTableRecover (Version 1.0.0.2) Feedback is welcome for erros and new features I only support MDB (Office 11) Files in this Version, working and improving Utility System Requirements Windows 2000 SP4/XP (32/64 Bits) Windows Vista (32/64 Bits) Download...
Basics for Building Access 2007 Runtime-Based Solutions
Basics for Building Access 2007 Runtime-Based Solutions Summary: Find out how to prepare your application for use with the Microsoft Office Access 2007 Runtime. (6 printed pages) Jan Fransen, A23 Consulting Mike Stowe, Microsoft Corporation January 2008...
Recover tables deleted from a database in Access
How to recover tables deleted from a database in Access 2000, Access 2002, or Access 2003 Applies only to a Microsoft Access database (.mdb). The following sample function will try to recover all deleted tables in an Access database. To create the sample...
How do i connect to SQL Server within Access 2007 - Create ADP File
Looks like easy, it is, but the IDE changed a lot so goes the post 1. Choose create a new Black Database 2. Click the Button Browse for Files 3. Save Your File as ADP then Connect normaly to SQL Credentials to an Existing or create a new Database Cheers
How to Disable item (Type a Question for Help) Access Toolbar?
'(c) 2005 João Tito Lívio 'This code can only be use as a part of an Application and could not be sell Just Paste this line of Code to the MAIN form of your Project Application.CommandBars.DisableAskAQuestionDropdown = True
Dialog Box in Microsoft Access (Find File)
'(c) 2002 João Tito Lívio 'This code can only be use as a part of an Application and could not be sell 'To REQUEST a full functional sample please > Click 1. Insert a DialogBox ActiveX in your Form. In Design View go INSERT - ActiveX CONTROL...
Linked Table Manager is Missing!
'(c) 2005 João Tito Lívio 'This code can only be use as a part of an Application and could not be sell Linked Table Manager is Missing! The file acwztool.mde may be corrupted or is missing Workaround : 1. Find file acwztool.mde an put...
How to automate with Office Assistance?
'(c) 2002 João Tito Lívio 'This code can only be use as a part of an Application and could not be sell 'This method can not be USER FRENDLY, use with caution 'To REQUEST a full functional sample please > Click modAssistancePropreties...
How to use "Like" in SQL Access to find Costumers in a Form (TextBox and a ListBox)
'(c) 2003 João Tito Lívio 'This code can only be use as a part of an Application and could not be sell 'To REQUEST a full functional sample please > Click SQL Using an SQL Querie SELECT Customers.CompanyName, Customers.ContactName...
How to Disable (F11 key) Shortcut to database Window?
'(c) 2005 João Tito Lívio 'This code can only be use as a part of an Application and could not be sell 'TIP: Use code in the Autoexec Macro 'USAGE: If DisableSpecialKeys = True then MsgBox"OK" 'To REQUEST a full...