Microsoft Access
Sneak Peek of SharePoint 2010 and Access Services from WPC09
Wow, these video demos keep getting better and better as Day 1 of WPC09 moves along. Here is another clip of how Access is going to directly tie in with SharePoint 2010 via Access Services.
From the demo it now looks like you can create an Access form in the client application and publish that up [...]
Making Date Fields Optional in Access Queries
If you would like to give a person optional choices in a date parameter, and don’t want to use if statement logic, the NZ function is the way to go. Recently in Access, I had to write a query that was getting criteria from a form called frmChoice. I wanted to give my database user [...]
A Better Way to Create Lookup Fields
You might be tempted, when thinking about creating a Lookup field in Microsoft Access, to use the Wizard.
Don’t.
It involves too much cleanup work after you are done. For example, if you use the Lookup Wizard, you must destroy any existing relationship between the two tables. During the running of the wizard, you will see a [...]
Can You Wrap Text in an Access List Box?
Recently I was asked if you can wrap text in a list box on an Access form. The short answer is no.
However, you could try putting an unbound text box near the list box. In the text box properties set the Control Source to point back to the list box property. In the image below, [...]
Benefits of Training
People are either thrilled or upset when their company tells them they have to attend a training. I do understand that when you are already very busy, it just makes your day more stressful to be away from your desk for several hours. BUT, when you take the time to learn the most efficient way [...]
Using form value to run a query (or report)
Access queries are a wonderful way to extract specific information out of your database. You can run the same query over and over, but if you want different information, you need to reconfigure the criteria on your query. You can create a Parameter query, which displays a dialog box prompting you for the criteria value, [...]
Access - Removing Those Pesky Duplicate Records
If you find duplicate records through a query, the next logical step is to delete them. However, the number of records to be deleted can run into the hundreds, or even more. Manual deletion of these records would be impractical because of the time involved. And you can use an Access trick to remove duplicates [...]
Access - The Easiest Way to Create a Unique List…..
in a drop-down, or combo box. Here’s the problem: You want to create a drop-down list of all current possibilities in a field. For example, you want to create a list of all the states in which you currently have customers. You don’t want a list of all 50 states. You don’t want a list [...]
Access 2007 - Why Can’t I Arrange My Fields On A Form?
You’ve created an access form in Office 2007 by clicking on the Create Form button. All the fields are the same width. Now you want to make one a bit narrower. But when you select it and drag the side, all the fields get narrower. How do you change the width of one field?
When you [...]
Eeeek - another acronym ? DDPS and SAM…
That’s all that technology professionals need, another acronym to learn… more importantly, even when we know the acronym, what is the concept behind it ? DDPS stands for Desktop Deployment Planning Services, yet another service offering from Microsoft that provides software versioning migration planning and SAM (that’s Software Asset Management) as a component [...]
