Results for:
Power Tips

• Power Tip: Simplify development, testing, and troubleshooting multiple versions of Access with Windows 7 Virtual PC

  4 Jun 2010

  Today’s guest blogger is Brandon with OpenGate Software, offering Microsoft Access tools and Access templates for users of every experience level. While we’d all like our customers stay up to date with their software releases, inevitably you may find yourself supporting users on Access 2000, 2002, 2003...
• Power Tip: Distinguish between an unsaved record and a saved one

  26 May 2010

  When you are in the process of entering a new record in an Access database, you can press the Escape key to cancel the entry of the record. However, some events, such as clicking or tabbing into a subform on the main form, can save the record on the main form. At that point, you can't press Escape to...
• Power Tip: Count the number of rows in a subform

  15 Apr 2010

  Today's guest blogger is Access MVP Garry Robinson, who offers the Smart Access collection of articles at http://www.vb123.com/kb . Here's a great tip from the Smart Access collection that I used recently. I needed the count of rows in a subform to display on the main form. It's surprisingly easy--all...
• Power Tip: Change the default behavior of controls

  25 Mar 2010

  Today’s guest blogger is Nadia Szucs, president of N-Soft , a provider of IT consulting services to businesses of various sizes in the Greater Toronto Area (Canada). N-Soft specializes in custom Microsoft Office product solutions centered around Microsoft Access implementations. I would like to share...
• Power Tip: Estimate the complexity of an Access development project

  4 Mar 2010

  Today’s Power Tip comes from Brandon with OpenGate Software, offering Microsoft Access products for Access users of every experience level, including UI Builder , Designer , and Dashboard Builder for Microsoft Access. As we all know, it's never easy to estimate how much work will be involved when creating...
• Power Tip: Making forms easier to use and maintain

  25 Jan 2010

  Reader Štefan Masič provides today's Power Tip. In today’s post I would like to share with you some tips about form design that I’m using consistently in all applications I develop. Maybe you can get some benefit from my approach to form design. As we all know, analysis and preparation of user needs...
• Power Tip Link: Delete records by using a delete query

  13 Jan 2010

  Today's guest author is Luke Chung, President and Founder of FMS, Inc. DELETE queries are a fundamental part of relational databases since you can remove multiple records at one time, and can specify which records to delete by linking to data in another table. Delete query option in query Design View...
• Dashboard graphics in forms and reports

  8 Jan 2010

  Mike Alexander, Excel MVP recently sent us a pointer to a blog post with some cool ideas to spice up your application with data visualizations . Here is a quick sample: Mike didn’t mention attachments in his post but the attachment control works really well for storing images. I have a similar technique...
• Manage large groups of controls by using the Tag property

  5 Jan 2010

  Today's guest blogger is Access MVP Garry Robinson, who offers the Smart Access collection of articles at http://www.vb123.com/kb . In Smart Access Answers , Doug Steele was asked “What if I have a number of different controls–say, text boxes, labels, and check boxes and I want to make them invisible...
• Use late binding to improve the performance of tabbed forms

  9 Dec 2009

  Luke Chung, President and Founder of FMS, Inc., 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. If you use the Tab Control to pack a lot of...
• The Cartesian product: a feature, not a bug

  30 Nov 2009

  Today's guest blogger is Access MVP Garry Robinson, who offers up another gem from the Smart Access collection of articles at http://www.vb123.com/kb . In this article written by Peter Vogel, you will be given an overview about what it means to write queries where tables are not joined. This is a good...
• Add color formatting to columns in Combo Boxes and List Boxes

  17 Nov 2009

  Today's guest blogger is Pavlo Pedan of ARGO Business Corp. He has 15 years of experience with Access and has a great site of tips  at http://sites.google.com/site/msaccesscode/ . As we all know, a List Box control has a Fore Color property. It sets the fore color for column values and headers simultaneously...
• Sorting a Listbox Using Command Buttons

  13 Nov 2009

  Today’s guest blogger is Daniel Lamarche. Daniel is the Training Director at ComboProjects , which specializes in providing custom training solutions in Microsoft Office products. I always thought it was cool to be able to sort a list by clicking the column heading once, for ascending order then once...
• Displaying Data From Related Tables on a Form

  6 Nov 2009

  Today's guest blogger is Access MVP Scott Diamond. Scott is the principal of Diamond Computing Associates and the author of Microsoft Office Access 2007 VBA . This is a very frequently discussed issue. But before I get into the methods, you need to understand one of the principles of relational databases...
• A better way to reference tab control pages

  5 Nov 2009

  In VBA, a common way to refer to the pages of a tab control is to use the Value property. However, Luke Chung, President of FMS Inc., recommends using the PageIndex property instead. Click here to find out why! Send your Power Tips to Mike and Chris at accpower@microsoft.com .
• Running an Access Parameter Query from Excel

  23 Oct 2009

  Excel MVP Michael Alexander wanted to share this tip about running an Access parameter query from Excel. He describes the problem thusly: An Access parameter query is a kind of interactive query that prompts you for criteria before the query is run. Parameter queries are useful when you need to ask the...
• Expand only the subdatasheets you want

  21 Oct 2009

  Today's guest blogger is Pavlo Pedan of ARGO Business Corp. He has 15 years of experience with Access and has a great site of tips  at http://sites.google.com/site/msaccesscode/ . If you have a form that contains subdatasheets, you can use the following VBA command to expand all of them: Forms!...
• Using the ShowToolbar Method to Hide the Ribbon

  16 Oct 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. I have been using the ribbon for the last two years and I like it so much, however...
• Nulls vs. zero-length strings: a Power Tip from the past

  14 Oct 2009

  Today's guest blogger is Access MVP Garry Robinson, who offers the Smart Access collection of articles at http://www.vb123.com/kb . A few months ago I purchased the rights to publish the Smart Access magazine online and it is from that collection that I offer this tip from Paul Litwin, the first editor...
• Identifying the Record Selected on a Continuous Form

  6 Oct 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. Regularly when we create databases for our customers we use continuous forms for data...