Events
Portland Access User Group (PAUG)  logo

Register now: PAUG 2014 Database Designer International Conference

Register now to join us May 3-5 for the Portland Access User Group (PAUG) 2014 Database Designer Conference.┬áThis year’s speaker lineup includes industry experts F. Scott Barker from AppsPlus, Luke Chung from FMS, Alison Balter from InfoTech Services Group Inc., Armen Stein from J Street Technology, Juan Soto from IT Impact, and Kevin Bell and Kevin Nickel from the Microsoft Access team. This is the 16th annual Database Designer Conference…

Access

Access 2010: How to write expressions for Web queries, forms, and reports

Before Access 2010, Access supported a wide variety of expressions in different areas of the application.  Tables and fields, queries, form and report properties, controls, and macros can all use expressions to evaluate data or logic to drive the behavior of an application. In the past, each of these contexts in which an expression is used have shared a single, common expression evaluation engine. This means that no matter where…

Access

Power Tip: Maximize the use of TempVars in Access 2007 and 2010

Today’s tip is provided by Juan Soto, Senior Access Developer at AccessExperts.net. His blog is at AccessExperts.net/blog and you can subscribe to it by clicking here. Juan is a frequent speaker at Access user groups nationwide and was a participant in the last Access developers kitchen for Access 2010. He can be reached through his website or his blog. The TempVars collection has the ability to save you time, improve…

Access

Power Tip: Maximize the use of TempVars in Access 2007 and 2010

Today’s tip is provided by Juan Soto, Senior Access Developer at AccessExperts.net. His blog is at AccessExperts.net/blog and you can subscribe to it by clicking here. Juan is a frequent speaker at Access user groups nationwide and was a participant in the last Access developers kitchen for Access 2010. He can be reached through his website or his blog. The TempVars collection has the ability to save you time, improve…

Access

Going beyond Web Macros: Using Event Receivers & .NET with Access Services

Today’s guest blogger is Access MVP Ben Clothier. Ben is an independent contractor working with J Street Technology and Advisicon and was Technical Editor for the Access 2010 Programmer’s Reference. One challenge in Access Services is ensuring that the logic behind various objects will be portable between Access itself and the SharePoint site hosting the Access web database. To that end, the Access team has used macros to support the…

Access

Northwind 2010 Web Database is now available

We’re excited to announce that a longstanding Access tradition continues. A new version of the Northwind sample database has just been released. The best way to get to the template is to start up Access 2010, under Office.com Templates, click on Sample Templates, and then click on Northwind Web Database. You can also get the template here: Northwind Web Database.  As before, Northwind shows you what an Inventory/Orders system might…

Access

Power Tip: Password protect your VBA project

A question came in recently regarding whether you can password protect just the VBA code for an Access database, but not the rest of the database. The answer is yes! Here’s how to do it: In Access, press ALT+F11 to open the VBA editor. On the Tools menu, select <Database Name> Properties… On the Protection tab, select the Lock project for viewing check box. Enter and confirm a password. Click…

Access

Access 2010 and SQL Azure

This post comes from Russell Sinclair who is in New Orleans showing off the newest Access 2010 features at TechEd. Microsoft SQL Azure is a new cloud-based relational database built on SQL Server that provides highly available, scalable, multi-tenant database services hosted by Microsoft in the cloud. It eliminates the need to install, setup and manage SQL Server, freeing IT to handle day-to-day operations rather than having to manage and…

Access

Download Access 2010 Runtime, Database Engine Redistributable and Source Code Control

Download Access 2010 Runtime, Access Database Engine Redistributable (office connectivity components) 2010 and Source Code Control Add-in for Access 2010 today! Access Runtime 2010 Available in both 32-bit and 64-bit, you can download the Runtime here – http://www.microsoft.com/downloads/details.aspx?FamilyID=57a350cd-5250-4df6-bfd1-6ced700a6715&displaylang=en. It is currently offered in 13 languages and more languages will be offered at a later time. Read this post on features in Access Runtime. Access Database Engine Redistributable 2010 Formerly known…

Access

Macros search form

Today’s guest writer is Kerry Westphal—our resident macro expert. A common feature in well-designed applications is giving users the ability to quickly focus on the data they care about. A search or filter form allows users to specify criteria to limit the records returned. This also enhances performance because the entire recordset is not brought in. A typical filter form provides unbound text boxes, combo boxes, and other controls where…

Access

Power Tip: Create an AutoNumber field that starts with a number greater than 1

Today’s guest blogger is Luke Chung, President and Founder of FMS, Inc. Luke has written and presented a wide range of topics related to Access over the years. In addition to their many Access related products, FMS offers a wealth of great Access papers, tips, and video on their site. In Microsoft Access tables, the AutoNumber field type allows you to assign a unique sequential number to each row in…