wordpress statistics
  • Today is Monday, February 6, 2012

About

Blog Author:

 

MsAccessTips.com

For learning advanced ms-access programming tips and tricks.

 

About MsAccessTips.com

Learn Mail Merge in MS-Access. Enhancing Forms with 3D Headings and Animated Controls. Advanced learning with easy to follow step-by-step examples and Program Codes. Learn MS-Access User-level Security implementation. Using Access in Internet.

Objective

Articles published on this website is intended for MS-Access Developers who look for better programming techniques, beyond the Fundamentals and Basics.

In the Tips and Tricks Section you will find hundreds of Articles on customized Form Designing, Animated Controls like Calendar, Dynamic Reports, manipulating Chart Objects with VBA, 3D Text Wizards that creates beautiful Form/Report Headings in seconds and so on.

Usage of Command Buttons in various ways like Command Button Animation, Double Action Command Button, Transparent Command Buttons and Colorful Command Buttons.

Usage of Office Assistant, in place of the static type MsgBox Control, incorporating Animations, Check Box Menus, Options Menus and displaying Company Logo or Greetings to the Users on special occasions like Christmas or Valentines Day across the Network.

Sending Alert Pop-ups (through NET SEND command) to Workstations to those who are waiting for information about completion of certain tasks done by one side of the Network so that others can continue updating the remaining part of the work.

These are some of the interesting and thought provoking ideas presented on the site. I am sure once you visit the site you will find lot more interesting ideas that you can use to improve your Projects to impress your customers.

Regards, a.p.r. pillai

Contact:aprpillai@msaccesstips.com

2 Responses to “About”

  1. Rob says:
    August 4, 2010 at 8:21 am

    Hello,
    I was trying to learn form one of your tutorials. The page is formatted in such a way that not all of the code that you instruct to copy is available. Can you please get me the rest of the code?
    The page in question is http://msaccesstips.com/2008/03/refresh-dependant-combo-box-contents/ about 1/2way down the page. If you could provide the rest of the code, I would be very greatful.

    Thanks for providing your assistance.

  2. a.p.r.pillai says:
    August 4, 2010 at 2:29 pm

    The full code is given below:

    Private Sub cboCat_Click()
    Dim xsql0 As String, xsql2 As String, xsql As String
    Dim crit As String

    xsql0 = "SELECT DISTINCTROW [ProductID], " & "[ProductName] FROM Products WHERE ("
    xsql2 = " ORDER BY [ProductName];"
    crit = "[CategoryID] = " & cboCat & ") "
    xsql = xsql0 & crit & xsql2

    Me.ProductID.RowSource = xsqlMe.ProductID.Requery
    End Sub

    I suggest you please post your queries on the same page where you faced the problems.

    Thanks.