Office Systems Developer

Joao Livio (Portugal)

Browse by Tags

All Tags » VBA Code (RSS)
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...
VBA and Office 14, just to clarify
According with Kevin Boske, Microsoft VSTA Program Manager, "there's been some discussion on this thread on Slashdot, ( updated ) which started from this article in The Register UK . To be clear, Microsoft is not replacing VBA with VSTA or VSTO...
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...
Portuguese Functions for Access 2007 - Funções em Português para o Access 2007
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...
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...
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...
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 Spell Months by VBA Code and SQL?
'(c) 2005 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 VBA MsgBox (Format(Now(), "mmmm")) MsgBox ("Month: "...
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...
How to Spell numbers to Euros using API?
'(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 This function originally was developed as the name indicates to convert...