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

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"

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

The following function creates a user. You can execute it under any user you like. dror-a@euronet.co.il (Dror Dotan A')

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.

This code creates a Microsoft Access MDB dynamically.

VERY VERY SIMPLE CRYSTAl REPORTS VIEWER - View Any Crystal Report with ease..lets you add reports to a list that you use all the time. Also allows for changing the parameter values. Very easy to understand code -- example report included. Hope you enjoy.

It is nice technique for dbgrid sorting.You can sort Dbgrid Columns by clicking on the grid column header in two ways ascending or descending.

This simple little function just returns the total number of records in a ADO recordset.

Ever wanted to find a special value in a database, but don't know in which table or field it's in. This tool helps you scan for a value in a database with 1 ore more tables in it. Only works on SQL Server. This tool can match exact or "LIKE" querys and has some other features. If you like it, improve it! :) (and tell me about it)

Dates in SQl queries often cause problems, as the date must be in the ANSI format whereas dates brought back can be in a different local format. This function simply returns the date in the required format and save having to type Format(DateString, "mm/dd/yy") every time.

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.

What you can do is hook up to a database, and with the use of a timer control, you can make a list of any/all records you want in a database. You can use an SQL statement (in the code already) to find a certain part of a string. The return results are any record that contains that particular string in it. Then with the click of a button it will go through each record found and make a list of them. For example, For a spell checker, I took a database that contained over 5,500 words. It went through that database in a little over 5 minutes to get every word made into a list. Very good ideas can come from this, have fun with it!

Convert a database table to HTML

This is just a demo for dBASE files. It will open any number of dBASE files and there is one function which can be used to get data from any of those .dbf files.

Personal email address book that opens directly the default email software, copies and pastes the address selected so as to be ready to write and send an email message. Useful when you use different PCs with different email software.

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)

Allow easy input and retrieval of images into an SQL database. Includes class file for easy implementation into your own program and a second project based on making the class into a dll for a IIS server. Will allow you to show pictures from you database on a webpage, input pictures into a database, remove the picture, retreive the picture plus more...

This code will dynamically create an Insert SQL query for a database. It also teaches some things like how to create a database and table though code, how to use the ADOX library, data formatting and etc...just look at the code, to much to write. Requires ADO 2.5 and was created with VB6 SP4. Not tested on anything else. Reasonably good commenting, should be easy to understand.

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