Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Access Team Blog

Get product announcements, tips and tricks, and news directly from the team @ Microsoft.

September 2009 - Posts

Dynamically Resize a Subform Based on the Record Count
Today’s guest blogger is Vinny Malanga. Vinny is the CTO of IMI Software, Inc. , which specializes in software development for the real estate and property management industries. Many Access developers implement subforms to display data. Most often, at Read More...
Access 2010 Custom Themes
Today’s guest writer is Steve Greenberg. The recent Access 2010 Theme’s post introduced you to the new Office themes inside Access. Now let’s show you some of the advanced things you can do with themes. The controls we are about to use can all be found Read More...
Tracing Function Calls in VBA
Today’s guest blogger is Joel Graff. Joel is a field engineer with the Illinois Department of Transportation (IDOT) . Often, I find when looking for the source of an error in VBA code, a function call trace which returns the path of function calls preceding Read More...
Access 2010 Themes
Today’s guest writers are Steve Greenberg and Viki Selca. The PMs that have lead the effort to make it easier to create great looking apps. People say “Don’t judge a book by its cover” but everyone who develops software knows that applications are judged Read More...
Switch the Property Sheet on and off from VBA
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/ . When you open a form or report in Design View, the Property Sheet Read More...
SharePoint in Plain English
I thought this was a great way to communicate what is SharePoint: SharePoint in Plain English Read More...
Using VBA to Send Data to a Table from an Unbound Form Control
Today’s guest author is Justin Farrell, author of the Access 2007 tutorial http://www.dealing-with-data.net . This is a useful trick which gives the Access Developer additional flexibility when working with forms and data. It uses Access VBA and DAO. Read More...
"Convert" a TextBox to a ComboBox at a run-time
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/ . Some people do not like having ComboBoxes on a form because of drop-down Read More...
Access 2007 hotfix package now available
Here are the list of issues fixed in this download package . In Microsoft Office Access 2007, you have a report that includes a form reference in the criteria of the record source. When you enter a letter at the first parameter prompt, a numeric value Read More...
Use a validation rule instead of the Required property
Reader Štefan Masič provides today's Power Tip. When you want to require users to enter a value in a field, a common technique is to set the Required property for that field to Yes (for example, tabPerson.Name.Required = Yes). However, when the user is Read More...
Jump start new Access databases with a custom blank database template
Today's guest blogger is Access MVP Glenn Lloyd of Argee Services. Check out his Office help blog and Access Help and Tutorial Blog . There are certain features that virtually every Access database application includes. Certain tables like people’s names Read More...
Calculating Week Numbers is Easier Than He First Thought
Excel MVP Michael Alexander wrote in with a tip on calculating week numbers. It's always a little embarrassing when you roll your own Function to achieve some functionality that already exists in Excel or Access. Recently, I stumbled across a user-defined Read More...
Page view tracker