In this tutorial I will discuss to you on how you can access the database easily. I came across this idea because this is also my problem when I started working with database programming.
I hope that in one way or another I can help you in your journey to the world of programming. Programming is fun and easy if you just simply devout your time with it. I cannot stress enough how easy programming is if you only read an online tutorial like this.
The following tutorial is taken from the internet when I started working with my Library System using MS Access.
I googled this topic to find the author but I can't find him.
This tutorial will handle a text field that contain a value with apostrophe, single or double quotation.
I added it here so other programmer will benefit from this code. You can use this in visual basic or MS Access program.
When building an sql statement that contains text fields it usually happens
In Visual Basic 6.0, you need to insert a code in your startup object in order to run your splash screen or make your splash screen form as the startup object. In VB.NET, there is an option in the My Project Properties to specify the startup object and the splash screen. You can also insert a code to delay the splash screen.
First you need to add a splash screen to your project.
After that, open the project properties.
In this tutorial I will explain to you on how to connect to an Access database and allow you to Add/Update/Delete a record.
To fully understand these tutorials please download the source code How to Add/Update/Delete Record using MS Access Database.
As we know that we cannot sort the column in listview that contain a date value. There is however a work around in Microsoft Website on how to do this. This can be found at http://support.microsoft.com/kb/170884.
Although it will solve your problem but after testing it I found out that it cannot sort the date by descending order. Of course you can add another code to do it. But it will again add another line of code.
Below is a video tutorial for the Inventory System v1.0.75. It explain on how to operate this program in a step by step process. Not everything is included but it will help you to explore the basic features of the program.
Don't hesitate to ask any question regarding this tutorial.
In this tutorial I will show you on how to link an MS Access front-end program to the database back-end.
This tutorial is part of the source code uploaded at Pageant Contest.
Download the MS Access version of this program and learn to code in MS Access.