Access

Access 2010: How to write expressions for Web queries, forms, and reports

Before Access 2010, Access supported a wide variety of expressions in different areas of the application.  Tables and fields, queries, form and report properties, controls, and macros can all use expressions to evaluate data or logic to drive the behavior of an application. In the past, each of these contexts in which an expression is used have shared a single, common expression evaluation engine. This means that no matter where…

Access

Q&A with Access developer Juan Soto

Working in an ice cream factory in Chicago led Juan Soto to found IT Impact, Inc.,  an Access development consulting firm. The ice cream 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 the waste for every step of the manufacturing process and soon realized that he could automate the…

Access

How to save your Access SharePoint password

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 of screenshots) that we’d like to share with you.  ITImpact has been building custom databases with…

Outlook

Share your Outlook calendar: Your time is my time

There are three different ways in which you can share your Outlook 2010 calendar: By email, where your calendars can arrive in your recipient’s inbox as an attachment, and with a “Calendar Snapshot” in the body of the message, With Exchange Server, where you and others using Exchange and can share calendars and manage permissions, too. By sharing your online, Outlook Hotmail Connector-synchronized calendar with whomever you want. It just depends on what…