Access Tutorials on EverythingAccess.com

Just found a good list of Access Tutorials on EverythingAccess.com. Some interesting headlines:

• Undocumented SysCmd Functions


• Managing Access COM Add-Ins


• Undelete Tables and Queries in Access


• How to specify which version of Access to use for OLE automation


• Access Database Corruption Repair Guide

Certainly a good place to check it out!

How to check spelling of a text, entered into textbox

The sample code below shows the idea – you move cursor to textbox, select text and then run spelling:

With Me.TextBox1
    .SetFocus
    .SelStart = 0
    .SelLength = Len(.Text)
End With

DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True

How to setup MS SQL Server 2005 or SQL Server Express

With Microsoft SQL Server 2000 or MSDE this was very easy – once you have installed it – it is accessible from the network. But due to improved security this does not work anymore. Now you have to fine-tune SQL Server. There is a Getting Started with the Database Engine tutorial as MSDN site, which can help you. And do not forget that we have a simple AttachDB Utility, which help you to perform simple administration tasks, like Attach/Detach and Backup/Restore in a few clicks!

How to set combobox or listbox to its first item

If the first column is the bound column – then the code would look like this:

Me.Combo1 = Me.Combo1.Column(0, 0)

To set a default value of combobox to its first item you can use similar approach:

Me.Combo1.DefaultValue = Me.Combo1.Column(0, 0)

Automate simple tasks with AutoIt

Remember – Windows 3.1 had a Macro Recorder program? This is something similar, but with BASIC-like scripting language – AutoIt. It uses a combination of simulated keystrokes, mouse movement and window/control manipulation in order to automate tasks in a way not possible or reliable with other languages (e.g. VBScript and SendKeys).  AutoIt is also very small, self-contained and will run on 95, 98, ME, NT4, 2000, XP, 2003 out of the box with no annoying "runtimes" required!  You can even make compiled executable scripts that can run without AutoIt being installed.

There is no DAP in Access 2007

Honestly – I never used Data Access Pages (DAP) in Access. I tried several times, but have not succeeded. You can really build something on DAP, but in order to use this page – you have ask users to install lot of additional staff. Mush more easily to make ASP page.
But in Access 2007 DAP will gone, Clint Covington have confirmed this in Utter Access Forums. Much more easy to do the same (I mean same functionality, like DAP offers) on SharePoint Server.