Office Systems Blog

Joao Livio 2002 - 2008 Portugal

Browse by Tags

All Tags » Microsoft Access (RSS)
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...
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...
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...
Training Kits Microsoft Powered in portuguese - PT Portugal Formacao Office Microsoft Powered
Ajude a aumentar a segurança: Segurança no Office Consultas II: Limitar os dados e calcular valores Relatórios I: Apresentação dos dados Apresentação dos controlos Consultas I: obter respostas com consultas...
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...