Results for:
Power Tips

• 3 new articles available on MSDN

  5 Oct 2009

  MSDN writer Sal Ricciardi alerted us to the availability of 3 new articles on MSDN, two written by Luke Chung of FMS Inc. , and one co-written by Luke Chung and Dan Haught. Title Author(s) Performance Tips To Speed Up Your Access 2007 Database Luke Chung and Dan Haught Error Handling and Debugging Tips...
• Dynamically Resize a Subform Based on the Record Count

  30 Sep 2009

  Today’s guest blogger is Vinny Malanga. Vinny is the CTO of IMI Software, Inc. , which specializes in software development for the real estate and property management industries. Many Access developers implement subforms to display data. Most often, at design time, the developer sets the subform to a...
• Tracing Function Calls in VBA

  24 Sep 2009

  Today’s guest blogger is Joel Graff. Joel is a field engineer with the Illinois Department of Transportation (IDOT) . Often, I find when looking for the source of an error in VBA code, a function call trace which returns the path of function calls preceding the error to be invaluable. While more complete...
• Switch the Property Sheet on and off from VBA

  23 Sep 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/ . When you open a form or report in Design View, the Property Sheet is either displayed or hidden based on its state the...
• Using VBA to Send Data to a Table from an Unbound Form Control

  16 Sep 2009

  Today’s guest author is Justin Farrell, author of the Access 2007 tutorial http://www.dealing-with-data.net . This is a useful trick which gives the Access Developer additional flexibility when working with forms and data. It uses Access VBA and DAO. Once the user enters data into the unbound textbox...
• "Convert" a TextBox to a ComboBox at a run-time

  14 Sep 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/ . Some people do not like having ComboBoxes on a form because of drop-down buttons. Microsoft offers a solution here ...
• Use a validation rule instead of the Required property

  9 Sep 2009

  Reader Štefan Masič provides today's Power Tip. When you want to require users to enter a value in a field, a common technique is to set the Required property for that field to Yes (for example, tabPerson.Name.Required = Yes). However, when the user is then adding records to the table and neglects to...
• Jump start new Access databases with a custom blank database template

  4 Sep 2009

  Today's guest blogger is Access MVP Glenn Lloyd of Argee Services. Check out his Office help blog and Access Help and Tutorial Blog . There are certain features that virtually every Access database application includes. Certain tables like people’s names and addresses, certain forms for managing lookup...
• Calculating Week Numbers is Easier Than He First Thought

  3 Sep 2009

  Excel MVP Michael Alexander wrote in with a tip on calculating week numbers. It's always a little embarrassing when you roll your own Function to achieve some functionality that already exists in Excel or Access. Recently, I stumbled across a user-defined function designed to find a week number in Access...
• Use a crosstab query to create monthly summary reports

  31 Aug 2009

  After you've built a few Access database applications, you inevitably come up against this problem: the arrangement of your data in tables is not the arrangement you want on reports. Frequently, values appear vertically in a table, but you want them to appear horizontally on the report. Luckily, crosstab...
• Create flexible Excel exports with on-the-fly SQL

  25 Aug 2009

  Kingsway Financial Assessments provides independent financial assessment reports and credit reports to support decision making when awarding contracts and tenders. Kingsway uses an Access database built by Hockley Computer Services using Goldsoft . Ken Hockley is today's guest blogger. I’ve been using...
• Cool Tool Tips: A Better Control Tip

  24 Aug 2009

  Tony D'Ambra of aadconsulting.com , maker of Access add-ins and switchboards, wanted to share his method for providing help to users when and where they need it. In Access, the functionality of tool tips has not changed since they were introduced in Access 95 ten years ago. In a free sample Access 2000...
• Use a Cartesian product to create a list of all dates

  17 Aug 2009

  Today's guest blogger is Access MVP Glenn Lloyd of Argee Services. Check out his Office help blog and Access Help and Tutorial Blog . In working with applications that require scheduling, I often find a need for a list of all calendar dates within a specified time frame. Using Cartesian Product makes...
• Using Access to Combine Excel Files: Method 1

  12 Aug 2009

  Excel MVP Michael Alexander wanted to share one VBA-free method that he uses to combine multiple Excel worksheets into one data set. Ahh, the classic story. Boy gets job. Boy becomes the department data collector. Boy meets 25 Admins who send him a spreadsheet every week. Boy copies and pastes into one...
• Put IIF statements in a table to use in a query

  11 Aug 2009

  Readers Trey Smith and Brandon Kessler from HealthTrans, LLC suggested the following Power Tip for streamlining Access queries. I ran into an issue at my job where I had so many IIF statements for a field in a query that the query wouldn’t run. We deal with many clients that all have different criteria...
• A pair of tips for working with queries

  6 Aug 2009

  Today’s Power Tip comes from Brandon with OpenGate Software, offering Microsoft Access products for Access users of ever experience level, including UI Builder , Designer , and Dashboard Builder for Microsoft Access. Here are two tricks in Access to make SQL easier.  The background context is that...
• Create partition queries

  29 Jul 2009

  Raymond Starkey, Director of ACCESSible IT Ltd. , provided us with an example that he has used to teach Access users about using the Partition function to create a frequency distribution. As he says, “no one ever mentions these but they are so powerful they need a mention.” Note:Raymond’s example uses...
• Submit your Power Tips!

  28 Jul 2009

  The Power Tips feature of the Access Team Blog has been running for about 3.5 months now, so we thought it’d be a good time to remind everyone how the feature works. What’s a Power Tip? A Power Tip can be a code sample, some SQL, an expression, a series of property settings, or some other Access trick...
• Return a Limited Number of Rows on a Criteria Form

  16 Jul 2009

  Today’s guest blogger is Alison Balter. Alison is the founder of InfoTech Services Group, Inc. and has authored 14 Access books since 1995. When working in a client/server environment, it is imperative that you limit the number of rows that the user brings over the network wire. It is therefore necessary...
• Group numbers into custom ranges

  2 Jul 2009

  I was looking at SQM data about file size last week and ran into an interesting question. We capture the size of the file every time Access opens the file in SQM. It is interesting data as it provides insights into the size of a typical existing app. I wanted to bucket the ranges into something more...