Tutorials

This tutorial will teach you on how to create reports in Visual Basic .NET 2008 using Crystal Reports. This is a step by step guide on how I create the report on "Weekly Sales Report using Crystal Reports".

This guide is not intended for advance user. So please don't react if you find a basic explanation on this tutorial.

This assumes that you have already attached the database that is included in the zip file of "Weekly Sales Report ".

When you insert record to your table there are some cases that you need to modify the data. Or you may want to update it to the latest record.

The SQL update is there to help us modify the existing values of the table, the SQL update statement used the same column name as insert statement and the new value that you want to placed and the table name to update the data successfully.

The syntax of SQL update statement is as follows:

SQL Insert command is used to save record into a database in a specific table.

The SQL Insert command has the following syntax:

The select command is used to retrieve data from the tables.

Consider the following table:

Users:

SQL is not syntax strict like JavaScript which mean to say that in SQL uppercases and lowercases don’t matter as long as you have spelled them correctly.

For example:

One of the problems that a beginner encounter when there is a project uploaded here, is they do not know on how to change the connection string that points to the correct database location. This is true with MS Access and even with SQL Server. Some programmers don’t add a code that will automatically change the location of the database just in case it will be ported in other machine.

This tutorial will show you how to connect vb6 with ms access using module and also how to use reports in a very simple example.

Thank You.

SARFARAZ

Now that you have added all the necessary forms to your project and a menu system, let us now add a login form. This will ensure that only the person that has the account information can login to your system.