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

I got the the layout and design of the program from CONTACTS 2000 made by Deatree@Yahoo.Com. BUT the code underneath is radically different! This program MANAGES AN ACCESS2000 DATABASE with SQL and query's with Recordsets. The best part about using a MS JETDB EnGINE4 is that the DB can be accessed through a network. It also queies a recordset and spits the results to the NEW DATA REPORT in VB6. I worked hard on this one! enjoy. READ README.doc for info on running. e-mail me at mikren@vianet.on.ca for questions. PS. THANKS MICROSOFT SUPPORT (GENE MOODY)!

This code lets you add a new table to existing database in SQL Server programmatically. Useful when developing a database application for off-line users. Simply send an executable through e-mail, and let it run once.

How to load DAO objects on runtime, open database and select the DAO version from installed ones! Big news for VB5.0 & 6.0 DAO/JET Access97 database application makers: Capacity to select the DAO/JET engine version on runtime! This is my new invention how to load a "installed" version of DAO in runtime. Also this shows how to use DAO as runtime created object! Tested this in VB5.0 And VB 6.0 The coal why to develop this is solve a potential DAO 3.5X App break when a new install of Office 2000/2002 removes the registry entries of older DAO's. This is the number one end user tech support issue in DAO 3.5x referenced applications, even if they are carefully made! The problem might rise again more when people are installing Office 2002 after your app was there. There are two demos how to use this when the System.mdw file is in effect and second sample for unprotected databases. See file: Readthis.txt in the zip, The instructions and exceptional are explained there!

UPDATED: Added better error handling just to be safe and neater... Also added more sound so all commands have a sound and upon loading a 3 second wav plays also... Great for learning how to add sound to enhance your program...Great for newbies to learn from...My first ADO database, i learned from tutorials on here specifically from Jerry Barnes so i think this would be great for people new to ADO databases to learn from but i suggest finding Jerry Barnes ADO For beginners source because it is incredibly commented on and will surely have you creating ADO within 20 minutes. I tried my best to eliminate any bugs but of course there has to be some somewhere... I also used sheridans active listbar for this program, the ocx is packed in witht he zip. Please let me know if i didn't include a needed ocx,file or just if something doesn't work right so i can fix or at least try to fix it. This took me awhile to make so please at least vote for me. Fixed a bug witht he extra button caused by a incorrectly placed setfocus, also fixed abug with the edit option displaying when save was pressed and causing an eof and bof error after the person tried to edit after re-opening the database later. Fixed a lot more bugs in this newer zip. -- IMPORTANT: Password for login is chris

DAO based database program with many features in it, I also noticed after searching around I seen no databases that supported saving gaming info so I made one witht he ability for saving game info such as favorite game, gaming handle, clan name, clan rank... Also added the ability to change the color of almost virtually everything you can see. This is my first database I made or even attempted so don't expect much from this but I think for a first attempt this came out da!mn good... I know my error handling lacks a lot and I think I will be implementing the ability to email from this program, search may be implemented but I never had a use for a search option in all databases I used so thats a maybe... Also I plan on adding a user login feature, I tried to comment on as much as possible this is basically for those looking to break into databases since I think I successfully created a pretty good first database. **Extra Cool features** Double clicking on the email text box will open up your email application and fill in the To: field with the contacts email address, double click any phone area option to call up a form in which you can type in the contacts number and call them (example taken from the sample that comes with vb6, i just thought it would make an excellent option... Also your pc must be connected to the same line as your phone line in order to work) and double clicking on the Homepage Title or Homepage URL will open your browser and take you to the contacts homepage...I also included a timer feature so you can specify any hour or minute you wish and set the alarm then it will display a message box at the specified time reminding you to complete your task...

The purpose of this example is to connect/display database records (using ADO) with a simple listbox. This is a work around to using bound controls. You will find your apps will run faster.

This is a program which will allow you to test a connection to most databases (SQL,Oracle etc...) and run any SQL query through. The connection to the database is handled using RDO although this could be quite esily changed to ADO if required. To test the connection you will need to enter the desired connection settings like server name, database name and password, DSN name if required etc..

This project is based on CODE_UPLOAD1185011192000.zip. I added a Class structure to the Server and added some other checks. This upload is a Multi-User Server/Client project. The Server has also a very reduced sort of database behind. Every user can create one or more buffers which should act as a one-dimensional recordset. The buffers are being filled by a simple Selection statement. The purpose of this work is to figure out if a simple database server could be built up in this way or if you have to do it totally different. I'm actually looking for some critics to understand why this is a good way or why not. So please give me comments. No votes needed.

if you clicked on the name field , a listbox will drop down to choose from it please rate this program

New to ADO? Worried about ADO? This little subroutine gets round the problems of opening ADO recordsets. Please look elsewhere on this site for info on opening the database itself. If you open a Recordset in your code, ADO expects you to close it before re-opening. But if it's not open you can't close it... (Oh My!). Here's my solution. It requires a public ADODB.Connection - I call it gCn. The routine will open a new recordset (compatible with Janus GridEx), or refresh it if it's open or if the SQL has changed. Optional ReadOnly argument.

This OCX will helps you to retrieve all types of images supported by the Visual Basic Picture box in one line of code. It save it to- and read it from an access database. It support Ado and DAO. You can browse for photo images on your harddisk with the filebrowser included into the OCX. This browser also remember the last directory. This code is well commented. Just click on the ocx, drag it on a form and start programming. This code has not been tested on SQL server jet. I've included a sample application to show you how it works. I hope it will be an attribute to your programming needs. For any comment mail me at Tigersoftware@rodneysafrcomputing.8m.com Have Fun. Rodney Godfried

Unfinished video rental proj.(currently working on int) Shows you how to make your code multi-tier ready, reusable, how to use class, how to dynamically add toolbars, this is kinda basic but will help begginers to intermediate! I like the way PDSA codes that's why i pattern my code to them :) Begginners if you like my code or learn from my code pls. vote!

Simple, but effective. If you use MS Access for Client/Server apps, you'll never need to write another piece of code to display your reports, just add this form to your DB and it'' do the rest. Double click to open a report normally, or send it to Word/Excel or HTML format.

If you liked the Report Manager you'll love this. Again, it's very simple but effective. It allows you to manager both your Access queries and reports directly from a VB6 program, which sure beats writing code to do it. Have fun!

If you do any work with Access, you'll love this. It adds a sliding TreeView to the side of a form in MS Access allowing you to navigate through data

This VB6 project demonstrates how to edit an ADO multiuser recordset using databound controls. It is based on the 'single-record form' created by the VB wizard, but adds: * Enhanced error handling * Improved user interface The demo allows several instances of the form to be opened, for a 'pretend' multiuser network.

This is a simple generic wrapper class to quickly general ADODB Connection strings, including password protected files & shaped recordsets. I've only needed support for Jet & xbase files so that's all I've included. Please feel free to expand and post them as long as I get a copy of any changes.

I was in need of certain application that can store data in to the database and the database is stored on the Web.. And I want it without XML. I asked many people that how Audiogalaxy and Napster are doing those all the things.. they told they are using such service like XML or other.. But I don't want to use XML. So I develope application for me.. It is really very easy to use and also very easy to develope.. This is made with Visual Basic and simple codes of ASP. Must See this code.. and please vote for it.. NOTE: Now probleme is that, that I am not able to get data from the web. If any one can do it.. please let me know..

To show the ease of adding any Crystal Report to your VB application

This is the database editor version 2. I did not submit the first version. However, I made changes and enhancements to improve the program. It only works with MS Access type databases. A person does not need access installed on their computers for it to work either. You can create new databases, open existing databases, compact a database, add new tables and change the database structure. If there are any suggestions for improvement, questions how to use it, to give feedback, or even if there are any hidden bugs, please do not hesitate to email me at musictopia@cox.net