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

This small application will allow users to search for contacts by name using a ComboBox. This project shows use of ADO, Search Methods, and Modular programming.

Copy the table structures and records from one database to another. In my case, I use this code to copy from an ODBC SQL Server database to a local Access to allow users access to a copy of the data when they are not connected to the network.

This COM app was developed as a drop-in module to access databases across the corporate network in a variety of applications. I'm posting it here to get feedback - am i doing the right thing, could i change it in any way? make it better? all comments (constructive!!) appreciated!

This code pastes into a Module that Create (if not exists) a MDB to record the errors that occur in your application.

All fields in the selected table are processed and the AllowZeroLength property of the fields are set to either True or False, depending on the Status given as the finaal parameter The function returns a boolean value that can be used by the user to determin other operations.

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

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

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

A article showing how to create a global ADO connection to SQL server from a Visual Basic Client.I have more examples and programming solutions on my web site www.SQLwarehouse.com

Asynchronous Database Processing via Active EXE - When processing thousands of requests for a multi-user real-time application, you cannot afford to wait for the relatively slow database processing to occur. Here's the scenario: You have 1000 people already online and playing your multi-user game, and 10 people in the process of logging on right now. What do you do? You could process the logons right now, searching through thousands of user records, to load up their information - but then the game would appear to 'hang' for everyone already playing, waaaay bogus. You could process only 1 person at a time, in the main processing loop - that's better, but will add unnecessary slowdown to your program. What if you could log on the person in a BACKGROUND process, which wouldn't slow down the existing users? Ooh yeah. Or better yet, hand the request off to a machine across the network, dedicated to database processing? NOW we're talking! :-) You can do this easily, using Visual Basic ActiveX EXE's. Have fun with it!

A valuable tool in your programming toolkit. Use this routine for when an Access table goes bad. Often when this happens conventional INSERT or APPEND queries or cut/paste techniques don't work for backing up your table. This is a routine for copying data from one table to another table, field by field. As the information is processed, bad data fields are skipped over and logged in a log file. Only good data is deposited in the target table. **re-uploaded/Corrected II**

** Release 3 ** New cTREEVIEW features: Flat border; IsChildNode; CopyNode with cancel option; Cut Icon state. ADO example supporting: Load on demand; Find First/ Next/ Previous; Label Edit; Drag'n'Drop; Node & TreeView context menus; node specific Open/Closed/Drag icons. ADO Example now supports: New Nodes/Records can be added; copy treeview node(s); Cut/Copy/Paste through right-click context menu; and functions are now benchmarked with results displayed. ** Release 2 ** cTREEVIEW class features: Scroll treeview Up/ Down/ PageUp/ PageDown/ Home/ End using code; Dragging with auto-scrolling (not supported by Microsoft in the TreeView control); NodeFirstViewable; & NodeLastViewable. ADO Example fixes: Find Next/Previous didn't work if branches already loaded. cTREEVIEW class fixes: correct node drag icon displayed. cTreeview features include: fast clear a treeview; extended Add/Rename/Delete nodes; copy & move nodes through code &/or Drag'n'Drop including parent nodes onto child nodes (not normally possible!); find node using text and (optionally) key properties; check if a node is a parent of another; checks if a node is a root node; a safe get parent node text; right-click context menu (before/after click event); collapse/expand all nodes; collape/expand all child nodes; enable/disable redraw. This example shows how to:- work with multiple tables of data and load data on demand. As a bonus, I've included cDB class that encapsulates working with an Access Database using ADO. All code is heavily commented. If there are any routines that you feel are missing or code/bug-fixes that you wish to contribute, then please let me know and I'll add them in. *** Latest version can be found here:- http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=37553&lngWId=1 ***

It lets the user compact any database including password protected ones. And it also over writes the old one. Uses no controls only API.

I wanted a way to send messages to the users who are in an access database. This code opens and reads the ldb file for the database (that you specify on the form), reads the user names and sends a message....all without API calls. You can do a lot more with this obviously (I trimmed it down a lot for this forum). You will need one text box for the source of the ldb file (named txtLocation), one command button, and one text box for your message (named txtMsg).

It is a Good example for those who want to connect the Database with ado, Visual basic Suggestion and Comments are Welcome

The code demonstrates 3 common combobox tasks: 1.) Filling a cbo with a recordset 2.) Setting the cbo Text to a recordset field using a numeric rst field 3.) Setting the cbo Text to a recordset field using a non-numeric rst field

This simple code allows to make an auto-filled textbox (like an adress box in IE). This example uses an DataEnvironment connection, but it can be easy used in any other cases.

Converts the timestamp data type of SQL server into a string that is then suitable for use in a where clause