How to create your own VB add-in features

How to create your own VB add-in features

Visual Basic Programmers usually create add-ins because they feel short of features when working with Microsoft tools or it seems at times that Microsoft hasn't yet developed the tool we need.
Obviously, Microsoft can't design features to fulfill each and every programmer needs, so it made Visual Basic (VB) an extensible product, thereby providing the way for VB developers to create their own add-in features.
Here's some samples, tools and how-to articles to help you create your own Visual Basic Add-in project.
  1. Visual Basic Add In Tips & sample code
  2. Free Visual Basic Refactoring Add-in for Visual Studio Developers
  3. How To Create a Visual Basic Automation Add-in for Excel Worksheet Functions
  4. Points to take care with Visual Basic Add-In
  5. Multi-Language Add-In for Visual Basic (shareware)
  6. Success writing a Visual Basic add-in for MCE! (thegreenbutton forum)
  7. Code Template Add-In for Visual Basic Version 2.0
  8. Visual Open Project Add-In.
    Add-In for Visual Basic 6.0 that allow easy and quickly open Your projects.
  9. Context! VB 1.0. (shareware)
    A Visual Basic Add-In which has been designed to short-cut the process of developing context sensitive popup help forVisual Basic 5 and 6 applications.
  10. Visual Basic 6.0 Procedure Sort Add-In.
    The Procedures Sort Add-In is a great add-in for those who like well-organized code. You can use it to sort your procedures in the active CodeWindow alphabetically. It preserve all you procedure attributes, which you normally loose when you do it manually. Event-handlers and Interface-implementations will be placed at the end of your code.
  11. Creating a Text-to-speech add-in for Microsoft Word 2007 with Visual Studio 2008

Useful tips to secure your SQL Server

Useful tips to secure your SQL Server

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL with it's most popular version Sql server 2005.

You can determine what version SQL Server is running by running:

Select @@version (Where @@Version is a system level variable that holds the current version).

How do I restict clients by IP Address?

As the SQL Server has no built-in support for restricting clients by IP address, the most common work-arounds are firewalls, IPSec, or third-party network layer filters to allow only certain source IP addresses and target TCP ports (the port on which SQL Server is listening).

What are some things I can do to secure my SQL Server?

- Keep up to date on SQL Server service packs and patches
- Audit SQL Server accounts for weak passwords
- Restrict access to the SQL Server to only trusted clients
- Use Windows Only authentication where possible
- Store SQL Server backup files in a secure location and encrypted
- Disable all netlibs if the SQL Server is local-only
- Regularly scan the installation with Microsoft's Baseline Security Analyzer

How to applying SQL Server Service Packs


Giles is a Sketch Artist, Asian Blogger and loves SQL Servers.
Article Source: Free Article Directory - Search And Submit Articles

The Growing Trend Of A Computer Programming Degree

Computers and the Internet have streamlined their way into the homes of people all over the world. Currently, more than three-quarters of homes in the United States have a computer. The abundance of computers all over the nation provides numerous career opportunities and degree programs associated with technology. One program that has become more and more popular since the boom of the computer is a computer programming degree. Gaining a degree in this program offers benefits such as being able to work from home and job security, which is an important benefit in any career field.

In 2006, CNN Money named software engineers as the number one job in the United States. The reason why software engineering is a huge career field is due to the fact that practically every part of the business world is in need of software engineers. From financial establishments to institutions of higher education, many organizations house their own Information Technology department raising the need for individuals who are knowledgeable in computer programming.

Computer programming goes far beyond the basics of normal computer programs. Knowledge in math and problem solving are key elements to being a successful computer programmer, along with more advanced and intricate computer skills. These skills are enforced through a series of classes and course work that emphasizes the importance of problem solving and math in the technology world. These skills are important due in part to the fact that in computer programming, there is no set of guidelines to follow when trying to correct a problem. Therefore, computer programs are required to analytically evaluate a situation to come up with the best possible solution to fixing the problem. Receiving a computer programming degree will give students these important skills to become successful software engineers and computer programmers.

There are many different sides to computer programming, such as Internet applications, databases and networks that students must learn while receiving a computer programming degree. Through course work, students will learn to design and implement popular web applications, such as Microsoft Visual Basic, Microsoft Visual C# and Java. Students will also learn analyzing, designing, building and implementing database-driven websites. Knowledge in these subject fields, along with analytical and mathematical skills combine to give students the experience and confidence they need to be successful in the computer programming world.

Along with the technical aspect of this career field, a computer programming degree also offers course work in different areas. These courses include education, communications and science among other areas of interest. Course work associated with a degree in computer programming offers the foundation for a well-rounded education. Not only will students be well versed in designing computer programs and following them through to implementation, but they will also learn to clearly communicate with their colleagues and explore different career fields made possible by a degree in computer programming.

Along with obtaining a computer programming degree, students following a computer programming curriculum will be given the tools necessary to complete required exams. These exams include becoming a Microsoft Certified Professional as well as a Microsoft Certified Application Developer. Successfully completing these exams opens a door for an endless amount of career opportunities upon completion of the degree. If an individual is interested in the Internet, website development may be the perfect job. On the other hand, if a student is more of an individual and interested in creating a computer program from scratch they would find working as a program developer more fascinating. There are endless possibilities once an individual receives their degree, and whatever their passion may be, there is a job out there for everyone.



About the author Andy West is a freelance writer for Virginia College. Virginia College offers many courses to help you obtain your Computer Programming Degree. Please visit Virginia College at http://www.vc.edu/site/program.cfm?programID=16 to select the program that is right for you. Source: Article Maniac Free Article Directory

15 Stretegies for enhancing your memory

Dr. Thorne is the clinical director at the Center for Development and Learning (http://www.cdl.org/) a nonprofit organization that specializes in the development and dissemination of research, knowledge, and best practices that impact teaching and learning.

The following strategies are offered to help students develop a more efficient and effective memory. I think this is very useful whether you are student or not. This listing is by no means exhaustive, but rather is meant as a place to begin.

1. Take the mystery away.

The first and perhaps most important strategy is to insure that all students understand how memory works and identify their particular profiles of memory strengths and challenges. Then, students should be taught memory management strategies.

2. Give directions in multiple formats.

Students benefit from being given directions in both visual and verbal formats. In addition, their understanding and memorizing of instructions could be checked by encouraging them to repeat the directions given and explain the meaning of these directions. Examples of what needs to be done are also often helpful for enhancing memory of directions.

3. Teach students to over-learn material.

Students should be taught the necessity of "over-learning" new information. Often they practice only until they are able to perform one error-free repetition of the material. However, several error-free repetitions are needed to solidify the information.

4. Teach students to use visual images and other memory strategies.

Another memory strategy that makes use of a cue is one called word substitution. The substitute word system can be used for information that is hard to visualize, for example, for the word occipital. These words can be converted into words that sound familiar that can be visualized. The word occipital can be converted to exhibit hall (because it sounds like exhibit hall). The student can then make a visual image of walking into an art museum and seeing a big painting of a brain with big bulging eyes (occipital is the region of the brain that controls vision). With this system, the vocabulary word the student is trying to remember actually becomes the cue for the visual image that then cues the definition of the word.

5. Give teacher-prepared handouts prior to class lectures.

Class lectures and series of oral directions should be reinforced by teacher-prepared handouts. The handouts for class lectures could consist of a brief outline or a partially completed graphic organizer that the student would complete during the lecture. Having this information both enables students to identify the salient information that is given during the lectures and to correctly organize the information in their notes. Both of these activities enhance memory of the information as well. The use of Post-Its to jot information down on is helpful for remembering directions.

6. Teach students to be active readers.

To enhance short-term memory registration and/or working memory when reading, students should underline, highlight, or jot key words down in the margin when reading chapters. They can then go back and read what is underlined, highlighted, or written in the margins. To consolidate this information in long-term memory, they can make outlines or use graphic organizers. Research has shown that the use of graphic organizers increases academic achievement for all students.

7. Write down steps in math problems.

Students who have a weakness in working memory should not rely on mental computations when solving math problems. For example, if they are performing long division problems, they should write down every step including carrying numbers. When solving word problems, they should always have a scratch piece of paper handy and write down the steps in their calculations. This will help prevent them from loosing their place and forgetting what they are doing.

8. Provide retrieval practice for students.

Research has shown that long-term memory is enhanced when students engage in retrieval practice. Taking a test is a retrieval practice, i.e., the act of recalling information that has been studied from long-term memory. Thus, it can be very helpful for students to take practice tests. When teachers are reviewing information prior to tests and exams, they could ask the students questions or have the students make up questions for everyone to answer rather than just retelling students the to-be-learned information. Also, if students are required or encouraged to make up their own tests and take them, it will give their parents and/or teachers information about whether they know the most important information or are instead focused on details that are less important.

9. Help students develop cues when storing information.

According to the memory research, information is easier retrieved when it is stored using a cue and that cue should be present at the time the information is being retrieved. For example, the acronym HOMES can be used to represent the names of the Great Lakes – Huron, Ontario, Michigan, Erie and Superior. The acronym is a cue that is used when the information is being learned, and recalling the cue when taking a test will help the student recall the information.

10. Prime the memory prior to teaching and learning activities.

Cues that prepare students for the task to be presented are helpful. This is often referred to as priming the memory. For instance, when a reading comprehension task is given, students will get an idea of what is expected by discussing the vocabulary and the overall topic beforehand. This will allow them to focus on the salient information and engage in more effective depth of processing. Advance organizers also serve this purpose. For older students, CliffNotes or other similar study guides for pieces of literature are often helpful aids for priming the memory.

11. Use Post-Its.

The use of Post-Its for jotting down information can be helpful for students who have short-term memory or working memory challenges.

12. Activate prior knowledge.

In order to enhance the likelihood that students will elaborate on new incoming information, teachers should activate their prior knowledge and make the new information meaningful to them. An easy way of accomplishing this task is to ask, “What do you know”, “What do you want to know”.

13. Give extended time.

If students have difficulty with the speed of retrieving information from memory, they should be given extended time for taking tests so that a true picture of what they know may be gained.

14. Use multisensory methods.

When learners, both young and old, experience something through multiple senses, they are much more likely to remember it. Use a Multisensory approach by engaging as many of the senses as possible when teaching (seeing, touching, hearing, smelling, and tasting).

15. Review material before going to sleep.

It should be helpful for students to review material right before going to sleep at night. Research has shown that information studied this way is better remembered. Any other task that is performed after reviewing and prior to sleeping (such as getting a snack, brushing teeth, listening to music) interferes with consolidation of information in memory.

Gadwin Prinscreen, tools to create screenshots and print easily

Gadwin PrintScreen, a tool that makes possible to create screenshots that can be easily saved or printed in just a single keystroke.
Capture portions of a screen, save it to a file, copy it to Windows clipboard, or send it through email with very less efforts when you use this tool. This tool can instantly capture screens and create screenshots suitable for saving or printing. The useful tool comes to use when you would like to; display your product on the web, enhance technical or sales documents, and make your presentations bolder by adding capture.
It is also capable to capture and print or save computer screen data. The other features include; supports numerous hotkey combinations, the utility allows you to directly copy the screen to the clipboard, allows to capture full screen, or capture a specific window, supports six different image formats, and much more.
The must have utility is compatible with Windows 98/Me/2000/2003/XP/Vista, or Windows NT 4.0SP6.

Download Gadwin Printscreen
Visit Publisher Website
Free VB Tools Installation Package

Free VB Tools Installation Package

Install Simple is a very compact (60 KBytes) and powerful program to build your Installation packages in seconds instead of hours!

Setups are packed into single exe-file for easy distribution.
The extractor module has extremely small size (only 13 KBytes overhead over compressed data size). Using a very practical and intuitive assistant, you can establish parameters for the installation process of your product for any Windows platform.
It's designed for anyone who distributes applications, data files, graphic images or whatever else you want to distribute!

SYSTEM REQUIREMENTS:
1. PC compatible Pentium 60 processor or faster system
2. Windows 95/98/ME/NT/2000/XP/2003/Vista
3. 4 Mb RAM or higher

Download InstallSimple 1.35
Visit Publisher website

Copyright (c) 2007-2008, Russian New Logic. All rights reserved.
Add Explorer Style Rename Capability to TreeView Control

Add Explorer Style Rename Capability to TreeView Control

Q192170
The information in this article applies to:
- Microsoft Visual Basic Learning Edition for Windows, versions 5.0, 6.0
- Microsoft Visual Basic Professional Edition for Windows, versions 5.0, 6.0
- Microsoft Visual Basic Enterprise Edition for Windows, versions 5.0, 6.0
--------------------------------------------------------------------------------

SUMMARY
The following procedure can be used to edit the node name on the TreeView side of the Windows Explorer:

- Click on a node with focus to place it in edit mode.
- Remove all the text from the Node label.
- Move focus to a different Node.

You receive the following error message:
You must type in a file name.
Focus returns to the Node you were editing and you remain in edit mode.
If you hit the Esc Key, the original text is placed back in the Node label.

MORE INFORMATION
This sample demonstrates how to achieve the same effect using the TreeView control in Visual Basic. It also shows how to verify that when a user edits a Node label that it is not left blank.

Step-by-Step Example
Create a new standard EXE project. Form1 is created by default.
From the Project menu, select Components, check "Microsoft Windows Common Controls 6.0," and then click OK.

Add a TreeView and Timer control to Form1.
Add the following to the code window of Form1:

Option Explicit

Dim sNodeText As String ' to hold the node text

Private Sub Form_Load()
'Add some nodes to the TreeView
TreeView1.Nodes.Add , , , "test"
TreeView1.Nodes.Add , , , "test 1"
TreeView1.Nodes.Add , , , "test 2"
End Sub

Private Sub Timer1_Timer()
' Put the TreeView in edit mode
TreeView1.StartLabelEdit
Timer1.Enabled = False
End Sub

Private Sub TreeView1_AfterLabelEdit(Cancel As Integer, _
NewString As String)
' Make sure that we have a value in the Label
If Len(NewString) < interval =" 100" enabled =" True"> 0 Then
sNodeText = TreeView1.SelectedItem.Text
End If
End Sub

Private Sub TreeView1_KeyUp(KeyCode As Integer, Shift As Integer)
' If the user hits the Esc key then restore the old label
If KeyCode = vbKeyEscape Then
TreeView1.SelectedItem.Text = sNodeText
End If
End Sub

Save and run the project. Click on a Node to select it, then click on it again to place it in edit mode.
Follow steps as described in the Summary above. When you hit the ESC key, you will see that the old value for the Node label has been restored.

(c) Microsoft Corporation 1998. All Rights Reserved.
Contributions by Brian Combs, Microsoft Corporation.

Additional query words: kbDSupport kbDSD kbVBp kbVBp500 kbVBp600 kbCmnCtrls kbTreeView
Keywords : kbGrpDSVB
Issue type : kbhowto
Technology : kbVBSearch kbAudDeveloper kbZNotKeyword6 kbZNotKeyword2 kbVB500Search kbVB600Search kbVBA500 kbVBA600 kbVB500 kbVB600

MD5 Hash Calculator Module for Vb6

MD5 Hash Calculator Module for Vb6

MD5 calculator is a simple application which will calculate the MD5 hash of a given file. Can be used with big files (some GB). It features a progress counter and a text field from which the final MD5 hash can be easily copied to the clipboard.

MD5 Hash Calculator implemented for VB6 (Module). You can add the module to your project with easy step:

MD5 API

1. Check if the dll is on System or System32
2. if Not then do the following steps:
  • Copy the file to your windows\system directory.
  • Do NOT Register the DLL
Download MD5 Hash Calculator for VB6