Access Blog

How to save your Access SharePoint password

Emily Warn — Thu, 26 Jan 2012 16:52:00 GMT

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 Microsoft Access since 1994, serving customers around the world. Ben Clothier has been Microsoft...(read more)

Display real-time information with the ControlTip Property

Steven Thomas — Mon, 28 Nov 2011 19:00:00 GMT

The ControlTipText property is usually associated with providing static information. But it can also be used to display real-time info in a wide range of scenarios.

...(read more)

An Updated Data Model Has a Choral Arts Group Singing

Steven Thomas — Mon, 21 Nov 2011 19:00:00 GMT

When Donna took on the role of Director at Choral Arts (a non-profit singing ensemble), she inherited a disorganized database with redundant, unreliable data. We helped Donna devise a data model and import her data into a new set of normalized tables.

...(read more)

Full-featured Access Services solution at http://www.accesshosting.com

Steven Thomas — Mon, 14 Nov 2011 19:00:00 GMT

Our good friends at accesshosting.com are offering 30-day trials of two Access "cloud" solutions. Curious? Here's the deal...

...(read more)

Ways to use Access data in Excel

Steven Thomas — Thu, 06 Oct 2011 18:00:00 GMT

When you need to use Excel to analyze data in an Access database, you have several options: you can copy and paste the data, create a data connection from Excel, or export the data to an Excel file. Your best choice depends on what you want to do. Copy/Paste If you just need some values from Access one time -- and you don't care whether the data changes in Access later on -- copy/paste is a quick and dirty way to get the job done. Export If you don't care whether the data changes but expect to get...(read more)

Date functions part 1: some common scenarios

Steven Thomas — Thu, 15 Sep 2011 18:00:00 GMT

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 post we'll consider each of those scenarios and see how a date function can do the job.

...(read more)

Reader Poll: what would you like to see on the Access Blog?

Steven Thomas — Thu, 08 Sep 2011 18:00:00 GMT

I created an online poll to find out what you think this blog should feature.

...(read more)

Query Criteria Part 3: prompting for input by using a parameter

Steven Thomas — Thu, 01 Sep 2011 18:00:00 GMT

In part 2 of this series, we considered using LIKE and wildcards in query criteria to find inexact matches. Good stuff - but what if you could get the query to apply criteria that are supplied when it is run? What if you could make a query ask for input? Good news! You can make a query ask for input, and it's actually very easy.

...(read more)

Query Criteria Part 2: Like what?

Steven Thomas — Thu, 18 Aug 2011 18:00:00 GMT

Access has powerful tools that you can use in query criteria to retrieve inexact matches: wildcard characters, and the LIKE operator.

...(read more)

Query Criteria, Part 1: Be specific!

Steven Thomas — Thu, 11 Aug 2011 18:00:00 GMT

Queries are a fundamental part of any database: among other things, they are the way you ask questions about your data. If you think of a query as a question, query criteria are your way of making the question as specific as possible. So a question like "What are my contacts' birthdays?" can be more like "Whose birthdays are coming up next month?"

...(read more)