Results for:
access 2010

• Using crosstab queries in reports

  23 May 2012

  (Guest blogger, Molly Pell is a Senior Systems Analyst at FMS, Inc. , a leading Access applications company, which designs custom solutions to improve operations for small and large organizations in all sectors.) A well designed database stores data in a normalized format with dates defined in a field...
• Using a Combo Box to search as you type

  3 May 2012

  (Guest blogger, Molly Pell is a Senior Systems Analyst at FMS, Inc. , a leading Access applications company, which designs custom solutions to improve operations for small and large organizations in all sectors.) Here's a neat trick that you can use to filter a Continuous or Split form while your users...
• 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...
• Q&A with Access developer Juan Soto

  17 Feb 2012

  Juan Soto founded IT Impact, Inc . (an Access development company) after working at an ice cream factory in Chicago. The factory's large Enterprise Resource Planning system required that he spend hours manually calculating whether a final batch of ice cream really made the company money. He had to factor...
• How to save your Access SharePoint password

  26 Jan 2012

  Recently, someone posted a comment on IT Impact Inc.'s blog asking how to get SharePoint to remember his password when he logged in via Access. He wanted to avoid having to log in every time. Ben Clothier, a Senior Access Developer at IT Impact, knew the answer. He wrote a detailed blog post (with plenty...
• An Updated Data Model Has a Choral Arts Group Singing

  21 Nov 2011

  If you've ever inherited a database that's home-grown, you probably can relate to Donna O'Connor, former Director at Choral Arts , a non-profit emsemble of singers. When she started her job, its database was a mess: it had been built up over time by a succession of directors, and had no plan or data...
• Full-featured Access Services solution at http://www.accesshosting.com

  14 Nov 2011

  Our friends at AccessHosting.com are offering free trials of two Access "cloud" solutions. Curious? Here's the deal, from the source . Offer text provided by AccessHosting.com Reporting services for Access Web Databases in SharePoint 2010 now available - Office 365 users looking web based reporting functionality...
• 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 1: Be specific!

  11 Aug 2011

  NOTE: This is the first in a series of posts about using query criteria. Queries are a fundamental part of developing and using any database. In addition to providing a way to make bulk changes to your data, they are how you ask questions about that data. Query criteria help you make your question more...
• 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...
• Lists unlimited: let users add new values

  20 Jul 2011

  It happens all the time: there's a list of choices but it doesn't have the choice you want. No worries! You can enable folks to add items to a lookup field. I've listed below some relevant tips from the community and the main MSDN topic on the subject. Justin Ferrel offers a how-to on using VBA to add...
• UPDATE: Using 64-bit Access 2010? You may want to wait on SP1

  8 Jul 2011

  A customer's post on TechNet brought one of my colleague's attention to an error folks are seeing after applying SP1 to 64-bit Access installations and then trying to use a wizard: The database cannot be opened because the VBA project contained in it cannot be read. ... To open the database and delete...
• Free preview of Total Visual CodeTools 2010

  7 Jul 2011

  The good folks at FMS, Inc. have kindly made the latest version of their Access/VBA development tools freely available for use until August . Whether you're writing new code, updating old projects, or taking over someone else's work, Total Visual CodeTools helps you deliver better, standardized solutions...
• Social media done easy

  13 Jun 2011

  If you think back to around Valentine's Day of this year, you might remember our post about AccessLove , a social-media-type Access web database that became very popular with Microsoft employees. As a result of that response, the creators of AccessLove decided to present a "how we did it" session to...
• Access Services and IT pros: Impressions from TechEd 2011

  26 May 2011

  Today's post is contributed by Lois Wang from the Access team. J.R. Arredondo and I had the opportunity to be at TechEd 2011 in Atlanta last week. We had two talks: a small interactive session called ”Empowering information workers with Access,” and a big-room presentation called “Managing...
• Office 2010 SP1 on track for late June

  17 May 2011

  We're on track to deliver Office 2010 SP1 in late June 2011 (here's yesterday's official announcement ). We definitely recommend this update for all Office 2010 users. There has been great work put into this service pack that further enhances the performance and security of Access. Here are a couple...
• Office 365 helps you take care of your data

  12 May 2011

  If your organization has important data stored in an older, unsupported database program, and other people in your organization need to work with that data on a regular basis, Access 2010 and Office 365 can help. By migrating your data into Access 2010, and then publishing the database to your Office...
• Not all equals signs are created equal

  2 May 2011

  If you've ever played the guessing game about where to put (or where not to put) an equals sign in an Access macro, this post is for you. The choice depends on whether you're dealing with an expression or a string, and getting it right is especially important if you plan to publish your database to Access...
• Streamline reporting on recurring data imports

  26 Apr 2011

  Do you often have to summarize large data sets that have been extracted from your corporate database? Access can be very helpful when you need to work with a huge stream of data. We've published a new article that shows you how to make the data easier to import, analyze, and summarize in reports, even...
• Deploy Access applications with the help of Terminal Services and RemoteApp

  20 Apr 2011

  One of the great things about Access is the variety of ways in which you can deploy a database application to a group of users. For example, if you're using Access 2010, you can publish a database to Access Services on a SharePoint server , enabling anyone with access to that server to use the database...