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

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.

Converts a SQL statement into a string that can be copied into a VB program as a string. Simply paste your SQL statement into the text box, click the button, and the SQL statement is copied to your clipboard ready to be pasted into your VB source code.

Sorry !, My contents of snippet was posted very strange as below. So, i will post my source code Once again, Sorry

GoXML is a wrapper class for MSXML 2.0 / 2.6 / 3.0 / 4.0, offering access to some of the more basic elements in your xml documents. Use GoXML and easy-to-learn XPath to open, create, modify and save XML documents without a hassle. Don't worry about available MS XML Parser version, GoXML will autodetect it for you! The included code sample illustrates the use of all methods and properties. PLEASE VOTE OR COMMENT, THANKS!

This Project Allows the end user to access a MSAccess Database through a Client Winsock application, without having any Data Access Components installed on the local machine. This also allows fast read/write access through modem, or a dead slow computer. The client app sends the server a few strings and then generates an SQL statement, and then does all the hard work and sends back the results to the client.

Heres a good example of using a winsock control to access a ADO database over a network/dialup connection. You will be able to access the database fully, with Add/Delete, Read/Write access. Also i have inbedded authentication against the database via the winsock control. This program is simply for basic job tracking, from inhouse, and for remote access areas. Bascially how this works, It sends the server a few commands/strings, and the server generates the sql statement and sends back the results, to the client winsock application, it then recieves the information and displays it out into a listview control with columns. --------------------------------If you like the code please vote!

Lists records into a listview control using basic SQL Statements.

Heres another good example of using a winsock control to access a ADO database over a network/dialup connection. This project shows how to Add/Delete, Read/Write access with ease. Also I have inbedded authentication against the database via the winsock control. This project gives you the functionally to store and retrieve data remotely and keep track off multi-users online with up to date online and offline status's, into a treeview control. you can create personal folders and use drag drop features to move messages around (remotely). Also allows users to compress the database to keep hundreds of message clean and tidy. also this code shows how to export messages and send internal messages to the server to be export by email, by a internet dialup connection. Now works with Windows NT / Windows 2000. email me if it doesnt work. chris@hatton.com Please Vote....

This project demonstrates populating a Microsoft Access database dynamically into a treeview and listview control, by using loops and arrays. Also added the common Add/Edit/Update functions into the database for those who wish to learn the basics functions of ADO. Another purpose of designing the code the way I have with objects is so you can reuse the listview and treeview modules just in case you wanted to load the same information into another treeview or listview control, with out adding extra code. Once any database is loaded you can also edit the values in the treeview with the label edit functions. (F2). anyway there are lots of code samples available in this project. if you like this code please vote. Thanks.

UPDATED! Demonstrating the inner workings of the POP3 connectors and SMTP connectors interoperating in separate ActiveX controls, the structure of the protocols are specified from the RFC sections. The SMTP protocol saves all messages into a Microsoft Access Database (MDB) using ADO 2.1, and users can change the code to link a SQL Server database easily enough if need to, which would be handy, as you can publish SQL Servers over the internet for remote access, or replication the emails between to different locations. But for now I have it set up for a centralised database which can be shared for to instances of this mail server for load balancing and network traffic. There are two types of SMTP connectors SMTP Direct and SMTP Relay both are demonstrated and commented. This is the first release of my mail server and would appreciate any bug findings, I have programmed this in my C:\Exchange directory and no problems found, network drives will cause performance issues and SMTP Spooling errors. This is a grouped project so remember to open the ExchangeStore.vbg file as it will open the custom controls first. To get started create a new account in Outlook 2000/Express or any other email client, point the smtp/pop connections to the your development computer and username=chris password=password. Also please VOTE.

Updated!! Ado project now supports multi-user connections and is much more stable than ever before. if you have more than one connection open, the server now refreshes all clients connected when a new job has been created or modified. Server keeps a real time status of active and disconnected users, great great over vpn, or internet connection. ADO Project allows remote users to access a database over a network/dialup connection. You will be able to access the database fully, with Add/Delete, Read/Write access. Also i have inbedded authentication against the database via the winsock control. This program is simply for basic job tracking, from inhouse, and for remote access areas. Bascially how this works, It sends the server a few commands/strings, and the server generates the sql statement and sends back the results, to the client winsock application, it then recieves the information and displays it out into a listview control with columns

This code is the beginning of a library circulation program. Two of my freinds and I woked on this. It doesn;t have many of the feature implemented, but Take a look, show different was of accessing databases. Login:David Smith Pass:98022 The Use Administration >Books to get barcode numbers And use Administration > Patrons to get patron Numbers Then Use Signout. Try double clicking on a book Please send any comments to the feedback or daveismith@hotmail.com