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

Print a crystal report in a certain date range

Have you ever try so send a SQL String to a database that has apostrophes ? 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

Fix Apostrophe in strings for SQL query

Heres a good example of using a winsock control to access a ADO database over a network/dialup connection. You will be able to access the database fully, with Add/Delete, Read/Write access. Also i have inbedded authentication against the database via the winsock control. This program is simply for basic job tracking, from inhouse, and for remote access areas. Bascially how this works, It sends the server a few commands/strings, and the server generates the sql statement and sends back the results, to the client winsock application, it then recieves the information and displays it out into a listview control with columns. --------------------------------If you like the code please vote!

Provides a simple to use, yet useful phonebook/contacts program. I have gone through and sussed out pretty much every bug I could think of, see if you can find any!

This program generates code that will open and close an ADO connection and recordset. There is also an option to generate navigation code. There are several other options which allow the user to select cursor style, cursor location, and locking style. Note: This project is an add-in. In order to use it, load the project, go to file and choose make ADOToolbox. Then load it from the add-in manager.

UPDATED: Added better error handling just to be safe and neater... Also added more sound so all commands have a sound and upon loading a 3 second wav plays also... Great for learning how to add sound to enhance your program...Great for newbies to learn from...My first ADO database, i learned from tutorials on here specifically from Jerry Barnes so i think this would be great for people new to ADO databases to learn from but i suggest finding Jerry Barnes ADO For beginners source because it is incredibly commented on and will surely have you creating ADO within 20 minutes. I tried my best to eliminate any bugs but of course there has to be some somewhere... I also used sheridans active listbar for this program, the ocx is packed in witht he zip. Please let me know if i didn't include a needed ocx,file or just if something doesn't work right so i can fix or at least try to fix it. This took me awhile to make so please at least vote for me. Fixed a bug witht he extra button caused by a incorrectly placed setfocus, also fixed abug with the edit option displaying when save was pressed and causing an eof and bof error after the person tried to edit after re-opening the database later. Fixed a lot more bugs in this newer zip. -- IMPORTANT: Password for login is chris

We had a client who 'accidently' copied one databse table into itself causing duplicate records. Unfortunately Access only allows 10 columns in its De Duplicate wizard and we had twenty! This code allows you to pick the database you want deduplicating, lists the tables and the fields within the table so that you can chose the 'key' fields to deduplicate on. Then it creates a table within the database which contains all of the deleted duplicates from the table you chose. It assumes that you don't mind which instance of a duplicate record you want to keep and it uses Jet 4.0. Also if you run the appliaction twice on the same table you will loose all of the deleted records from the first session (it dosent create a second instance of the deleted table). It also dosen't contain Error trapping as I use Aivostso's VB Watch addin that creates error trapping for you. However, leaving that in would add superflous code so I have omitted it here. This code was wriiten on the quick but it has ben used in anger with correct results. Any constructive comments will be appriciated.

This Module allows easy connection to SQL Server 2000, ODBC, Access 97 and Access 2000 databases. The code is well commented, so may also help a beginner to get started with DB programming. If you use it, please rate it, and i look forward to any feedback you might have.

A Quick & Easy Search routine for ListViews AND Recordsets -- hand in hand. I find that a very nice pair-up in interface and behind the scenes action is the DAO set in conjunction with ListViews. To some this may already be apparent, to others perhaps not. Copy this code in, using the correct DAO refs and the correct ListView, pass the three parameters in, and it should work like a charm. Don't forget to vote for this code. Updated / Patched - 11/4/01 Check out this screenshot ->

One of the most wanted feature from users point of view in MS SQL Server is capability to generate INSERT scripts for MS SQL Server data. But call it Microsoft's ignorance, this feature not supplied since quite long. And even worse, there is no public domain application to do that. This feature is usually desperately required in situation like sending test data to somebody or supply sample data. So I decided to write my own. It's still isn't the perfect and can't handle all of the possibilities but it could be your best bet with supplied source code! This application is right now in state of easy installation but no on-line help is available. You may freely contact me for assistance however.

This class adds AutoComplete functionality to a textbox. You start typing and the class searches for a record that starts with the letters you typed, if it finds one, it completes the rest of the textbox with the record.

The prodram look just like Access, so don't be mistaken. IF you won to learn how to work with databases- the answer is Quarantine DB. The program uses ADO and DAO. With QuarantineDB you can work with, create, delete, rename tables and queries, add, delete, update records. You'll learn how to work with MDI form. Just try it and don't forget to VOTE FOR ME. e-mail : [email protected]

This project is based on CODE_UPLOAD1185011192000.zip. I added a Class structure to the Server and added some other checks. This upload is a Multi-User Server/Client project. The Server has also a very reduced sort of database behind. Every user can create one or more buffers which should act as a one-dimensional recordset. The buffers are being filled by a simple Selection statement. The purpose of this work is to figure out if a simple database server could be built up in this way or if you have to do it totally different. I'm actually looking for some critics to understand why this is a good way or why not. So please give me comments. No votes needed.

This program is designed to teach the user how to load data into a FlexGrid from an Access database and then manipulate the FlexGrid to perform typical database actions such as Add, Edit, Sort, and Delete. The database manipulations are executed with ADO methods

Helps to maintain credit customers, with the details of bills and outstanding balance, etc. Useful for small companies, total solution. No need to purchase big software which has got too much unwanted functions for which you don't need to pay for. The code has got very useful stuff like managing ADO DB, creating reports, etc... hope you like the code and most of all the application. Most of the reported bugs are fixed (which were a few ui bugs). Check out now the update.

This OCX will helps you to retrieve all types of images supported by the Visual Basic Picture box in one line of code. It save it to- and read it from an access database. It support Ado and DAO. You can browse for photo images on your harddisk with the filebrowser included into the OCX. This browser also remember the last directory. This code is well commented. Just click on the ocx, drag it on a form and start programming. This code has not been tested on SQL server jet. I've included a sample application to show you how it works. I hope it will be an attribute to your programming needs. For any comment mail me at [email protected] Have Fun. Rodney Godfried

This code will allow you to populate DBGrids and other bound data controls using a Data Control, SQL, and an ODBC DataBase.

The project has two forms. Both displays charts using mschart control for a data from access table. One form displays a chart(2D BAR) for the first record of the table. The second form displays a chart(2D BAR) for a set of records. 1.Both the charts displays legends. 2.Both the charts displays titles for X and Y axis. 3.Both the charts accepts a title to the chart at the desired location. 4.Both the charts displays data values at the desired location above the data points of each item. 5.Above all, the second chart(in the second form)displays bars in the charts dynamically as and when records are entered. i.e., if there are five records, five sets of data series will be automatically displayed. 6. Column labels and row labels are named in the code itself. 7. Filling colors to each data series is mentioned in the code. To summarize, a customized graphical representation of a set of data from an access table can be created by any user.

This is a veeeery simple code to make one autocomplete textbox that gets the first letters you typed and searches for the most similar word from a table and then completes the rest. No API Calls, No Classes, Only few lines of code in 2 events...Simply save it as a module (.bas) and add it to your project