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

I started this application in order to gather somewhere all the code I receive every day from Planet Source Code (actually I gather the URL’s). There are a lot of improvements in this version, plus some bug fixes. Some of these are: importing PSC e-mails directly from the net, importing PSC e-mails from Outlook, better error handling and trace routines. Check out readme.htm for more details. The database now contains e-mails from Dec 14 1999 until Jun 19 2000. I have change (again) the database, so be careful.

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.

Example on how a template can drastically accelerate development time for a Database app. With this template, you just have to drop the text controls you want on the form, modify their tag property (see file _Notes.txt) and modify the SQL string that the form uses to get data and voilà. The code will take care of the MoveFirst, MovePrevious, NewRecord, MoveNext, MoveLast, SaveRecord, DeleteRecord, Undo, Requery, EditRecord and CloseForm. It will automatically enable/disable the controls based on what the user is doing and his location in the rescordset. There is even options (in the tag property) to set default values and field validation (alpha or numeric). Since it's the tag property that drives most of the features of the app, the code is very portable/reusable. The template only uses UNBOUND forms (i.e. there is NO Data Control) and is well commented.

This code creates and maintains a database of multiple users that may use your program. This supports user flags that YOU specify and define as well as a checkpoint system that YOU build! Documentation and sample projects included.

select any access database then select the table you want then select and insert any fields to a richtextbox then preform a mail merge like MSWord. you can then browse through the database while viewing the merged data.

This is an advanced autocomplete function that will autocomplete for a textbox, a listview control or a listbox all from 1 function. I have seen code on this site before that had inspired me to create this function since I need it in a lot of my projects. I tried to comment everything as well as I could. if you have any questions email me and I will do my best to help you. oh yeah - Please vote for me if you like this code. thanks

Since MS-Access doesn't support accent insensitive queries by itself (MS SQL Server does as far as I know), I had to create a function that would fix the problem. With this function, it is possible to turn any SQL query into an accent insensitive query. With a few little modifications, it works great with ASP too!

Well, I was trying to make a address book and I couldent think on an interface. So I thought for like 1 hour and I made one and I decided for thoes people out their that want to make an address book, that they could you my interface! If you use this please give me credit and you can re-arranfge it, and do aything to it!

Created for a barcode scanner. it stores the price, barcode and product name for an item. You can do a search for items by product name or by barcode. Also has an attempt at a registration enabled program which requires a valid username and password to register the program.

This sample project enumerate all active SQL servers in LAN using ODBC function SQLBrowseConnect. This method is working both for NT and 9x based OSes. The behaviour of this ODBC function is changed in MDAC 2.6 to include all SQL Server instances found on each machine. In MDAC prios 2.6 it's enumerating servers listening on named pipes while after this release its using NetBIOS broadcasts over TCP/IP to receive response from the active servers. The code is compactly written in decoupled module and a form. The module is easy to be recycled in projects of yours and the form can be studied as a sample GUI to it. Enjoy!

The problem with Access databases is that when you delete records, the .MDB file doesn't shrink. It just grows and grows and grows – until someone either compacts it or you run out of disk space. This tip will show you how to compact a JET database up to 100 times!

Provides a wrapper around ADO future proofing your code and making accessing your database much easier. Ensures all your code is standard and uses the best data base access techniques. Also provides functions to convert a recordset to HTML or CSV format - handy for web pages as well as client/server applications. WOULD love your feedback, feel free to contact me directly or submit comments.

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.

This is a family address book program created using VB6. Its main purpose is to store personal address book information for each member of a family. THIS IS AN UPDATED VERSION OF THE ONES THAT I CREATED SOME TIME AGO. THIS VERSION HAS ALOT MORE FEATURES SUCH AS PRINTINING / SEARCHING, Personal Internet Links ETC. IT ALSO USES THE LISTVIEW AND TRE VIEW CONTROL TO GIVE IT A BETTER INTERFACE. REQUIREMENTS Microsoft Windows Common Control 5.0(SP2) - COMCTL32.OCX Microsoft DAO 3.51 Object Library. Please write any question comment or suggestion. Tell me if you find any bugs. Note : Read the file readme.txt before you begin using it. If you are running the program for the first time you have to allow the program to Create the Database file. Filesize : 296KB. CHECK IT OUT!!!. Author : OmarSwan.

This is an application that allows you to connect to a database and view all the properties of a stored procedure and writes the VB and ASP code for you to run each particular sproc you are viewing. It is a pain to have to write wether a sproc parameter is inout or output and what type of parameter and what is the max length...etc. Just point to the sproc and all the code is created. There's even setting based on how you would like the code written for you.

This program demonstrates how you can take a table from a database (MS Access only in this demo) and convert all the records in that table into an HTML document for viewing in a web browser. With very little effort, you can add more HTML tags, more records, etc to have a really nice looking web page. I'm working on one that will use SQL statements to get certain information, instead of the whole thing. The code is well commented, and any questions can be directed to me

Read a list of Stored Procedures from a SQL 7 Database and pull their parameters out and format them into code that can be pasted into a code module. This can save a ton of time if you have sprocs with over 20 arguments.

This article attempts to explain the Microsoft Jet collections and how you can use them in really useful ways. If you don't know about Jet collections, this is well worth reading.

This code will create a database and produce a document that contains all of the table and field parameters. This is the first part of a series that will show how to use a single program to dynamically deliver any type of interactive multimedia courseware whether it's Computer Based Training(CBT), Computer Assisted Instruction(CAI), or an Adaptive Evaluation and Examination System(AEES) with all of the information being read from a database.

Sorts the records in a datagrid form when clicking on the column header. Toggles between ascending/descending sort order.