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.

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 the only one ADO Boolean Search on Planet Source Code !!! [ AND / OR / NOT / AND NOT ]

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

This will show you how to code in Linux using g++.

A simple hospital system. Can add, update, retrieve and delete records like patient, ward, employee... I think it's helpful for those who want to know about how to update and delete record. Please give your comment so that I can improve on it.

Memory leakage is probably one of the most difficult programming problems to solve. This article tell you why, and how to do it.

response.write is okay for simple debugging but can become intrusive and cause formating problems itself. This simple script will display your debuging in a pop up window.

Creating a user friendly error handler. This Friendly Error Handler pops up a VB liked dialog box to display error messages.

A small script mixes ASP and Javasript to make messages alert or for the debugage.

The following function creates a user. You can execute it under any user you like. [email protected] (Dror Dotan A')

A short routine that backups the tables from an open Access database George Kinney

How do you avoid the "Invalid use of null" error when reading null values from a database?If you try to retrieve a null value (empty field) from a database, you will get the error: "Invalid use of Null". Here is one way to get around this problem: ..

How to copy a database table. This may require some tweaking.... "Bill Pearson"

An easy example of Searching for records in a database. I posted this code last year without an example so here it is.

Allows you to select a ascii file and import it into your database. Example provided!

This code demonstrates how to access a POSTGRES SQL database on a LINUX box via an ODBC connection. The demo ( using RDO ) shows you how to create a table, wipe a table, insert data, select data, modify data and write the modified contents back to the database.

Have you ever try so send a string variable to MS Access that have apostrophes using a SQL Statement? If YES you will get a run time ERROR Here is your solution....A function that formats the variable before sending it to the database.