Results for:
Access 2003

• Query Criteria, Part 1: Be specific!

  27 Jun 2012

  ( This post was first published in August 2011 and is the first in a series of posts about using query criteria, which includes Query Criteria Part 2: Like what? and Query Criteria Part 3: prompting for input by using a parameter .) Queries are a fundamental part of developing and using any database...
• Display real-time information with the ControlTip Property

  28 Nov 2011

  Today's Power Tip is provided by Juan Soto, Microsoft Access MVP and an expert on Access with SQL Server. Using ControlTipText property to display real time information The ControlTipText property is usually associated with providing static information, usually a helpful tip for the user - for example...
• Accessing external data using the IN clause

  27 Mar 2009

  Someone sent us a question the other day about one of my favorite dark corners in Access and we thought it might be interesting to dive into this area a little. Microsoft Access SQL supports two uses of the IN keyword. The most commonly used case is as part of the WHERE clause of a SQL statement to provide...
• Dot or Bang?

  30 May 2008

  Here's a question that comes up from time to time. The other day, someone internally asked about the difference between using a dot "." vs. a bang "!" for control references in a form in VBA. In other words, given a form - Form1, with a control - Control1, what are the differences...
• Encryption vs. Encoding

  19 May 2008

  Every now and again we get the question of "what is the difference between encryption and encoding?" This came up again today so we wanted to try to answer it more broadly. In short, the feature that we call " encryption " is a feature that was introduced for ACCDB files in Access...
• Access Source Code Control and Team Foundation Server

  14 May 2008

  Today's guest writer is Mike Sullivan - a tester on the Access team With the release of Visual Studio Team System 2008 , we've recently received questions from several customers regarding whether or not Team Foundation Server (TFS) can act as a source code control provider for the Access source code...
• Microsoft Access Downloads in Silverlight

  21 Jan 2008

  I ran across this new Silverlight version of the Microsoft download center this morning.  If you haven't seen Silverlight yet, it is pretty cool stuff. It is Microsoft's engine for doing rich graphics composition in the web.  Here are all the downloads Microsoft has in the download center which...
• UI Builder for Access v.3.0 Released

  11 Jan 2008

  Brandon Smith-Daigle has recently released the 3.0 update for his UI Builder tool that helps Access developers to build customized user experiences in Forms without coding the VBA themselves.  This tool is compatible with older versions of Access as well as 2007.  He's running a limited time...
• Goldsoft tools for Access Developers

  11 Jan 2008

  Ken Hockley has recently released his Goldsoft suite.  These tools aim to increase Access developer productivity by helping to reduce the amount of time spent building necessary application plumbing so that developers can focus their effort on producing business logic.  More info is available...
• Access 2003 SP3 hotfix rollup now available

  28 Dec 2007

  You can find details here... http://support.microsoft.com/kb/945674 [Zac] For those of you who are wondering, this is the update I've told several folks would be coming. Everyone who is running Access 2003 SP3 will probably want to apply this patch. It includes fixes for the known problems SP2 users...