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

This is a ZipCode ASCII text file exported from SQL 7. First row has column names. Ready to be imported into your database of choice. Over 43,000 entries. Example: "Zip_Code","City","State","Area_Code","County"-- "00210","Portsmouth","NH","603","Rockingham" "00211","Portsmouth","NH","603","Rockingham" "00212","Portsmouth","NH","603","Rockingham" "00213","Portsmouth","NH","603","Rockingham" "00214","Portsmouth","NH","603","Rockingham" "00215","Portsmouth","NH","603","Rockingham" "00401","Pleasantville","NY","914","Westchester"

Ok, and now that you have finished your Super Multiuser Access application ,would you like to know who is logged on??? well, here is the answer and the code to do it. don´t forget to rate if you like it.

Here it comes again with a cool interface a compact one(like the msoffice taskbar) and a full one(see screenshot).It has more number of functions than you can imagine.An image viewer(not a simple one).A database using Msaccess.A calculator.A Phone Dialer.An Inbuilt internet browser.Calender,time date(you can even set the system time).Play movies or MP3's as you work.It took me many days to complete.PLEASE VOTE FOR IT.visit www.gauravcreations.com for many more cool programs .

I did not write this code by myself , i had found it at http://support.microsoft.com/support/kb/articles/Q246/3/35.ASP With this code you can transfer the contents of an ADO recordset to a Microsoft Excel worksheet by automating Excel , this code will work only with Excel 2000 or 2002 , for Execl 97 use my previous examples, or just look at this examlpe for basic knowledge at the IF statement.

In this example I try to show you how to connect the ADO object to Excel file directy , without copy any data from the Excel file to DataBase first ( like MS access) , plesae vote for me :)

This code will copy all fields from all tables in a database and add them to another identical database. My company has Rep submitting database reports all the time. I need to append the data from the reports database to a live database. At first I was running querys I had made in the database but our file structure changed and that was no long an option. This is about as simple as it gets but someone might find it useful.

This program generates code for a Microsoft Access database that the user selects. The generated code will declare the connections as well as open and close the connection. This code has a lot of examples of coding with ADO and grids. I have lots of comments in the program.

This is an ADO DB tutorial for programmers who know nothing about ADO. It is a good template to following when making your own project. I hope that it helps.

This program is designed to teach the user how to load data into a FlexGrid from an Access database and then manipulate the FlexGrid to perform typical database actions such as Add, Edit, Sort, and Delete. The database manipulations are executed with ADO methods

This program generates code that will open and close an ADO connection and recordset. There is also an option to generate navigation code. There are several other options which allow the user to select cursor style, cursor location, and locking style. Note: This project is an add-in. In order to use it, load the project, go to file and choose make ADOToolbox. Then load it from the add-in manager.

This code is used to convert entire Excel Workbooks to Access Databases. Each Excell Worksheet in the Workbook becomes a new Table in the new Access Database. This codes has a problem processing more than one file at a time without stopping and restarting the program. It looks as if it is processing the file but it never actually imports the next file's Worksheets. Try it and you will see what I mean. Any HELP would be appreciated.

this is a code to specifiy .MDB from your app not from properties it is just for a beginner...

On a machine where the Adobe PDFWriter is installed, the current printer is swapped out with the PDFWriter and the PDF file is created. The original printer is then restored.

A Quick & Easy Search routine for ListViews AND Recordsets -- hand in hand. I find that a very nice pair-up in interface and behind the scenes action is the DAO set in conjunction with ListViews. To some this may already be apparent, to others perhaps not. Copy this code in, using the correct DAO refs and the correct ListView, pass the three parameters in, and it should work like a charm. Don't forget to vote for this code. Updated / Patched - 11/4/01 Check out this screenshot ->

This is the better way to find out whether your particular table, any table, exists in your database. Sequential is NOT the way. Check this out and let me know if you have any questions. Please give me a vote if you like this code :)

This nifty little program interrogates Microsoft SQL Stored Procedures and generates VB code to interface with them. The concept was Adapted for VB from David R. K. DeLoveh's work for Active Server Pages found at : http://www.15seconds.com/issue/010718.htm the article make for a very good read so do so if you can! I converted it to run under VB and spruced it up a bit. While programs like LockWoodTech's PROCEDURE BLASTER do the same thing they cost $$$ and this is free. If you like it remember to give a vote. And again thanks goes out to David R. K. DeLoveh's for his original work. With this code in hand it would be easy to modify it to be MTS/COM+ compatiable. For more extensive developers tools like this one check out www.LockWoodTech.com.

Although ADO specification does not provide objects to compact Microsoft Access databases, this capability can be achieved by using the ADO extension: Microsoft Jet OLE DB Provider and Replication Objects (JRO). This capability was implemented for the first time in the JET OLE DB Provider version 4.0 (Msjetoledb40.dll) and JRO version 2.1 (Msjro.dll). These DLL files are available after the install of MDAC 2.1. You can download the latest version of MDAC from the following Web site:

This Program generates ADO code and SQL Statements without the use of an ADO Data Control. It is available as a stand alone executable or as a VB-6.0 AddIn.

This is an Addition to my earlier search function. This is an ActiveX control. It has 9 search functions, inculding rich text box searches, and text box searches, DAO table searches, and Find and Replace searchs for all three. Has a readme file, that explanes all. If you find an error, let me know. This is my first try at making Active X controls. Please leave feedback!

Excel macro that extracts all tables, fields, field types, queries & descriptions from a JET/Access database. Very useful for documenting Access databases.