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 design time, the developer sets the subform to a specific size. In many cases this is fine, but there are some instances where it would be preferable to dynamically resize the subform at runtime, based on the number of records that it contains, up...

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 to the left of the Design tab once you’re designing a form or report in design or layout view. In addition to using the out-of-the-box themes, you can also create your own themes. On the Design tab, choose Fonts | Create New Theme Fonts or Colors ...

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 the error to be invaluable. While more complete compilers provide this feature as a part of the IDE, it is, unfortunately, absent in VBA. To accommodate this, I’ve written my own function call stack classes to help me trace errors. This implementation...

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 by their look and feel every day, and for good reason. It’s critical to keep the user interface clean so that end users of the application can get their work done without fuss. If you depend on Access as a key part of your business, the difference...

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 is either displayed or hidden based on its state the last time you left Design view. However, you might want to ensure that the Property Sheet is always displayed (or hidden) when you switch to Design view. You might think to use the following command...

I thought this was a great way to communicate what is SharePoint: SharePoint in Plain English

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. Once the user enters data into the unbound textbox ( txtBox ) and clicks the Send Data To Table button, Access opens a recordset based on the tblTest table. The txtBox data is then stored in a variable called varTextData and then added to the rst recordset...

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 buttons. Microsoft offers a solution here , but this approach does not work for a datasheet view – the drop-down button shows up when the ComboBox gets the focus. Some people do not like ComboBoxes because the control requires some time to be...

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 is displayed on the report. For example, if you enter the letter "a" at the first parameter prompt, the value "97" is displayed on the report. In Access 2007, you have a form or a report that is bound to a SQL Server stored procedure...

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 then adding records to the table and neglects to insert value in that field, the built-in error message that appears is not very helpful: "The field <TableName>.<FieldName> cannot contain Null value because the Required property is...