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 18, 2007
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
Click to read
Thursday, May 10, 2007
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
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.
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.
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
[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
Subscribe to:
Posts (Atom)
