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 thing to know because SQL queries written this way can help you now in exactly the same way as it did for Peter and I working on projects in the last century. Article by Peter Vogel from 1997 When we...

I expect there are a number of folks that would love take Access Services for a spin and give us feedback. It is possible to create a dev install of SharePoint 2010 Beta 2 on Vista x64 or Windows x64. This is only intended for developers to develop custom solutions and isn’t a supported live scenarios. The document should list in step 2 to install Reporting Services and here is the download . There was a glitch publishing the RS MSI where some users were getting a 1 byte file—that has been fixed...

Today’s guest writer is Ric Lewis—the PM in charge of publishing to SharePoint. A common question in the Access community is “how do I get my app on the web?” Here is the most recent example : My wife and I have just started our own Recruitment business and I started an Access DB to basically be a contact manager and to track our jobs, candidates, clients and placements we make. I got to a certain point and realized I was out of my depth, so I enlisted the help of an Access Developer to finish it...

Recently on The Access Show Ryan and I introduced Access Services and created a donations application that ran in the browser. I thought it would be helpful to provide some background to the vision and direction. Years ago I came across a post on UtterAccess that articulately described what we hope to accomplish with Access 2010. Stormin on UtterAccess says he is: … looking for clues to how I could create an Access application that would run from within an Access database, as well as from the web...

Today, we are thrilled to announce the release of the public beta of Access 2010, Access 2010 Runtime, and SharePoint 2010. You can download Office and SharePoint at www.microsoft.com/2010 . My July post Access 2010--The 10,000 ft. View outlined the following advancements: Get started faster Better design and customization tools Centralized business logic Landing pad for data SharePoint performance and offline Browser apps Last month Ryan and I gave the first public demo on Channel 9 . If you haven...

Web databases introduced a few ribbon design challenges, particularly how to present client and web create options? We wanted to make sure that people creating client objects are just as successful as web objects. When you create a new database from scratch, you have two options: either to open a blank database or a blank Web database. Creating a new blank Web database opens a new database that allows you to create both Web and Client objects. Client objects have the full designers and ability to...

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. Also, we know that table and query fields have a Format property , where color formatting can be set. For example, you can format a number field as 0.00[Green]. As stated in Access 97,...

Today’s guest writer is Wouter Steenbergen, a PM on the Access team responsible for Access form and report designers. If you want to build an easy to use application it always starts with a good navigation model that allows users to quickly perform the most common tasks and easily find the less common tasks. Years ago, Access introduced the concept of a switchboard manager which has become a mainstay for many applications in the late 90’s. The hierarchical model and ease of adding new objects into...

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 more for descending order. A while ago I decided to tackle this feature in an Access form. The buttons above the field names are used to sort the list. The triangle pointing down means the column is...

Today’s guest blogger is Darren Myher.  Darren is the VP Operations of Blue Link Associates Limited , a Gold Certified Microsoft ISV Partner.  Blue Link’s flagship product: “Blue Link Elite” is a fully integrated accounting and inventory management system built using Microsoft Access and SQL Server. Darren has attended several of our developer kitchen events over the last couple of years. I liked his perspective about Access and asked him if he would share his experience with our audience...