Results for "Category: Databases/ Data Access/ DAO/ ADO"
Advance POS. Complete codes.. download needed components here and run the components.bat; http://www.fileden.com/files/2006/9/5/203867/Components.zip
Scheduling System. Complete. Some codes from my Advance POS.. ^^. This system includes components that are needed to run the system. PSC did not include those components on my .Zip file. Download the components here. http://www.fileden.com/files/2006/9/5/203867/Components.zip . Hope u like it.
Pre-Requirements : Pak Urdu Installer http://www.mbilalm.com/download/ World's first open source Urdu Database Management System (DBMS) sample in VB6, in form of an Urdu Address Book. First time uploaded at world's largest open source coding website, The PlanetSourceCode.Com. After a long time efforts, i'm succeeded to make this DBMS front end. I hope it will be a great thing for new programmers & also for those open source programmers who are trying to make an Urdu script like Database Management System. In this Address Book, i 've fully tried to make a full functional Urdu Database System front end, like other language's databases, to clear the concepts of programmers that how to make DBMS front ends of Urdu Script like languages (Arabic,Persian,Punjabi etc). You can use this code concept to make any language's Database Management System like Chines, Thai, Italian or any language you choose. I think, any beginner can understand the code used in the project. If anyone of you, wants to be some help or facing problems during use of code or feeling difficulty to understand, Contact me at my email address. I'll fully try to help you as i can. Please comment & rate globes for this code, if you like that effort. Thank You. Join Urdu Programming at Facebook http://www.facebook.com/pages/Urdu-Programming-VB6/263338567072301
This code manages drug inventory, sales, and checks for stock levels on specific drugs. I built this code as my course work assignment. For any comments and improvement on my code, email me or
School Program.. Can manage your student grade.
With this simple, but powerful database programme you will mainly learn the followings. • How to develop a powerful database programme by using ListView, ImageList Microsoft ActiveX Data Objects Library, Microsoft Excel Object Library for a higher portability. • How to easily use Listview control with filtering and exporting techniques (Exporting data with different combination of fields) to get the output in various aspects. • How to do file handlings/clipboard related operations. • How to remove unnecessary characters from the data. • How to use Microsoft Excel for the reporting purpose of the programme without using Crystal Reports, Data reports. • How to use a simple database programme in a network environment. • How to import data from a same structured database while checking the duplicate entries. • How to include basic system maintenance features of a database programme like creating, deleting users, setting user permissions, changing user passwords, resetting passwords and etc. • How to easily implement a simple encryption to encode the constants, user passwords and the database password for a higher security. • How to use a backdoor (An alternate and secret way of entering a computer system) with a database programme to bypass its password protected access. (Education purpose only.) • How to manipulate windows registry easily with few lines of code. • How to do a search in a database programme efficiently and implement an advanced search. • How to use functions and sub procedures to get the various operations done easily in the programme. • How to utilize the pictures stored in resource within the programme. • How to really use a Splash window with a programme. • How to use a good looking and easily-created progress bar without any additional coding, for the operations of the programme with the database. (Operations include clearing data, importing data, exporting data, formatting data with the database.) • How to create a well-arranged, good looking and flexible user interface with professional features in ease, in a limited screen area. • If you are a beginner you will learn how to create an application with professional features in ease with basic programming skills you have without going for a complicated coding style.
Stock Controlling System is a custom-based complete software which was specially developed for managing stock of books of Singapore Informatics Computer Institute (Pvt) Ltd. It includes great features and gives you an extensive idea of thinking beyond the traditional database programming. Some of its great features ==================== * helps maintaining an accurate stock of books all the time. All the books Issues and Receipts can be easily updated. * stock Related Reports can be taken in many ways and it consists of 20 diffrent reports including User Log Status reports. * includes a powerful system maintenance sub system including a messaging system and database Backup/Restore System, which can be used in Multi-user Environment. * specially developed for Multi-user Environment, which handles the database on the server. ** includes a complete help file, which describes the overall operation of the programme.
How do you avoid the "Invalid use of null" error when reading null values from a database?If you try to retrieve a null value (empty field) from a database, you will get the error: "Invalid use of Null". Here is one way to get around this problem: ..
How to copy a database table. This may require some tweaking.... "Bill Pearson"
A short routine that backups the tables from an open Access database George Kinney
The following function creates a user. You can execute it under any user you like. dror-a@euronet.co.il (Dror Dotan A')
Have you ever try so send a string variable to MS Access that have apostrophes using a SQL Statement? If YES you will get a run time ERROR Here is your solution....A function that formats the variable before sending it to the database.
This code creates a Microsoft Access MDB dynamically.
VERY VERY SIMPLE CRYSTAl REPORTS VIEWER - View Any Crystal Report with ease..lets you add reports to a list that you use all the time. Also allows for changing the parameter values. Very easy to understand code -- example report included. Hope you enjoy.
It is nice technique for dbgrid sorting.You can sort Dbgrid Columns by clicking on the grid column header in two ways ascending or descending.
This simple little function just returns the total number of records in a ADO recordset.
Ever wanted to find a special value in a database, but don't know in which table or field it's in. This tool helps you scan for a value in a database with 1 ore more tables in it. Only works on SQL Server. This tool can match exact or "LIKE" querys and has some other features. If you like it, improve it! :) (and tell me about it)
Dates in SQl queries often cause problems, as the date must be in the ANSI format whereas dates brought back can be in a different local format. This function simply returns the date in the required format and save having to type Format(DateString, "mm/dd/yy") every time.
All fields in the selected table are processed and the AllowZeroLength property of the fields are set to either True or False, depending on the Status given as the finaal parameter The function returns a boolean value that can be used by the user to determin other operations.
What you can do is hook up to a database, and with the use of a timer control, you can make a list of any/all records you want in a database. You can use an SQL statement (in the code already) to find a certain part of a string. The return results are any record that contains that particular string in it. Then with the click of a button it will go through each record found and make a list of them. For example, For a spell checker, I took a database that contained over 5,500 words. It went through that database in a little over 5 minutes to get every word made into a list. Very good ideas can come from this, have fun with it!