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

Have you ever wondered how to remotely fire a DTS Package in SQL Server 7 from a Visual Basic Application? Me too... So through rigorous research and aggrevation I figured out a very simple way to do this.

UPDATED - 12/07/01!!! This kind of goes against my article earlier this this week. In a new environment I was able to do two things. I was able to query a list of DTS Packages from my Server and then execute a chosen Package remotely. This can be easily modified to accept collections and remotely fire multiple Packages on a timer (which is what I'm using it for). If you downloaded the zip file earlier you may want to download it again since I've updated it and revised some of the references. NOTE: If you use a DSN connection it must be pointed at the MSDB database to get the list of DTS Packages, not the Database you are trying to run the DTS Packages Against.

visual user interface to construct a query

This will read the table form an access database and then creat the textboxs on a form with the field names mapped to the textbox names. It will then create the code to save what is in the text boxs back to the data base

This code is used to search for clients in an access 2000 database using ADO and a parameter query. In our database we have roughly 20000 records to search and it still finds them very quickly.

Complete application. Customers Database, inventory system, search databse records, cool gui, Debtors alert, password protected. http://www.codeauction.com

Complete application. Customers Database, inventory system, search databse records, cool gui, Debtors alert, password protected. This application is suitable for a car shop. Whenever the mechanic finish a job on a car the only thing he has to do is to use the service wizard and select the parts he used from a list and the number of the parts. The application substract the number of parts used from the inventory and gives the subtotal and total price. http://www.codeauction.com

This sample shows how to use Access Database by using DAO Library. It shows all that you need to know about database using. Its well commented and there is help about all commands used.

Simple Database Application with find function.

Create an MS Access Style Combo or ADO DataCombo using a class and a single property

This is Easy. Very Easy. 10 lines of code, 30 of comments. I'm sick to death of trying to find simple, concise code that tells me what I need to know. This is an example of how to access a SQL Database from VB, and how to use the data returned.

This is an improvement on my previous Access Field Mapper. This program allows you to open two Access databases and Map fields between two different tables (performs AutoMapping as well). After you've finished mapping the fields you can transfer the data with one click. This version will do type compatibility checking and if you transfer data that is not directly compatible it will coerce it for you.

Creates ADO Access 2000 Database

This code demonstrate how to connect to database (Patients97) using ADO code alone. I also demonstrate using the MonthView control and MSHFlexgrid control. The database called Patients97 contains customer details like name , address, customer number etc and appointment date and time. On the form, I have an MSHFlexgrid control, a MonthView control and a command button(cmdViewAppt). Clicking the command button connects to the database using ADO code and the details are displayed on the MSHFlexgrid control. You can display appointments for a particular date by clicking on a date on the MonthView control (MonthView1_DateClick event) and the result is displayed on the MSHFlexgrid control. I have not figured out how to create a report yet. What I'll like to do is to be able to pull the information on the MSHFlexgrid control and display it as a report which can be viewed and printed.Preferably I'll like to use the data report designer but I won't mind using excel or word or is there a way to use DataEnvironment designer? Please e-mail me any improvements or additions at supo@orimogun.freeserve.co.uk.

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!

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

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

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.