August 2009 - Posts
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
Read More...
Steve Bailey recently emailed us about changes to the SageKey product line and a special discount they are offering: SageKey Software has been busy building new products to provide the right solution to the common installation issues. As usual we’d like
Read More...
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
Read More...
Brandon from OpenGate recently sent email about a special offer for blog readers for the latest version of Designer for Microsoft Access. Check it out. OpenGate Software is offering 50% off their new version 3.0 of Designer for Microsoft Access .
Read More...
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
Read More...
Want to ensure your application runs seamlessly in Access 2010 and hang out with the Access team? We have a 3 day developer kitchen on the Redmond Campus from September 14-16 th . You will hear the product vision, run your applications in the latest builds,
Read More...
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
Read More...
Last week we outlined improvements to the Access 2010 macro designer , parameter support , and IntelliSense . These improvements build upon Access 2007 macro improvements of macro sandbox, embedded macros, TempVars, debugging, and support for error handling.
Read More...
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
Read More...
The Expression Builder sports new features and simpler UI in Access 2010. You will spend less effort thinking about syntax and available functions/properties because IntelliSense features provide all the information you need as you type. Expression Builder
Read More...
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
Read More...
A couple folks from Microsoft created a website where you can submit ideas for Office + vote and comment. There are only a couple listed for Access, I am sure you all have some great ideas :)
Read More...
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
Read More...
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
Read More...
