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

This project shows how we can print a very simple report to text file using RichTextBox control and to printer. The report contains simple information with quantity and sum of item per page, the sum of money per page, and total of sum of money in the end of report. User can select category to display the report. User also can change the number of record would be displayed in the screen/printer, and can change which printer will be used in combobox. The selected printer is the default installed printer in your computer. Including functions to adjust text-alignment in the report. This is very useful for you who want to print a simple report with many record to your screen and to your printer, without using the third party activex control. Any comments, feedback, and votes would be truly appriciated.

This project shows you how a user login to program and access menu based on his/her level. Program will display every possibility fails message whenever user failed try to login. The chances for login are only 3 times. After that, user must try again from begining. I also made a form to manage user account, that can be accessed only by user with level 'Admin'. Password field was encrypted in database. 'Admin' can manage all user accounts (add, edit, update, delete, change password, decrypt password, view user activity that saved in database, convert/transfer user activity data to log text file, and view that log text file). User can change his/her password. If user level is 'Operator' or 'Manager', he/she can only change his/her own password, but 'Admin', he can change all password user, and his too, of course. And I made menu to compact, repair, and backup database to manage your database performances. I use database Access97 password protected. I also made setting menu to change program setting (run program at startup - this will be occured if you had made an .exe file named 'LOGIN.exe', display screen saver if program idles in for a certain time, protect screen saver with user password, and don't show tips at startup. There is a 'Tips of Day' which display its data from text file. You can learn how to make a tips form and display the tips form or hide it at startup. The user activities that saved in database can be transfered to text file, and this log text file can be displayed from this program, too. So, user activities data can be transfered to text file, and you can delete the records from database. This will reduce your database file size. I made a screen saver form with analog clock. I used Thaha Husain's code to make the needle clock movement (just like a clock in your wall). Thanks to Husain for this code. Screen saver cannot be interrupted by 'Ctrl-Alt-Del', 'Alt-F4', 'Ctrl-Break', etc. Only active/current user can quit form screen saver. If user quit from this program, there will be an offers from program whether your computer would be shut down directly by program or not. Well, that's all I think. Hope it's very useful for you. Any comments, feedback, and votes would be appreciated. Thank you.

This is the first wizard I made and uploaded to PSC. I never saw the one like this on this site. So I made it. This program/wizard will help you and save a lot of your time to build an ADO Code Project. You can build your ADO Code Project by entering and selecting data/tables/fields based on Database or DSN or parameter you entered/selected to connect to your database. Everything is available in this wizard, included if the .mdb file was password protected. This you can't find in VB Data Form Wizard. So you don't have to build your project from beginning by adding controls on your forms, write the code, adding the components and references, etc. The wizard will automatically add those to your new project. You can also add the find, filter, sort, and bookmark procedure/form to this new project. I made this wizard because I often make ADO Code Database project in my office, and this is really really save a lot of my time. You can learn how to make wizard from this program. I got the template of this wizard from Visual Basic, and I modified as I want to, and I added a Help file that you can call from the wizard. As a matter of fact, this wizard is rather similiar to VB Data Form Wizard in Visual Basic, but I had modified the wizard by adding a lot of enhancements. Please download and prove it now. Any comments, feedback, and votes would be truly appreciated.

This is a payroll system, register new employees and gives them employee no, validates each & every entry. each month, operator can select the Employee ID can generate the Payslip. This is very perfect Payroll System, you should use this, learners will found it extremely useful.

This is a quiz administration programme. It was created with the military in mind (Navy) so to login you use an official number and a password.There are two groups of users, the administrators and the students. An adminstrator would have access to the questions database (being able to modify it or add new questions), he can also set the conditions for taking the test like number of questions type of questions and duration of test. Only an administrator can register or modify or delete other users. He also has access to all test scores and can prune the database. The questions are stored according to subjects and could be in form of True/False, Multiple Choice or Short Answer type. Each question can be associated with a picture. A student can either take a test of check his scores. All users can change there password anytime. Even though the application was written to suit the military it can easily be modified. Please leave you comments and views, as I am sure I still have a great deal to learn. I have indeed learnt alot from this great site and most of this code can be traced to this site. I am really gratefull to all members of PSC.

Using ADO & ADOX, convert between various database formats like Text, Access, Excel, dBASE, Paradox, HTML.

Using ADO & ADOX, convert between various database formats like Text, Access, Excel, dBASE, Paradox & HTML. This is a NEW VERSION of Any-to-Any Database converter. Please follow the link if you like to vote me / to get the original version http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=47434&lngWId=1

Simple Library System, I attach some codes from PSC that I downloaded.. Thank you!

Open a DB via DAO 3.5/6 with password protected! This code just for beginners like me ;) Not rated please, commented only. Thank you!

This code serves to connect to a data base DB2 in i5.

UPDATED - 11/10/04 This is a Contact Management System for all those who would like to track Contacts, Projects, Appointments, and much more. A few of the features are: 1)Contact Management, 2)Project Management, 3)Appointment views by Month, Week, or Day, 4)Notes & Calls management, 5)To Do item management, 6)Various database utilities - compact, repair, backup, restore 7)Popup To Do & Appointment reminders 8) Query Contact & Project user defined fields. View "ReadMe" for specific update features.

Listview1 will list all records from a given Data Source SQL qry. It sorts by Date, Number, text etc. It has a very nice find facility and a sql builder. Output data to CSV, XLS, Clipboard, HTML, PDF, Screen. (ActiveReports 2.0Pro) is needed

On browsing the forum and the net, I see a lot of questions relating to data integrity in a VB form. It's an issue I come up against a lot myself - so here, I have attempted to address some of the issues raised and provide a possible solution. The form is designed around the DAO data reference. It is an attempt to make a bullet proof data form in that . . If the user changes the value in a field and then tries to move to another record, or add a new record, or close the form or whatever . . then the form will pick up the changes and ask if the user wants to save.

This code is design to keep track of companies resources like employee, guesthouse, vehicle hire, canteen management, salary slip geneation and many more

This Program explains how to connect ORACLE with VB. How you retrieve table, view and stored procedure of ORACLE. Also featuring subclasssing a Textbox and customizing Progress Bar. If I make any mistake please send me the right one.

This Program explains how you connect ORACLE with VB. How you retrieve table, view and stored procedure of ORACLE and Table Description. please Check Out subclasssing a Textbox and customizing Progress Bar. If I make any mistake please send me the right one. Check Each and every code.

Hi, This project gives you an idea how to access ORACLE through VB and ADO. Project describe How you interacting with ORACLE Table, view, Stored Procedure, Type, Package, Package Body, Synonyms, Sequence etc. I developed an Active X Skin which is used throughout the project. If you want to test the Skin just put the controls (OFrmCtl, Edge Right, Edge Bottom, Edge Region) in a form and run the project. Please close the project from FORM CLOSE Button, otherwise IDE will be crashed. Please check all the menus and form. Now, I’m trying to develop this project in Visual Basic.NET. Resize the form From X Axis and Y axis. Check it out. Using of My developed Active X Skin and other components are strongly prohibited.

This example shows a way to manage persistence with classes in VB using a 3 Tier framework with XML for inter layer communication.

Here is a list of this control futures: 1. Login in to MS SQL Server 2. Backup, repair and restore databases 3. Upload databases and delete databases 4. Control the server (Start, Stop, Pause and Continue) 5. Check Server Status (Started, Stoped or Paused) 5. Check connection if active to server or not 6. List databases in the MS SQL Server, list teables and fields in table 7. Open connection with database and SQL statments (like select) 8. Save any file to Binary Field in table (like upload picture to table) 9. Display picture saved in database field to object (like Picture control) 10. Save a file from database field (like picture or txt files) to harddisk 11. Check if EOF or BOF 12. Find any record easy 13. Add, Edit, Update and Delete records 14. Bind the database fields to VB Objects (like Text Box or Label) 15. Bind the database table to MSFLEXGRID32 control 16. Handle All errors easy (no visible run time or desgin time errors), all hadled by name & num. Its the easiest, coolest code ever seen! You can learn even how to upload and download files from MS SQL Server! Its learning control and can be used for your projects as well! I hope you like it, if yes, please rate it, thx anyway! :)

This is designed as a wrapper to the MySQL API, it is a windows dll and just needs compiling and registering before adding a reference to your projects, it provides a means of accessing a MySQL database as you would using ADO. This is the second and final version and has been compiled and tested with both VB6 and VB.NET and works very well with both. Please give feedback on this as it will help me to improve on it. Also please feel free to suggest anything that you would like to see in future version of this dll.