Results for:
tips

• 5 tips to make your Access database super-fast

  10 Jul 2012

  (Guest blogger Juan Soto is an Access MVP and founder of IT Impact, Inc . You can read more about Juan in our Q&A with him.) We've all been there. You fire up Access and load your favorite Access app only to see it drag like molasses in winter. Try these five tips to boost the speed of your database...
• 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...
• Five Common Pitfalls When Upgrading Access to SQL Server

  17 Feb 2012

  Guest blogger Juan Soto, an Access MVP and founder of IT Impact, Inc., shares five tips on upgrading Access to SQL. You can read more about Juan and his experiences and knowledge of Access knowledge in our Q&A with him. Tips for a Smooth Migration Access works great with SQL Server but upgrading...
• 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...
• Display real-time information with the ControlTip Property

  28 Nov 2011

  Today's Power Tip is provided by Juan Soto, Microsoft Access MVP and an expert on Access with SQL Server. Using ControlTipText property to display real time information The ControlTipText property is usually associated with providing static information, usually a helpful tip for the user - for example...
• Date functions part 1: some common scenarios

  15 Sep 2011

  This is the first of a series of posts about date functions. Many of you search Office.com for help using date functions in Access. Perhaps you want to select some portion of a date (e.g., the year). Maybe you want to format the display of date/time data, or find the difference between dates. In this...
• 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...
• 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...
• Wrap text in Access

  15 Apr 2011

  How do you wrap text in Access? It's a question we hear quite frequently on Office.com. It may surprise you to learn that in most places where text is displayed in Access, text wrapping is on by default. The key is making sure there is enough room for the text to wrap. The process for doing that depends...
• Power Tip: Create an AutoNumber field that starts with a number greater than 1

  2 Apr 2010

  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 2010: Application Parts and Data Type Parts

  31 Mar 2010

  One of our goals with Access 2010 was to make it easier to reuse your database design work. In the Access 2007 Developer Extensions, we allow you to save a database as a template, making it available for others to use either as a starting point or a ready-to-use application. In Access 2010, you now can...
• Cross version compatibility between Access 2010 and Access 2007

  13 Jan 2010

  Today’s guest writer is Lois Wang—PM for reports and version-to-version compatibility. I saw a question on the Access TechNet Forum the other day that I’d like to share with the community: “ I can't open accdb files in Access 2007 after they've been opened in 2010.” Access...
• Access 2010 Custom Themes

  25 Sep 2009

  Today’s guest writer is Steve Greenberg. The recent Access 2010 Theme’s post introduced you to the new Office themes inside Access. Now let’s show you some of the advanced things you can do with themes. The controls we are about to use can all be found to the left of the Design tab...
• Set query parameters with macros

  5 Aug 2009

  Last week we blogged about changes to the new macro designer . I promised to write about IntelliSense but the first draft was lost in an unfortunate hard drive crash. I thought this is a good time to tell you about changes to the macro designer that encourage good design through better support of parameters...
• 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...
• Access Source Code Control and Team Foundation Server

  14 May 2008

  Today's guest writer is Mike Sullivan - a tester on the Access team With the release of Visual Studio Team System 2008 , we've recently received questions from several customers regarding whether or not Team Foundation Server (TFS) can act as a source code control provider for the Access source code...
• Access 2007 Limits

  5 Jun 2006

  This is a quick post to lay out the limits in Access 2007 and make a little clearer how the application works and how it scales. The first table below shows the limits of the database engine itself. Access Database Limits Access database (*.mdb or *.accdb) file size 2 gigabytes, including all objects...