Results for "Category: Databases/ Data Access/ DAO/ ADO"

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.)

Whith this class you can load a lisview control with a recorset, and export the data to the TXT, CSV and HTML Format, you can use or not the progressbar.

Here is my first submission on www.pscode.com, This project prepared to help you to convert your Ms Access Database into MySQL data source format. On this project, I'm using some API function to Draw caption or Picture, so it is helpfull for newbie in VB to learn about API programming. I'm using osenxpsuite controls, to improve my GUI application. if you does not have osenxpsuite controls, you can download it from: http://download.osenxpsuite.com/osenxpsuite.zip I WAS TESTED THIS APP IN MY PC P-III 730 Mhz, and It work fine. It can convert nwind.mdb to MySQL data source for 7.07 seconds If this project usefull for you, PLEASE VOTE THIS APPLICATION IN www.pscode.com Note: - MDAC 2.5 needed - OsenXPSuite controls (http://download.osenxpsuite.com/osenxpsuite.zip) needed - MySQL oDBC 3.51 Driver needed DOES NOT SUPPORT: • cREATE INDEX • CREATE PRIMARY KEY • CREATE FOREIGN KEY • CONVERT BINARY DATA VALUES (BLOB) IF ANY IDEA HOW TO SOLVE SOME TROUBLE ABOVE, PLEASE LET ME KNOW. I REALLY NEED HELP ADVANCE VB DEVELOPER TO SOLVE MY APP THANK YOU

This is a program that uses the ADODB connections to link to an Access database. All connections are created/opened at runtime. Security,passwords,usernames are in Database. Users are in two user groups. Uses SQL statements such as INsert, SElect etc. Links to website uses MDI form and Child Forms. Toolbar with Image list. Status bar that displays a random message. Data Reports using Datareport control. Class Module Example. ISnumeric validation. Search facility for searching the database. examples of using the List View Control

links to the bible allowing searching and indexing of indervidual passages, works using sql and select statements. Program also demonstrates web browser integration and use of the flex grid and shaped forms. you can either select a bible passages or sub chapter etc... or you can enter a passage using the global format, example: Genesis 5(5:9) NOTE ALL BOOKS HAVE A CAPITAL LETTER AND SEARCHES ARE CASE SENSITIVE.There are a few bugs still in this program in relation to back to menu buttons mid wizard and stuff, so be carefull.

Database! Reviewer for exams! It uses randomize for questions and answers, and calculate percentages for correct answers. could be useful for quizzes.

Using datareport without data environment its only a adodc connection

It was design to handle complicated computation and relational, hope you find it usefull in your learning, i use SQL SERVER 2000 For the database which can be use in LAN / StandAlone, hope you enjoy this.. pls give a vote on this one =)

This in an Online Quiz System. The instructor can let the students take the quizzes online. There are two programs: Faculty Server and Student Client programs. The FAculty Server program needs to be run in a server unit. The Student Client program, which is stored in QUIZCLIENT subfolder needs to be run in several client computers (like 30 computers). It uses Winsock and MS Access 2000. Connect the database thru ODBC. String manipulation is "heavy" which includes chracter sentinels to break the data being sent and received. If you have questions just email me. Thanks.

Would you like to add an XP style login to your application? This login will allow you to register and will not allow duplicate usernames. You can also change the color scheme at login. You will need OsenXPSuite for this app. Uses ADO to connect to the Access database.