Browse by Tags
All Tags »
Power Tips (RSS)
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...
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...
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...
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...
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...
Excel MVP Michael Alexander wanted to share this tip about running an Access parameter query from Excel. He describes the problem thusly: An Access parameter query is a kind of interactive query that prompts you for criteria before the query is run. Parameter
Read More...
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/ . If you have a form that contains subdatasheets, you can use the following
Read More...
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. I have been using the ribbon for
Read More...
Today's guest blogger is Access MVP Garry Robinson, who offers the Smart Access collection of articles at http://www.vb123.com/kb . A few months ago I purchased the rights to publish the Smart Access magazine online and it is from that collection that
Read More...
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...
MSDN writer Sal Ricciardi alerted us to the availability of 3 new articles on MSDN, two written by Luke Chung of FMS Inc. , and one co-written by Luke Chung and Dan Haught. Title Author(s) Performance Tips To Speed Up Your Access 2007 Database Luke Chung
Read More...
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...
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...
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...
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...
