Results for:
How_2D00_to

• Streamline collaboration across teams: Add notifications to your Access 2013 web apps

  18 Feb 2013

  Access 2013 web apps are great for collaborating around a common set of data. When people work together in this way, the changes that one person makes to the data often require the attention of someone else. For example, if a small team is working together to track and process maintenance requests, an...
• Data entry made easy

  13 Aug 2012

  This post was written by Erik Kennedy, a Program Manager on the Access team. In Access 2013, there are lots of improvements to help you quickly make a great user interface for your web databases. With this interface, the people who use your app will have easy time entering data. There's two ways we've...
• Access 2010: How to write expressions for Web queries, forms, and reports

  19 Mar 2012

  Today’s guest author is Russell Sinclair , the Program Manager for expressions, ACE, along with other features. (NOTE: Because this post explains one of the basic improvements to Access 2010, it remains very popular among Access developers. For that reason, we're republishing it so many more of...
• Ways to use Access data in Excel

  6 Oct 2011

  When you need to use Excel to analyze data in an Access database, you have several options: you can copy and paste the data, create a data connection from Excel, or export the data to an Excel file. Your best choice depends on what you want to do. Copy/Paste If you just need some values from Access one...
• Query Criteria Part 3: prompting for input by using a parameter

  1 Sep 2011

  In part 2 of this series, we considered using LIKE and wildcards in query criteria to find inexact matches. Good stuff - but what if you could get the query to apply criteria that are supplied when it is run? What if you could make a query ask for input? Good news! You can make a query ask for input...
• Query Criteria Part 2: Like what?

  18 Aug 2011

  In part 1 of this series , we considered a basic example of using criteria in a query to make the query's question more specific. That's great if you know exactly what you're looking for. But what if you want to see inexact matches - say, everyone whose last name starts with Th ? You're in luck - Access...
• Access and SharePoint: a look at integration points from 2003 to 2010

  31 Jul 2011

  For several releases, Access and SharePoint have grown together, providing increasingly more compelling functionality - from fairly simple data sources through to web databases that run in a browser. Ben Clothier at http://accessexperts.net has a two-part review of the evolution of Access working with...
• Access 2010 BrowseTo DoCmd and macro action

  23 Feb 2010

  Today’s guest writer is Steve Greenberg, a Lead Program Manager on the team. Steve is responsible for form rendering and the new templates in Access 2010. Last week the team was privileged to host our MVPs at a conference here in Redmond. During our in-depth talks about Access 2010, some of these...
• Publish to SharePoint (part 1)

  23 Nov 2009

  Today’s guest writer is Ric Lewis—the PM in charge of publishing to SharePoint. A common question in the Access community is “how do I get my app on the web?” Here is the most recent example : My wife and I have just started our own Recruitment business and I started an Access...
• Build navigation UI with Access 2010

  14 Nov 2009

  Today’s guest writer is Wouter Steenbergen, a PM on the Access team responsible for Access form and report designers. If you want to build an easy to use application it always starts with a good navigation model that allows users to quickly perform the most common tasks and easily find the less...
• Access 2010 Themes

  23 Sep 2009

  Today’s guest writers are Steve Greenberg and Viki Selca. The PMs that have lead the effort to make it easier to create great looking apps. People say “Don’t judge a book by its cover” but everyone who develops software knows that applications are judged by their look and feel...
• Meet the Access 2010 macro designer

  28 Jul 2009

  Today’s guest contributors are Kerry Westphal, Chris Downs, Krunal Sheth, James Rivera, and Michael Tucker—from the macro designer feature crew. The Macro Designer is a revamped editor that allows you to automate repetitive tasks; wire together forms and reports to create productive UI; and...
• 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...
• Writing a Count(Distinct) Query in Access

  19 Sep 2007

  We received a question from a reader named Eric week before last about how to write a Count(Distinct) query in Access. In other database applications such as SQL Server, Oracle, and MySQL, the Count(Distinct) aggregate is used to count the number of unique items in a given rowset. For example, consider...
• Using VBA code to open a file stored in the new Access 2007 Attachment field

  30 Aug 2007

  Someone asked me about using the Attachment data type in Access 2007 for a specific task. They wanted to use it as a simple data type where it would only be used to hold 1 file per record, and they wanted to be able to open the file in an external application using a button on a form instead of using...
• Adding, removing, and saving files from the new Attachment field in Access 2007

  24 Aug 2007

  One of the coolest new features in Access 2007 is the new Attachments data type. There are some very helpful dialogs for working with this data type, but there are also some useful additions to DAO to make automating the process of adding and saving attachments easy, too. What follows is some VBA code...