Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Access Team Blog

Get product announcements, tips and tricks, and news directly from the team @ Microsoft.

Browse by Tags

All Tags » Access 2007   (RSS)
Access 2007 hotfix package now available
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 Read More...
Handling the SQL Server bigint data type in Access 2007 using ADO
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 Read More...
VBA values for Office theme colors
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 Read More...
Synchronize with SharePoint under the hood
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 Read More...
How to: Create a Shortcut Menu for a Form, Form Control, or Report
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, Read More...
Access 2007 and Runtime SP2 now available
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 Read More...
Access 2007 SP2 due to ship April 28th
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 Read More...
Template demonstrates how to synchronize combo boxes
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 Read More...
Accessing external data using the IN clause
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 Read More...
Paste from Excel hotfix available
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, Read More...
Automate data collection forms using VBA
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 Read More...
Access Developer Extensions 2007 Updates
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 Read More...
A new hot fix for Access 2007 is now available
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 Read More...
Built-in Tab Names in Access Ribbons
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 Read More...
Total Access Analyzer 2007 Preview
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 Read More...
More Posts Next page »
Page view tracker