Friday, May 18, 2007

Vista's Integrated Search Capabilities

Whilst it is not exactly MS Access coding, how about using a SQL query and a bit of code to search your computer for a file

An Introduction to Vista's Integrated Search Capabilities

Friday, May 11, 2007

MSXML Illustrated

The first two pages of this website provide a nice introduction to using the MSXML object to create an XML file.

Click to read

Wednesday, May 09, 2007

Security Considerations and Guidance for Access 2007

Summary: Find out how you can use Access 2007 to protect the information in your databases. Learn about encrypting files, administering passwords, converting databases to the new ACCDB and ACCDE formats, and using other security options such as SQL Server. (18 printed pages)


Read More at MSDN

Monday, May 07, 2007

Add this blog to your feeds

If you like this blog, you can subscribe to it by clicking on the

Subscribe to
Posts [Atom]

link at the bottom of the RHS column of this page.

I will keep different content in this blog to my main Access vb123.com website.
Garry, editor of vb123.com and Access MVP

Friday, May 04, 2007

Access Unlimited News - Issue 77

The latest edition of my newsletter, Access Unlimited - Issue 77 is available online.

Send SMS with Skype 3

Send SMS with Skype 3

On this page I will show you a simple way to send an SMS using Access VBA and Skype. All you will need is Skype credit and Skype 3 or higher internet phone system.

Wednesday, May 02, 2007

Consistent Filtering In Access 2007 and Excel

In Access 2007, one of the considerable achievements is greater consistency with Excel. One of my favorite features is Filtering.

In Excel (First click on the Filter Button) then click on the down arrow at the top of the Column. In Access 2007 (2nd picture), click on the down arrow at the top of the Column.













Using A Form Field In A Crosstab Query

A client asked me how to use a form field in a crosstab query. Initially I thought it would be a matter of adding the following in the criteria field of a query
[Forms]![_MyApplication]![cboProduct]

Unfortunately this brings up the error Microsoft Office Access does not recognise FieldName as a valid field name or expression. Much hunting around and then I remembered that you can use a Function as criteria for a query. So I wrote the following Function

Public Function CrossTabParam() As String On Error GoTo error_exit
CrossTabParam = [Forms]![_MyApplication]![cboProduct]
Exit Function
error_exit:
MsgBox "Error in function { No. " & Err.Number & "} " & Err.description
Exit Function
End Function


Now i changed the criteria to be and it works... Here is the working crosstab

WHERE zSales_Demo.ProductName =CrossTabParam()


The example is taken from a table in my popular graphical program graf-fx.
http://www.vb123.com.au/explore