Results for "Category: Databases/ Data Access/ DAO/ ADO"
How to get Minutiae from fingerprint only the Basic, my sons school projet. Can any one make it faster. Thanks
This program can automatically backup your database in the specified time interval on the specific location, database filename will be appended with time and date to avoid overwriting of previously backed up file, and also give the user and information when was the backup file was created, I used this program in our system to backup its database every 4 hours to avoid data lost if ever there are data corruption because of brownouts or network failure.
This program can able to import data from Excel Document to Ms Access Database file, the user will just select fields from the table on Access Database, and also select fields from the sheet of Excel file, the user can just drag and drop excel field to the matched field on Access database table, backing up of Access database is included in the program for data safety in case of user error. I created this program because I cannot find any program like this anyware, it took me half a day to finish this program since its a rush and that our client needs to import thier existing data from excel to the Inventory System database. If you find this program useful please vote for me, also visit my homepage www.mindworksoft.com for more free programs.
The project shows how to make a complete ADO Code database programming with: binding recordset to DataGrid control, navigation (move first, move next, move previous, move last) buttons, add, update, batch update, delete, search according to title, author and subject buttons. Automatically assigns a number to record to be saved. It can list the books according to their author's and lists item according to their subject. It also shows how to create database and open a database, reports in Excell and displays it using WebBrowser control. You can do online search as well.
Hi! This is my first submision. This is a complete address book with picture likes school database to keeps track of your relatives, your friends and your classmates. Look and feel of WIndows XP regardless an operating system. download now! and don't forget to vote me .....
UPDATE 11/07/2006 - Now has TEST GROUP for easier testing without compile. Added 'Start New Page' option to group headers, fixed various bugs with opening saved files, further fixes to undo. UPDATE 10/26/2006 - Mainly fixed up Undo (removed Redo) plus other minor bug fixes UPDATE 10/19/2006 - Further improvements to GUI, coolbar control, better icons UPDATED 10/12/2006 - Group Headers/Footers, new selection modes, bug fixes, etc. This is a project I WAS working on for a long while but never did complete. I'm uploading it mainly for the interface example that may be of help to others. You can create and preview simple reports. *** IMPORTANT *** Please read the Readme.doc before using this program.
this is an caller id program based on at+cid=1 you can edit this according to your areea phone.it automatically searchs it's database for phone number.you can search both by name and phone number.
[Updated 27/2/05] Make your recordset universal! Use this class to export ADO recordsets into the industrial standered [csv], commercial standered [html] and the power user standered [Excel]. This is an updated version of my previous work, now complete Events, Properties, Documentation and even more options! Fuly optimized and commented. All bugs fixed. A must have for any database devoloper and a must add to any code library!
crystal report 8.5 and 10.. dynamic server using setLogoninfo in sqlserver
how to connect the datasource using setlogoninfo in sqlserver 2000 or 2005.
This is a complite Invintory system
This project demonstrates how to open the Crystal Report 10 in VB 6 and assign the path of Access db. to the report file. It has uses some function in the VB, like the Formula, RecordsSelectionFormula.... I weak in commenting the code, but hopefully it help some of you. Please give some comments/ critics and vote to me. Before opening the project, please make sure Crystal Report 10 is installed in your Windows, otherwise, the project cannot function normally.
Tired of seeking through your hard rives to find Access databases, to compact them and gain some free space? Then this tool could help you. Basically it parses all the directories and sub-directories of a given hard drive unit, and tries to find Access Databases. When this operation is done, you can repair or compact them. I gained on one of my HD unit over 6Gb of data. What you need to make this project work: vbalSGrid6.ocx and ssubtmr6.dll fro vbAccelerator. These files should be in the libs directory. If ever they had been removed then, just go to this url: http://www.vbaccelerator.com/home/VB/Code/Controls/S_Grid_2/S_Grid_2/VB6_SGrid_2_Binary.asp 1- Open a blank project. 2- Goto to project -> references and select ssubtmr6.dll, it should register it for you. 3- Open your the test project (an error should appear), then goto project, components, and select the vbalSGrid6.ocx 4- close the test project. 5- restart it it should be ok. You'll also need Microsoft DAO 3.51 or 3.6 (depending on the Access version installed on your computer). Generally 3.51 works well with Ms Office 97 databases 3.6 or above should suit best to newer versions of Access. I'm currently using Ms Office PRO 97, and thus for referenced DAO 3.51. If you have troubles or do not understand how to make this thing work, don't hesitate to send me an email.
Don't just judge its cool or not!!!Its really amazing application with professional touch. Learn VB with database also including impressive interface design. See screenshot for more and download applications... and ya don't forget to give your feedback to me at my mail address. Visite : http://geocities/priyank_modi/
For handling books,members and all library related stuff for library managment system
Manage Merchandise and Payroll Also has POS System... Uses txt files forreporting.. My Acknowledgement toall psc COntributors.. especially to divyen and philip for some gui's and functions.. Thank You.. Beginners can find this very useful with pure ado coding... if you want to go to the pos module you have to create a user with a positionof cashier
This is a partial fulfillment of my system.. ithas sales and inventory and pos system.. it also has employee loans and payroll. My thanks to all psc contributors espacially to philip and divyen.. you have to create a user that is a cashier position to go to the pos terminal... i converted my code to a very readable coding o that begginers mayfind this useful..
This Helps in maintainign the booking, vechicles, contacts and other important aspects of any transport organisation.
This sample project demonstrates uses of ADO not covered in the preceding topic. The sample project presented here is a simple "one-table" database application. It works with a table of customer data (name, address, phone, etc.) and allows the user to view, add, update, and delete customer records. This sample project uses a DSN-less connection (compared to the Intro to ADO Part 1 tutorial which used DSN). Also, this sample project uses the ListView control to display the records that the application will be working with. A tutorial on the use of the ListView control is covered at the end of the article.
This tutorial / demo app shows you how to process an Access database using "old school" DAO (Data Access Objects) code. Covered in the tutorial is the DAO Object Model, as well as methods for recordset processing, searching, inserting, updating, deleting, etc. The sample app also uses Crystal Reports (the version that came with VB6 and VB5, not a commercial version). The Employee.mdb file that is part of this sample app is Access 97 format, and it MUST be 97 as the old version of Crystal cannot read anything higher. (If you have Access 200X, the higher version of Access will be able to read this database, but don't accept any of its offers to convert it for you.)