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

this is a code to specifiy .MDB from your app not from properties it is just for a beginner...

This code will take data from the Northwind database and write it to an Excel spreadsheet. Code can be modified to do more complex reports, but the basics are included here.

This is the better way to find out whether your particular table, any table, exists in your database. Sequential is NOT the way. Check this out and let me know if you have any questions. Please give me a vote if you like this code :)

The Grading System helps maintain and organize a secure and dynamic database in an educational institution. This program was mainly a project for my VB class. I'd like anyone to give their opinions/ideas/advice on this program.

This small program is very usefull when you want to compare destination mdb file from your development mdb. It is not only compare the database (tables, indexes and queries) schema but also Fix It !, this prog use temporary mdb to hold the schema so you just bring this prog and schema file and compare it at your customer. if you like it please give me a credit!

Application to access Adaptive Server Anywhere databases. Uses CMAX OCX (http://www.compiled.org/files/115/259/cmax20.ocx). Uses RDO for data access. All other components are standard VB components. Help File not included because of licensing restrictions. Sub Main is in sqltool.bas. SQLAny.bas has data logic in it, and could be modified for other databases.

This program demonstrates how to access, modify, and save information from a Microsoft Access Database file, using a GUI. Users can add view information with a listbox, open a webbrowser to a contact's url, even send them an email using the default email client on their machine.

This is a Visual Basic Code Guide to keep track of all your Basic Code.. This is fra from Complete, so Suggest any thing yuo would like to be seen on it. And yes I know there are plenty of these on PSC.I wrote this foir my self and for others to learn not to just get votes.

This project demonstrates some code concepts such as use of classes, functions, passing variables, and registry control for setting SYSTEM DSN's under ODBC.

If you do any work with Access, you'll love this. It adds a sliding TreeView to the side of a form in MS Access allowing you to navigate through data

This is the code from a class module for exporting from any Jet database to any ISAM format out there. I think it neatly encapsulates the process, and uses properties and methods to make the process as easy as possible.

Simple, but effective. If you use MS Access for Client/Server apps, you'll never need to write another piece of code to display your reports, just add this form to your DB and it'' do the rest. Double click to open a report normally, or send it to Word/Excel or HTML format.

If you liked the Report Manager you'll love this. Again, it's very simple but effective. It allows you to manager both your Access queries and reports directly from a VB6 program, which sure beats writing code to do it. Have fun!

It allows you to import any .DBF file into an access database. You can choose the new table names, select individual fields, and create a new Access97 or 2000 database if one is not there already.

Give you an idea of how to store your friends information.Please rate me after downloading my work. Thank you! *version 1.1 is out

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.

Excel macro that extracts all tables, fields, field types, queries & descriptions from a JET/Access database. Very useful for documenting Access databases.

This is an Addition to my earlier search function. This is an ActiveX control. It has 9 search functions, inculding rich text box searches, and text box searches, DAO table searches, and Find and Replace searchs for all three. Has a readme file, that explanes all. If you find an error, let me know. This is my first try at making Active X controls. Please leave feedback!

Uses RDO to connect to 2 different (or the same) ODBC specified connections. Allows you to select tables on both sides and creates SQL statements to transfer the Data from the Source Table to the Target Table. Has the Option to Clear or Truncate the Target Table before Transfer. The 2 Tables must have the same amount of fields (of course).It automatically does the single quote thing for the fields that requires it. Easy to convert to ADO. Very nice , easy to use interface. The ODBC connection wil NOT work on NT , although minor changes can easily make this happen. Comments are very Welcome , even from critics.

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.