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

I wrote this code when i was developing a software for an Estate Agent. The code copies the database path in the System Registry and everytime picks it from the registry. If connection fails another dialog box opens where you can specify where the Database is saved. Secondly, you can take out the report of all the data in the table using MS Word. A small routine to accomplish the task. This is basically a three in one program. Save DB Path in the registry, Create Report using MS Word and Specify the database path. Just copy extract the .zip in C:\post directory. Please rate it.

Ok, Trying this again. I think I have all the bugs worked out. This is a sample of a larger database GUI that A friend and I created thru VB for the company that we work for. If you want the full setup.exe and the cab files (you know if you don't have a full package & deployment options) then email me and I'll send it to you in zip format. (Note: this is a huge file) This is a free version so please all comments welcome as to what more to include, and etc. Please do not distribute this software on any other server other than the original upload to planet-source-code. If you think someone else is interrested or would like this program, please give them the link to this. Thank you so much. We also tried to include as much helpful information with the program as well so, if you are operating it and you have any questions please contact me. So, enjoy.

This is just a small login app you can use in your programs. It uses an access database. You can add users. Starting username: username password: password. Please give feedback. I know there are bugs.

a simply sort on de collumsheaders of a datagrid

This source code compares two database structures and wrote report or copy differences into second database. It uses DAO control and works with MDB database.

This is a small application that uses ADODC control to connect to Access, Excel etc. ODBC data sources and execute SQL statement on them. The DataGrid control are used to display returned data. The application has it's own simple SQL code keyword formatter, logging and other features. Small, efficient and robust. Could be a good example of how to use ADO object to connect to DB, execute SQL queries against data in DB and handle the returned data.

SQL Server Documenter can display, print and export to Excel a complete overview of all fields and indexes in a table. This started as a "hello world" type of thing for SQL-DMO and this is the result. It's great for debugging or documenting your databases (that's why I wrote it ;-)). Try it and any suggestions are always welcome.

ADO Recordset Paging in VISUAL BASIC !!! There are many code samples that making recordset paging available in ASP ( Web based ). This example of ADO Paging through a recordset is written in Visual Basic !!!

This is the only one ADO Boolean Search on Planet Source Code !!! [ AND / OR / NOT / AND NOT ]

This code will demonstrate opening, reading, editing, moving within, adding and deleting records within an Microsoft Access database. Updated with some error handling and other stuff :)

This is a Bible concordance that you can use to store bible related topics and scriptures. So like you could create a topic entiled "Abortion", with scriptures against it, and come back at a later time and view it. It uses an elaborate database of text files to store all info. Next version im going use MS Database. If you add anything cool to it, please let me know. Thanks.

Este codigo facilita las conexiones mediante el ODBC creando un DSN segun el driver (class) que se este usando (Access, Dbase, Paradox y MySQL 3.51 en esta versión). Estupenda herramienta para los programadores de aplicaciones que usan bases de datos tales como Paradox o Dbase. Duda o sugerencia favor de ponerse en cotacto conmigo. With this code, u can connect to many databases formats using ODBC, like Paradox, Access, Dbase or MySQL, with a short numbers of lines and easy. Try it :-)

This code is a great help for those people without Microsoft Access and want to administer their Databases easily. Includes full source code. Shows all records at a glance, allows editing, adding and removing. If you like this please support me.

Internet Cafe System .. to calculate time and the cost for each PC in the cafe .. There is a DB to save user accounts and information about them

This program convert Access Database to the MySQL database. It has many functions like Copy Full Database, Create Only Structure, Create And Copy Database, Create Table Structure, Create And Coppy Table, Coppy Only Row etc ... I made some examples with it and although i used an access db with 100 000 records it did not gives any error.

Browse to your database. This MDI program opens the database, seeks for tables and puts the fields into new documents. When double clicking a field from a table, the relation between other tables will be shown. Simple Code ..

Have you ever needed to switch the file extension of a large set of files from .htm to .asp but you were worried about other web sites linking to the .htm files? You could create a new redirector .htm file for every file you switch to .asp. Or, you can just download and set up this solution! Just drop this file somewhere on the web server (remember the URL), and then configure the Custom Errors settings in IIS (by default pointing to 404b.htm) to point to this file's URL. That's it!

I have searched psc for a way to put images on a access database and all that i could find was complicated code so i decided to do it myself and a few minutes later i have come to this...a simple way to store any file on a database field. Note that im not using BLOB field here.... Its simple and it works two most important things to me... hope you enjoy.

If your scripts are running too slow, it may be that you have a function that's taking too long to run or that gets called too often. This function profiler watches the all of the function calls and records how much time is spent in each function. All of the documentation is included at the top of the source code.

This is a Visual Basic Code Guide to keep track of all your Basic Code.. This is fra from Complete, so Suggest any thing yuo would like to be seen on it. And yes I know there are plenty of these on PSC.I wrote this foir my self and for others to learn not to just get votes.