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

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.

This program generates code for a Microsoft Access database that the user selects. The generated code will declare the connections as well as open and close the connection. This code has a lot of examples of coding with ADO and grids. I have lots of comments in the program.

the engine i am providing is an asp code generator that i am currently using on my website (www.intratelligent.com) to allow asp developers to upload access databases online and build simple asp interfaces to interact with their data. (insert / update / delete and reporting functionality).

Converts your code ISBN to Code Bar. Convierte tu codigo ISBN a Codigo de Barras.

Version 1.0.13: added some error handlign. NEW! Added functionality: now it works also with password protected access databases. Update your new database from your old database at amazing speed. The program updates all the tables from the old database to the new one. If you find anything faster than this please let us know. Enjoy

Everyone knows how time consuming and painful could be query code writing. This application is the MUST for all Database programmers who want to make their life a bit easier. The application allows generate and format chunks of code ready to be used in your application directly from Database. Start the Application and press Help button for further instructions.