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

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

Shows you how you can use a progress bar while reading an MS Access database. This example uses two progress bars, one for reading each table, and the other for reading the entire database. Programmed using VB6, if you have a previous version of VB you can add the frm file to a new project (However, I have not tried this myself)

Learn how to incorporate Access Databases into your Visual Basic project! Add, delete, edit, and refresh all records in the NWIND.mdb database. Then, display the data from that database in a datagrid and a 3D bar/line/pie graph! Comes with a downloadable example application! Please rate and leave feedback!

A simple example on how to add/Delete a DSN to the ODBC of a Windows Operating system. Completely commented.

This article shows how to store and retrieve images from a database in a fairly simple way.

A perfect example of using an Access database. With these example, you can add, delete, moving in the database. All validation is done. Use PageUp and PageDown to seek records. Very nice interface. Reusable code. All code is commented. Simply the best example ever on planet-source code about database management.

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 .

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.

This VBA Automation demonstration assumes that Microsoft Excel 97 and Access 97 are installed. It hasn't been tested yet with Office 2000. My work required an Excel application that could generate charts based on information in Access. After searching PSC I came upon a great example by Joe Miquel which I've built upon. Once you've started the application all you will need to do is Click on the Excel Button on the Access Form. Feel free to expand and to innovate the code. Many thanks to PSC and to Joe Miguel for a great idea. Hope you like it.

Reportgenerator similar to crystal reports or list and label. at the moment, it´s documented in german. it uses dao to print reports out of access-databases (either with or without print-preview). it should be no problem to migrate to ado to get access to any type of databases.

Code below demonstrates how to work with DataReport. You will need: 1. DataEnvironment 2. DataEnvironment Command that receives parameters. 3. DataReport with; a. Detail section named "Section1"; and, b. rptlabel named "lblCopy" 4. Form with a button. Code below should be put on click event.

I have noticed recently, how many people have been going into the discussion forums and asking how to use databases. well, this is a very simple example of how to manipulate data within databases Functions include add, edit, and delete records, and a search by surname. this code is fully commented. please comment on this upload, as i would like to know what you think, and if you think there is a better way of doing certain things, argue it out all you like! daz

Use UDL files for your dataconnections instead of DSN.

A simply utility to search US postal database. You can search by city, state, areacode, zipcode, or county.