Browse by Tags
All Tags »
Code (RSS)
We received a question the other day from someone who was using the Shell function in VBA to run a command in a command prompt. The command in question was netsh dhcp , but this could apply to any number of commands. The original code was as follows:
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...
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 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...
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...
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...
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...
Today’s guest blogger is Michael Groh, co-author of the popular Access 2007 Bible . The VBA language is not, by default, case-sensitive. A statement such as CBool("XYZ" = "xyz") will always return True. You might come across
Read More...
Sal Ricciardi of the Access Developer Documentation team has produced a couple of articles for MSDN that address two commonly-asked date-related questions about Access: Using Excel Date Functions in Access 2007 shows how to use Excel’s NETWORKDAYS function
Read More...
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...
