News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, March 25, 2010

How to search for files

I am continuously upset with Windows search engine, every time I tried to use it – no luck, perhaps I am too geeky and running uncommon queries, but even loooong advanced search for some file on my hard disk either fails, either shows me something different.
Anyway – I found some time ago Everything search engine, and now I am happy man!

Some comparison – searching for excel file, which I have opened yesterday – takes 7 seconds for Windows Search and NO TIME for everything. Searching for comctl32.ocx – in start button – nothing, advances search everywhere – running already 2 minutes, no result yet, and in Everything – INSTANT!

And one more great searching tool, if you need to find text within files – Agent Ransack.

Maybe someone knows how to replace useless Windows Search with Everything? I would like to use Everything right from Start button. Or maybe I missed some trick to make Windows Search Engine search for files?


Wednesday, March 24, 2010

Query from Access 2010

It is not really 2010 version – but Query from Access works on all Office versions since 2000, and now on Office 2010 RC!

Screenshot below help you to find it if you are not familiar with new Office interface:



Wednesday, March 17, 2010

Developer's Ribbon for Access 2007

If you found that using Access 2007 ribbon is not an easy task – try this replacement for standard Access ribbon - Developer's Ribbon.


Tuesday, March 16, 2010

VBE Tools

Old good add-in, which I did not mention here – VBE Tools, adds a numbers of enhancements to Visual Basic Environment (VBE).


Wednesday, March 10, 2010

Functions to parse query SQL

J Street Technology offers J Street SQL Tools - a set of functions, which can parse query SQL into WHERE or ORDER BY clauses, so you can manipulate only certain part of query.

Labels: ,

Tuesday, March 09, 2010

Linked table to Excel Sheet

This line will create a linked table to specified worksheet (MySheetName)  in Excel workbook:

DoCmd.TransferSpreadsheet acLink,acSpreadsheetTypeExcel9, "MyTable", "C:\MyFile.xls", , "MySheetName$"

Labels: ,

Thursday, March 04, 2010

Export Access 2007 form to XML

This tip I just learned from Jeff Conrad, which can be useful when you need extract images, used in form’s theme:

In 2007 right-click on a form in Navigation Pane that has a 2007 theme you like

Select the option to export the form to XML

Select a destination easy to find

When prompted, make sure to select to export the "Presentation of your data (XSL)"

Navigate to where you exported and you'll find a folder called images

In that folder are all the images for the form. You can just grab them there instead of using SnagIt if you want.


Wednesday, March 03, 2010

Access VBA functions to TSQL

If you need to upsize Access queries with VBA functions to SQL Server – have a look at this article - T-SQL Equivalents for Microsoft Access VBA Functions.

Labels: ,

Tuesday, March 02, 2010

Getting file properties in VBA

Wayne Phillips published another piece on excellent code. using his method to run native code in VBA - Accessing detailed file information provided by the Operating System. Now you can easy get file properties, aka Shell Property Handlers, like MP3 file length, JPEG file extended properties, etc.Cool stuff!

Labels: ,