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.

Browse by Tags

All Tags » Form   (RSS)
Add color formatting to columns in Combo Boxes and List Boxes
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 Read More...
Sorting a Listbox Using Command Buttons
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 Read More...
Displaying Data From Related Tables on a Form
Today's guest blogger is Access MVP Scott Diamond. Scott is the principal of Diamond Computing Associates and the author of Microsoft Office Access 2007 VBA . This is a very frequently discussed issue. But before I get into the methods, you need to understand Read More...
A better way to reference tab control pages
In VBA, a common way to refer to the pages of a tab control is to use the Value property. However, Luke Chung, President of FMS Inc., recommends using the PageIndex property instead. Click here to find out why! Send your Power Tips to Mike and Chris at Read More...
Convert hexadecimal color codes so you can use them in code
Today's guest blogger is Michael Merlin, Lead Software Developer at Electronic Communities . I recently wasted an hour trying to set a field's Back Color property to the hex code generated by the color picker. I figured it out after some searching, but Read More...
Identifying the Record Selected on a Continuous Form
Today’s guest blogger is Edwin Blancovitch. Edwin is president of Advanced Developers.net , creators of Easy Payroll , a software package to manage your human resources, payroll, scheduling, time and attendance needs. Regularly when we create databases Read More...
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...
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...
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...
Cool Tool Tips: A Better Control Tip
Tony D'Ambra of aadconsulting.com , maker of Access add-ins and switchboards, wanted to share his method for providing help to users when and where they need it. In Access, the functionality of tool tips has not changed since they were introduced in Access Read More...
Return a Limited Number of Rows on a Criteria Form
Today’s guest blogger is Alison Balter. Alison is the founder of InfoTech Services Group, Inc. and has authored 14 Access books since 1995. When working in a client/server environment, it is imperative that you limit the number of rows that the user brings Read More...
Sample Class Eases Creation of Similar Forms
Last week Joel Graff shared his story on how he used Access to track salt usage for the Illinois Department of Transportation. Some of you wanted to know more about the custom class that he uses to ease the creation of similar forms. Joel has agreed to Read More...
Access Proves “worth its salt” for IDOT
Today’s guest blogger is Joel Graff. Joel is a field engineer with the Illinois Department of Transportation (IDOT) . He’s sharing how he utilized Access to prove the efficiency of their drivers and equipment in managing winter road conditions. This last Read More...
More Posts Next page »
Page view tracker