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

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.

Complete wholesale product inventory database program. Combines Access, DAO, and Excel to manage inventory, write reports, and print forms. I wrote this for work so you might as well have the code.

With this application you can see how DAO works. You can completely control the database with this code, you learn how to read, insert and delete things from a database with no data controls or whatever :-) And also a great deal of the ListView control is used for this app. And it is completely documented and explained!!

In development of dynamic website using ASP, recordset paging is one of the very useful feature. This code "Dynamic Paging in ASP" makes the recordset paging a child's play. You just have to modify three parameters in the paging.asp file and voila, you can use this code anywhere in you website. Just gives the name of database file, name of table and no. of records to display. That's it ! I am sure it will be a very handy code for any serious ASP Developer.

Accesses any ODBC database using ADO. Records are displayed in a table withe rows that alternate colors. Paging control code allows the user to select which page in the recordset to go to. Current code has been tested with Microsoft Access and SQL 7.0.

This demonstrates how to create a database and components at runtime from a public sub called from the AdoxData class with ADOX 2.1 objects