Results for:
Access 2007

• 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...
• Access 2007 hotfix package now available

  10 Sep 2009

  Here are the list of issues fixed in this download package . In Microsoft Office Access 2007, you have a report that includes a form reference in the criteria of the record source. When you enter a letter at the first parameter prompt, a numeric value is displayed on the report. For example, if you enter...
• Handling the SQL Server bigint data type in Access 2007 using ADO

  10 Jun 2009

  Today’s guest blogger is Vinny Malanga. Vinny is the CTO of IMI Software, Inc. , which specializes in software development for the property management industry. I recently received a call from a client asking for help on how to use the SQL Server bigint data type in a disconnected Access .accdb file...
• VBA values for Office theme colors

  26 May 2009

  Recently, there was a thread on UtterAccess that I thought might be helpful to more people. The poster radish asks: I'd like to change the color of a control then be able to change it back to its original color. If I wanted to use the theme's highlight color, e.g., how would I do that in code? It's listed...
• Synchronize with SharePoint under the hood

  26 May 2009

  Recently I was asked the following question: I am looking to get an understanding of the internal operations during an Access 2007 synchronize execution. I have just been exposed to a SharePoint MOSS and Access 2007 environment where at times the normal sync time goes from 7-minutes to around an hour...
• How to: Create a Shortcut Menu for a Form, Form Control, or Report

  21 May 2009

  Today’s guest blogger is Edwin Blancovitch. Edwin is president of Advanced Developers.net , creators of Easy Payroll , a software package to manage your human resources, payroll, scheduling, time and attendance needs. When you're designing a form or report, you may want to provide a method for...
• Access 2007 and Runtime SP2 now available

  29 Apr 2009

  Highlights The ability to export reports to Excel has been added. Fixes for issues with the import data wizards, report printing and previewing, macros, Excel integration, and date filters. Updates to Access Developer Extensions and Access Runtime are updated for SP2 and are available in all supported...
• Access 2007 SP2 due to ship April 28th

  24 Apr 2009

  The Office Sustained Engineering team has announced the official ship date . Highlights for Access include: The ability to export reports to Excel has been added. Fixes for issues with the import data wizards, report printing and previewing, macros, Excel integration, and date filters. Updates to Access...
• Template demonstrates how to synchronize combo boxes

  2 Apr 2009

  You can download a template for Access 2007 that demonstrates how to synchronize two combo boxes. For example, say you choose a category from one combo box, and you want a second combo box to only display products within that category. The template shows you how to make it happen. On the Getting Started...
• 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...
• Paste from Excel hotfix available

  18 Mar 2009

  in mid December an Excel security fix (MS08-074) broke paste from Excel inside Access. Users would get the following error message: The data on the Clipboard is damaged, so Microsoft Office Access can't paste it. There may be an error in the Clipboard, or there may not be enough free memory. Try the...
• Automate data collection forms using VBA

  10 Feb 2009

  Access 2007 has a nifty feature that allows you to collect data via email . Recently, I got the following question from a user: Is there any way to automate the creation, sending and receiving of Emails through the Data Collection capability of A07 using VBA?  The wizard is too complex for the users...
• Access Developer Extensions 2007 Updates

  20 Jan 2009

  Access Developer Extensions 2007 has been updated and is now live on Microsoft.com. Here is a link - http://www.microsoft.com/downloads/details.aspx?FamilyID=d96a8358-ece4-4bee-a844-f81856dceb67 Highlights of the updates: Package Solution Wizard A wizard that creates a Windows Installer Package (MSI...
• A new hot fix for Access 2007 is now available

  30 Dec 2008

  Issues fixed include: You experience slower performance than you did in previous versions when you share a database file over a network. You may notice your database file increase in increments of 4 KB  without any user interaction when the database is open. You may see a sub-form become blank after...
• Built-in Tab Names in Access Ribbons

  10 Dec 2008

  If you've tried to create a Ribbon customization that included one of the built-in controls in Access you've probably seen that you can use the Customize page in the Access Options dialog to get the names of groups and controls. You can also download the entire list of controls from the Microsoft web...
• Total Access Analyzer 2007 Preview

  28 Aug 2008

  One thing about being on the Access team that I enjoy is seeing some of the great work being done in the Access community. Among the forefront of this community is FMS , who is the leading developer of Access add-ins. FMS recently announced a preview version of Total Access Analyzer 2007 which is a tool...
• New Access 2007 Technical Article

  20 Aug 2008

  Aleksandar Jakšić, who is one of the testers on our team, has written an article that shows you how you can use the Access Database Engine from native applications written in C/C++. The article shows you how to to the Access Database Engine using C or C++, but has a great discussion of the data...
• The Contacts Template Redesign: Listen, Iterate, and Educate

  15 Aug 2008

  Today’s guest writer is Josh Meisels, our intern this summer. He is heading back to school next week but wanted to share information about one of his summer projects. Access 2007 made a huge push to create useful, ready-to-use database templates that users could download from Office Online and get started...
• Adding multiple attachments from a folder

  31 Jul 2008

  Rob Cooper recently made a post, Adding Attachments from a Folder , which shows how to add a single attachment file per row. But what if you wanted to add more than one file? One (highly contrived) scenario would be to add all of the files in a folder to one row, and do so recursively if requested, similar...
• Adding Attachments from a Folder

  25 Jul 2008

  Someone asked us yesterday how to add all of the .jpg files from a folder into an Attachment field in a table. In this case, the individual wanted to add one attachment into a new record in the table. This could be pretty useful, so we thought we would post it more broadly. This code accepts parameters...