Get the VBCode Collection on CD

Koleksi lengkap VB project bermacam aplikasi sebagai referensi belajar, dengan fasilitas Program penyimpan koleksi code, disusun berdasarkan folder yang dapat ditambah sesuai keperluan, fungsi tambah, edit, hapus data.
PLUS fasilitas searching sample code dari 18.464 file koleksi sample code untuk bermacam aplikasi.
Dipandu langsung oleh Mbah Merlin (Utusan Khusus dari Microsoft Agent :-)... )

Packing: 1 C CDROM
Total Folder: 26
Total size: 536MB
Total File: 18.464
Total VB Project: 649.

Dapatkan dan miliki Jajanan Awet ini. (Solusi Belajar & Menambah wawasan skill programming VB).

SMS pesanan ke: 0813-9844-9733

MP3Timer

MP3-PizzaTimer is an easy to use Timer that counts down and plays your favourite music to remind you.

MP3-PizzaTimer is so tiny and usefull that you will not want to miss it!

Download here (627kb)

Add/Remove v1.00

Add/Remove is a prank program that makes it appear that all of your software on your computer is being removed using the Windows Add/Remove Program feature. This gag is so real, it will shock the most experienced user.

If you are looking for a great gag to play on someone, this prank is a must download. It is so realistic, because it displays all of the software that is installed on the computer it is ran from.

When you first run Add/Remove there is no other option but OK, and as soon as you click on that the fun begins. Download Add/remove today!


Download here

Download other products like Add/Remove from www.rjlsoftware.com

AdvSysTray VB Class

AdvSysTray creates system tray (or "taskbar", like Microsoft calls it) icon.
Its code was used in PopOops. Class correctly works in all versions of Windows.
In systems with Shell32.dll 5.x or later AdvSysTray shows balloon tooltips. Demo project is included.
Download AdSysTray (9kb)

visit gasanov.net for more free samples VB.

VB code for automatic replacement of wallpaper

Visual Basic programmers are offered guidelines to develop code for automatic change of Windows Desktop styles.
The guidelines provide step-by-step instructions to develop an installer, a wallpaper handling module, as well as discuss the program's possible applications - in particular, for Web promotion. The guidelines are designed for entry-level programmers.

Download Complete Tutorial
by. wallpaper.oflameron

VB To SQL Server Client Shell Program 1.1

If your learning or programming SQL Server with Visual Basic front ends, this program is for you!
Save a ton of hours programming the login and interfacing front end to SQL server, and concentrate on writing the application!
This program is a complete front end for you to use with Visual Basic 6.0 to SQL server 7.0 or 2000, and is perfect if you are starting to program on SQL server, or write utility programs or projects.
If your just learning to code VB programs, this program will help you get up to speed quickly, and learn by example. All the hard work is done, you have a MDI form project, login screen, Error display screen and also a demo query/grid output screen for a example on using ado connections to load flex grids, with a sql query!

Download VBtoSQLClientDemo.zip

Create a Standard Windows DLL in VB

It is generally said that a "standard" DLL with exported functions cannot be made in VB. In fact, it only requires a simple process of hooking into the linker command line at compile time, in order to tell VB to add extra functions to the export table.

Thank you to Ron Petrusha for this. Although creating a standard DLL (or controlling the compiler switches generally) turns out to be an extremely simple task, it is not at all an obvious one.

Download vbdll.zip (22kb)

fullnotes: jsware

HTTP UserControl for File Download

This is a UserControl for downloading files via HTTP. It uses Winsock1.1 (wsock32.dll) for functionality, making it compatible with all versions of Windows from Win95 up. The only dependency is the VB6 runtime. You don't need to bother with the Winsock OCX or check the installed version of IE.

This UC is fairly basic. It starts Winsock, connects to a server, requests a file, and handles the download. Server response codes and redirect info. (if any) are also retrieved with the file, and there are functions to write text and binary files to disk after download.

Download httpuc.zip (12kb)

fullnotes: jsware

Zip file using Access VBA and WinZip

Here I will show you a simple way to add a file to a zip file using Access VBA and WinZip:

Call ZipFile_FX("c:\a.zip", "c:\a.xls")


Private Sub ZipFile_FX(ZipFileName As String, fileToBeZipped As String)

Const ZIPEXELOCATION = "c:\program files\winzip\winzip32.exe"

Shell ZIPEXELOCATION & " -a " & Chr(34) & ZipFileName & Chr(34) & _
" " & Chr(34) & fileToBeZipped & Chr(34), vbNormalFocus

End Sub

Command line parameters for WinZip

Winzip is one of the most popular programs on the planet and if you want to automate it, they recommend upgrading to Winzip Pro and installing the free command line utility. If you want to try command line parameters without upgrading to Winzip pro, try the commands on this page using Windows Start then the Run text box. Read more here

Author Bio.

Garry Robinson has been involved in over a 100 Access projects, edits his companies web site at http://www.vb123.com/ and is a contributing editor to the Smart Access magazine. When Garry is not sitting at a keyboard, he can be found playing golf or swimming down at his local Sydney beach. Contact details

or you can download this sample by. Albert D. Kallal

How Do You Fix A Corrupt Access Database ?

Every now and again our customers and even members of my team run into an Access database that is corrupt. Our usual approach is to stubbornly try and fix the database ourselves and generally we are good at doing this.
Early in May, 2005, when we were battling with a database, I concluded that we were wasting too much time trying to fix our databases. After a lot of research, we teamed up with one the best repair companies on the web to bring you this unique automated repair service.

Read page on common Access corruption symptoms
Start the repair service now


Relates pages:

Find a list of database corruption problems and symptoms here and here
Backups and recoveries page
Uncorruption page - plenty of options here

fullnote: vb123.com

URLLink - Simply URL control demo program

This example program demonstrates how to automatically load a user's web browser and point it to a particular web site. The URL can also be a data file that has an extension that has been registered by an application on your system. The appropriate application is automatically loaded with the specified data file or URL.
The code is implemented as a simple control. The text (which can be different from the actual URL) is displayed with an underline and the mouse pointer changes to a hand when it is over the text. The URL property specifies the URL or data file that is loaded when the text is clicked. If the ShowToolTip property is true, a tooltip with the underlying URL is displayed when the mousepointer is parked over the text.
The only event, GoToURL, gives you a chance to change the URL or cancel altogether after the text is clicked.

Download source code here

Author:
SoftCircuits Programming
http://www.softcircuits.com
P.O. Box 16262 Irvine, CA 92623

Ebook VB

Learning Visual Basic (Ebook) :

• Visual Basic 2005 Express Edition For Dummies Dec 2005 eBook-DDU.pdf
• Visual Basic 2005, a developers notebook.chm
• Visual Basic 2005 Cookbook
• OReilly.Visual.Basic.2005.in.a.Nutshell.3rd.Edition.Jan.2006.chm
• Excell VBA Programming (10,024KB, zip)
  

File Hosting powered by 4Shared.com

Freelance Projects

Follow these 3 easy steps to become a freelancer:

1. 1. Sign up as a freelancer
   
2. 2. Setup your PayPal Account to receive your payment
3. 3. You can start work and get hired by bidding the Open Projects below (update daily).

Latest Project by Jobs:

.NET, Accounting, AJAX, ASP, Audio Services, Banner Design, C/C++, Cold Fusion, Copywriting, Data Entry, Data Processing, Delphi, Electronics, Engineering, Excel, Flash, Graphic Design, Handheld / PDA, J2EE, Java, Javascript, Joomla, JSP, Legal Advice, Link Building, Linux, Logo Design, Market Research, OsCommerce, Perl/CGI, Photography, Photoshop, PHP, Project Management, Proofreading, Python, Ruby/Ruby on Rails, Script Installation, SEO, System Admin, Telemarketing, Training, Translation, Video Services, Virtual Reality, Visual Basic, Web Promotion, Website Design, Website Security, Windows, Wireless, XML

Sign up Now:

API call to make window "Always on top" attribute

SetWindowPos() is not the most obvious API call, but it is the one to use.

SetWindowPos( hWnd, HWND_TOPMOST, 0, 0, 0, 0, SWP_NOMOVE | SWP_NOSIZE | SWP_SHOWWINDOW );

Calling a web services using VB6 with SOAP 3.0

Introduction

In an earlier article the method of calling a web service from a client created using Microsoft Visual Studio 2003 IDE was described. The IDE offers an excellent method to get a reference to the necessary proxy by way of the WSDL utility. This is carried out by adding a web reference to the client application.

This article shows how you may create a client that calls the web service from Visual Basic 6 using Soap 3.0. By providing Soap 3.0, Microsoft provides VB programmers with the ability to tap web services. This is most useful to those who are still using VB 6.0 or C++ and are not contemplating a move into VB.NET.

Read More »»

Registering/Unregistering Controls

Most programmers only know about how to registering controls without knowing how to Unregistering them, simple command below will tell you how:

Registering Controls:
To register an OCX type at the command prompt

regsvr32 whatever.ocx

Unregistering Controls :
To unregister an OCX type at the command prompt

regsvr32 -u whatever.ocx

You can also add right click context menu items to OCX files to perform these operations.

Things that VB Programmers 'Must Know'

Getting Visual Basic projects to load into the VB IDE

After registering different versions of controls VB may give errors when trying to load your projects. Do the following in order, testing after each step to see if the problem is resolved:

* VB may be using a Type Library cache file which refers to the wrong version of the control. These files have the extension OCA. Delete all the OCA files and preferably clean up the registry using RegClean from Microsoft or better still COMclean. VB will regenerate the OCA files as needed.

** The project file may specify a version of the type library which is not registered. This can be repaired by editing the VBP project file to require version 1.0. As an example you will find the line:

Object={6B7E6392-850A-101B-AFC0-4210102A8DA7}#1.3#0; COMCTL32.OCX

for the Common Controls if the VB6 (Version 1.3) controls are required. Edit the project files to require Version 1.0 of the controls. When the project loads the version of the control which is available will be used, and the VBP file changed to suit. This is done regardless of the state of the "Update ActiveX controls" flag. If you still get an "Unexpected error", try Version 1.1. If it still does not work, find out which version is registered and use that. To use a specific version of a control make sure that it is the one which is registered. COMclean from RHA (Minisystems) Ltd. can show which files are registered, screen shots are on this page here.

*** If you are getting "Licence not found..." the VB installation has not worked. Probably, the computer already had the same or newer versions of some of the controls. The installation will not overwrite the files and does not install the licences either. Unregister the controls and remove them from the system folder. Reinstall VB and try again, the control OCXs and licences should have been installed. You can now replace them by newer versions of the controls if you wish.

**** The TypeLib section of the registry may contain version numbers which are not in fact available. The version numbers which are not available may be higher or lower than the one which is available. An explanation of how this situation arises is on this page here, how to fix the problem using COMclean (including screen shots showing invalid type libraries) is described here. The Microsoft Knowledgebase article is Q221990.

Commercial Database Software Development (II)

Commercial Database Software Development (Part.II)

A. Client Server Issues
To setup a network for development, we should know what are the component of a network. The topology and technology being used. Firstly, the OS has to be installed keeping in kind the purpose for which the application is being develop and deployed. The next step is to decide the model to be used. A tip here to choose Domain model if more users and sophistication on central administration is required and the Workgroup model if less number of users are going to use the application. For the domain model we need to install the DNS server.

B. Stored Procedures
A stored procedures is a routine written in T-SQL by using the DML, which acts on rows of a table in a database. SQL does not support IF statements and functions which manipulate strings, formatting functions, whereas T-SQL supports all of them. Stored procedures are stored in SQL Server databases. We can use stored procedures to build business rules into the database. After stores procedures have been stored to the database, users and applications can be call them as if they were another SQL statement or a built-in T-SQL function. The main advantage of using stored procedures is performance. Stored procedures execute on the database server, close to he data. Store procedures, which are nothing but data manipulation code, execute faster than passing SQL statements from VB. A stores procedures can scan thousand of records, perform calculations, and return a single number to an application. All calculations occur on the database server and data is not moved across the network. For this reason, stored procedures are faster than equivalent SQL statement. After stored procedures are defined, they became part of the database and appear as database objects, like tables or views.
This makes it easier to access the stored procedures statements and manipulated them. Once they are tested, stored procedures do not required compiling as is the case with VB code. We can set security on the stored procedures so that only callers with appropriate permissions can be execute the logic. Using stored procedures we can encapsulated the business logic. Hiding database structure changes from an application. We can also change the structure of the underlying tables, by modifying the stored procedure without affecting applications that use the stored procedure. By providing a stored procedure for editing the transactions, we can ensure the integrity of the data. Stored procedures are used to query data into the database, save data into the database, and update multiple tables.

We can use the SQL Server Query Analyzer or the Enterprise Manager to write, debug, and execute stored procedures against a database. To create a stored procedure, we enter the definition of the procedure into the database. We create a new stores procedure by using the CREATE PROCEDURE statement and save it to the database. This step does not actually execute the stored procedure. To execute a procedure saved into the database, we must use the EXECUTE statement.

C. Developing the Standard Modules
The next step is o develop the standard modules, standard modules are sections of the code, which you will access repeatedly across the application. Declaration of Constant and chosen procedures and functions are written here.

D. Designing the Database using SQL Server / any RDBMS
Database design is one aspect of the application development where domain expertise matter most, it is important to remember that once a database design is arrived at for a particular set of specifications, it Is difficult to change or alter the design, frequently .So, better do a lot of reviews to arrive at the final working design. ADO is commonly used to access the SQL Server database. ADO is mainly used to:
- open a connection
- Close connection
- Retrieve data from the server
- Save data

All the above can be implemented in an elegant way by writing a class. Developing a class is technique, which is a topic by itself and can be got from the book.

E. Transactions
While database can efficiently hold large amount of information that can be queried, all of that data and all of that querying power is useless if the data is incorrect or nonsensical. Database provide a plethora of techniques for ensuring the integrity and consistency: primary key and unique constraints can be employed to ensure entity integrity; foreign key constraints aid in ensuring relational integrity, and transactions help ensure that the database’s data remains consistent.

While INSERT, UPDATE, and DELETE statements are the most granular for modifying a database’s underlying data, at times we want to treat multiple INSERT, UPDATE and/or DELETE statements as one atomic operations. That is, in certain situations, rather than having each INSERT, UPDATE, and DELETE statements stands on its own, we want the set of statements to be, together, an invisible unit. When issuing this set of statements we want either the entire set of statements to succeed, or all to fail – there should be no ‘in-between’ state.
The canonical transactional example is transferring money from one account to another. A money transfer account at the bank requires two steps; if we want to transfer $500 from our checking account to our saving account, the following steps must be processed:

First, $500 must be deducted from our checking account,
Next, $500 must be added to the savings account.

In terms of SQL syntax, this would involve two UPDATE statements – One subtracting $500 from the balance of the checking account and the other incrementing the savings account balance by $500. it Is vital, however, that these two steps are treated as one atomic unit. What we want to avoid is to have step 1 complete, subtracting $500 from our checking account, but before step 2 can run, crediting our savings account, image that the database server crashes. (Well, this scenario is something the bank might not get too upset over!!) it is important that either both of these steps complete in total or neither complete.

Database transactions are what ensure atomicity, one of the key feature of any database system. Microsoft SQL Server, as well as any professional grade database product, has support for transactions. In this article we’ll examine how to wrap multiple SQL statements within an atomic database transaction using the sqlTransaction class in the System.Data.SqlClient namespace. A database transaction is a series of statements that either succeed or fail as a whole. In a journal voucher transaction, user enters two accounts creditor account and purchase account.

Creditor account Credit $1000 (-)
Purchase account Debit $1000 (+)

We should update both the accounts if one of the following accounts updation fails. It would be better if both statements fail. Microsoft SQL Server itself support transactions though the BEGIN TRANSACTION, COMMIT TRANSACTION, and ROLLBACK TRANSACTION.

F. Application Interface
As the developer you have to create to create a menu, which will include all access to open all the forms you plan to design. When you start with programming entries, you will start seeing the application taking shape.

Validations can broadly be divided into two categories. Validations in the front end and those set up on the server side. The server side validations are implemented using stored procedures.

The next step is to write report. Firstly, you will have to decide on output format. Depending on the format, write the correct “SELECT” statements (Query Statements). Use the indexes properly to increase the performance of the report generation.


Conclusion:

This article is intended to give you a brief idea of the issues related to application development for a client server environment. I hope that it has given you a basic idea of the issues involved. If you have any questions you can always refer the book which does an excellent job of explaining the steps to develop the application in detail.

This review is based on the book titles:
"Develop an Accounting Package using VB"
(Client Server edition)
vkinfotek.com

review by Micheal, SLC, US

Search Koders.com faster without a browser

Koders IDE Plug-ins enable software developers to perform Koders searches directly from within the Eclipse or Visual Studio development environments by extending the reach of the Koders.com open source code index to the desktop. Koders offers plug-ins for Eclipse 3.0 and above, as well as Visual Studio.NET 2003 and 2005.

Search Koders.com faster without a browser

* The Koders search panel is displayed as a toolbar component within the IDE
* Search directly from the editor by right clicking on a term
* Localize the plug-ins for additional languages Let SmartSearch™ work for you
* SmartSearch™ finds and recommends existing source code in real-time
* SmartSearch™ runs transparently in the background, as you work.

More Plug-in Information
* Learn more about Koders Desktop IDE Plug-ins
* SmartSearch™ demo with audio (~5 MB)

Visit the official website to read details and download free source code!

Commercial Database Software Development

Commercial Database Software Development
(review by Micheal, SLC, US)

A database software has wide applications. A database software is used in almost all the organizations. Over 15 years many tools have been developed for creating database applications. Many have lost out in the race and some, mostly those from the large software firms have remained in the race. Of these, the popular one are Visual Basic, Developer 2000 from Oracle, Delphi from Inprise. The earlier popular ones are Clipper, dBase and Access.

If you need to decide which tool to select for your database software keep in mind the following aspects:

a. Support and Upgrading of the tool is a must.
b. In-build database functions are essential to develop database software.

As a consequence of the potential, there are plenty of job opportunities in Database software market. With the advent of the internet, web based application development is also driving the job market.

We will, in this article, discuss database software development, which will give you an idea of how applications can be developed using VB and SQL Server.

A database software can be developed for domains like:

a. Accounting
b. Inventory
c. ERP
d. Healthcare
e. Manufacturing
f. HR

And many other domains. Whichever domain you choose, the basic principles and techniques remain the same.

We will see the typical structure of a database software:


We will also discuss the salient features of a good database application. The first requirement of a good database application is the from the developers perspective. The team, which is developing the application should have a good knowledge of the working of the domain. The developers should know all the various intricacies, practical issues, which are important for conducting business in a particular domain.

The next issue is the basic design of the software. The software should be based on Object Oriented Design. This design aspect, if applied to the user interface results in a minimum number of forms to be deployed for the entire applications. For instance, in an inventory application, a single form can be created, and using inheritance, all the other forms can be created at runtime. An object-oriented approach will go along way in ensuring the success project.

As we all know, many database software are deployed on a network. This is possible if the database application is developed for a client server network. An application with server side programming will turn out to be a good and reliable client server product.

The following issues and steps are common in developing a database software. They are listed below:

a. Client Server Issues
b. Stored Procedures
c. Developing the Standard Modules
d. Designing the database using SQL Server / any RDMBS
e. Transactions
f. Application Interface.

Registered DLL which are not available

When a control is registered, it makes an entry in the TypeLib section of the registry indicating which version of the interface it supports. If a different version of the control is installed without unregistering the previous one, such as when a service pack is applied, the later version is added to the TypeLib entry. The previous version is not available despite being in the registry, because the control has been overwritten. A worse situation arises when an installation program overwrites a control with an older version, the newer version of the interface is the one which is no longer available. Programs may not be able to run under these circumstances.

If the previous version of the control file was in a different location, the faulty registry entries can be removed by unregistering it, then re-registering the new one. Usually, the previous file is overwritten by the installation, and the registry entries must be removed by hand. To be sure of getting rid of the faulty entries, first unregister the control, then delete all the TypeLib registry entries which refer to the unregistered control file. Finally, re-register the file. You can use COMclean to remove the faulty entries.

WHY: "Component cannot be loaded" in VB

This problem occurs when a software installation replaced Richtx32.ocx, which has different versions with the same file name.
The OCA type library cache file relating to another version of the control, generated by Visual Basic, was still in the systems folder. Unregistering and re-registering the control had no effect. Deleting the OCA file cured the problem. Yet another case of Microsoft breaking the rules of COM.

To solve two common problems:

* Compiled Visual Basic programs refuse to run, giving "Unexpected error". The short answer:
Re-install the program which does not run. Many software installation programs supply the runtime program and controls they require. (But ours do not so will probably not be fixed.)
2. Install the VB5 and VB6 runtimes to get the latest runtime and OLE DLLs.
3. Download and register the latest versions of the Common Controls.

* You cannot load a Visual Basic project into the IDE any more. The short answer:
1. Delete all the OCA files on your computer, VB will recreate them as needed.
2. Edit the project files to require Version 1.0 of all the controls.
3. If the errors include "Licence not found", remove the common controls and reinstall VB.

Please check all the items on this page. If the trouble is not resolved we are sorry, but we don't know what to do either. This page is kept up to date with everything we know.