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.
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.
Connect to SQL Server Database ,and see all tables and columns in Treeview , Datagrid. All Stored Procedures ( Names and Texts of SP ) , Triggers ( Names and Texts of Triggers ) Views ( Names and Texts of Views ), Defaults ( Text and Name ) , Constraints ( Text and Name ) Primary Keys ( relationships ) , Foreign Key ( relationships ). Search Engine , Combo1 > TableName | Combo2 > Column Name , Criteria >> with each letter (or any other character ) you type , you will narrow the result. Direct Connection to Enterprise Manager ( with SQL Namespace object lib ) . You can perform full administration and implementation of SQL server and every Database ( if you have those rights ) : Create Trigger , Stored Procedure , Role , Rule , Default , User def. Type. Find out about Table Properties, Permissions , Dependencies,Delete Table. You can use EM interface for Generate Scripts , Manage Indexes . You can call EM interface for managing SQL server security, New Db user, and use EM's wizards for Import and Export DTS . Everything is commented and Constants are attached in two Word .doc files. With Query Builder you can perform very complex queries , Create tables , Update , Insert , Delete . It supports T-SQL commands , so you can perform (almost) everything as you can with Query Analyzer. Sample Queries , are attached as comments inside module. How to manipulate , easy , with more recodsets at the same time. Practically , this is simple console for administration and implementation SQL Server database ,with using full power of EM. I hope that You can find this app. useful . If so , vote. 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!
Improved code production, index/relation handling and now supports Queries. Database Coder analyses an Access Database and produces the code to create a blank copy of it. Supports Tables, Fields, Indexes, Relations and Queries. Interested in comments. Updated 26 May 2000: Improved handling of default field values and minor bug fix.
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.
Hi,Family Address Book v3.0 - Final Update has been released on October 03, 2000. Please don't be fooled by the name, it is not just a simple address book - check it out and you will see. This time around I mostly use ADO instead of DAO and now the user is allowed to add or remove any category of their choice. DAO is only used to create the database, every thing else uses ADO. It has a lot of features such as Personal Contacts, Personal Internet Links, Search and Printing, Personal Reminders and also Sending Email using the vbSendmail component found on http://www.freevbcode.com. Please read the file readme.txt before you begin. All the source codes are included so you can compile the code for yourself. Please leave your comments or feedbacks And Remember to VOTE!!!. Last Updated : October 03, 2000. The ZIP File Contains a SELF-EXTRACTABLE FILE with the Source Code. If you hav any suggestions for the next version please let me know.
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.
Hi, This is new version of a family address book that I released some time ago. Please don't be fooled by the name, it is not just a simple address book - check it out and you will see. This time around I mostly use ADO instead of DAO and now the user is allowed to add or remove any category of their choice. DAO is only used to create the database, every thing else uses ADO. It has a lot of features such as Personal Contacts, Personal Internet Links, Search and Printing, Personal Reminders and also Sending Email using the vbSendmail component found on http://www.freevbcode.com. Please read the file readme.txt before you begin. All the source codes are included so you can compile the code for yourself. Please leave your comments or feedbacks And Remember to VOTE!!!. Last Updated : October 03, 2000. The ZIP File Contains a SELF-EXTRACTABLE FILE with the Source Code. Note : the bugs with the vbsendmail component has been fixed. If you have any suggestions for the next version please let me know.
Hi,Family Address Book v3.0 - update 3 has been released on September 25,2000. Please don't be fooled by the name, it is not just a simple address book - check it out and you will see. This time around I mostly use ADO instead of DAO and now the user is allowed to add or remove any category of their choice. It has a lot of features such as Personal Contacts, Personal Internet Links, Search and Printing, Personal Reminders and also Sending Email using the vbSendmail component found on http://www.freevbcode.com (DLL File include in this ZIP FILE). Please read the file readme.txt before you begin. All the source codes are included so you can compile the code for yourself. Please leave your comments or feedbacks And Remember to VOTE!!!. Last Updated : September 25,2000. The ZIP File Contains a SELF-EXTRACTABLE FILE with the Source Code.
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.
Sorts the records in a datagrid form when clicking on the column header. Toggles between ascending/descending sort order.
This SW allows you to create complex SQL sentences, working with the Dictionary of the Data Base in use. This sentences can be saved to use it later. IMPORTANT: This SW was made in Spanish. As I drop the source code, change it to English is easy. Advances: -Works like the ISQL command. -You can select the number of records to be recalled, and the timeout. -The response will be separated by ASCII 9. Pass it to an Excel Worksheet to work with the results. -You can create the masks for: insert, select, update, delete of the tables. -You have a create table/index template. -The sentence can be converted to a string to pass it trough the clipboard onto your VB project. -You have an internal buffer, to work with two 'clipboards'.
This Project is an example of how to open a file into a byte array and save that byte array to an Access database, and to extract binary data from the Access database back into a byte array and save it back to a file. This example uses .bmp and .jpg graphics files but with minor modifications any type of file can be saved in binary format to a database. again this is only an example application. I threw this togethor in a couple of hours so there are some minor bugs in the code. a little bit of error handling should clear them up. Hope you find this usefull