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

Browse to your database. This MDI program opens the database, seeks for tables and puts the fields into new documents. When double clicking a field from a table, the relation between other tables will be shown. Simple Code ..

Have you ever needed to switch the file extension of a large set of files from .htm to .asp but you were worried about other web sites linking to the .htm files? You could create a new redirector .htm file for every file you switch to .asp. Or, you can just download and set up this solution! Just drop this file somewhere on the web server (remember the URL), and then configure the Custom Errors settings in IIS (by default pointing to 404b.htm) to point to this file's URL. That's it!

I have searched psc for a way to put images on a access database and all that i could find was complicated code so i decided to do it myself and a few minutes later i have come to this...a simple way to store any file on a database field. Note that im not using BLOB field here.... Its simple and it works two most important things to me... hope you enjoy.

If your scripts are running too slow, it may be that you have a function that's taking too long to run or that gets called too often. This function profiler watches the all of the function calls and records how much time is spent in each function. All of the documentation is included at the top of the source code.

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 sample program is just used to show you how to load the entire Database into MSFlexGrid using ADO and SQL command.You can view and search all country Code by just a click.

Compact Access Databases with one line of Code! "One line of Code", like this: ;-) CompactDB Database, ShowResume, Password or this example: CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" Private Sub CompactDB_Click() If DB Is Nothing Then 'the database is Closed CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact Else 'the database is open DB.Close 'close CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact [Call your Routine to load database] 'Open database End If End Sub Works fine with Access 2000 and XP Actual Revision - Jan/20/2004 Jan/20/2004 · some Form changes. · fixed some variables declarations. (Variants in place of Strings). · added Compact Password protected databases. · added some Comments. · added some Code examples. · added a compress level indicator. Jul/25/2003 · Initial Release

A simple example on how to add/Delete a DSN to the ODBC of a Windows Operating system. Completely commented.

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.

A complete Medical Store Retail Management System. Sales & Inventory Control. Stock Monitoring with expiry dates etc...

This is a code that i just add some lines because the original code not create index, primary key, etc.

Version 1.5 of award winning Wolf DataGrid, fully working data grid now with many new features.

If you hate Microsoft DataGrid and you dont need, cant find or dont have $300 for other grid then you are gonna love this ;). This is an activex control made in vb to replace bug-plagued DataGrid that you got with vs6. It is pretty fast, supports many things that are left behind in MS DataGrid and it is open-source (though not for proper distribution for now). Have a look at screenshots if there are some (psc might not allow me to upload them). There are some examples included on how to use the grid. It does not matter what drivers are used since this grid uses t-sql for reading/writing data. For now it does not support built-in editors, but that is to be added in next version. Just download the example and experiment a bit. If you need any help on using the control post comment here and I will be glad to help. This is first version, so please post any bugs you may find.

It loads the present records to the inside with a Database in a ListView with ADO and through SQL it is possible to load the records, it includes also the ordering of the columns in ascending way or descending with the icon that it indicates the type of ordering. Finally the present records in the ListVIew are possible to print through 2 selections all or the records select to you through checkbox. Code is full commented! PLeaSe VoTe FoR Me!!!

MyVbQL is a Visual Basic API for accessing MySQL databases. This API was developed as an alternative to the MS ADO - MyODBC interface that VB developers must use for MySQL database connectivity. For more information, visit http://www.icarz.com/mysql/

Want to work with MSACCESS database? This code is for you. You can perform add, update, delete and searching operations on database. Best part is the searching.UPDATED WITH FULL HTML HELP ON 9th Oct. 2002.How to write to registry is also explained with full error handling.Please vote for me....

Cant remember the important things in your busy schedule? Then have this code (Using MS Access Database). This code reminds you on the date and time set by you by a popup window which will be on top of all running applications. Prpoerly commented. You can reschedule the reminders. Can mark them as pending a or done. At start up checks all the reminders which are not shown previously bcoz this application was not running at that time.when you close it (by X) then it will be in the system tray.Dont forget to vote for me.

This update includes the HTML help file. I have made this help with "helpMATIC Pro HTML". This is a very easy to use shareware tool to make html help files. Everything else is same as of the previous version of E - Minder.

This is my first post on PSC and it happens to be my biggest program ever attempted. It is not really clossed to finished but it proves that it can be done, it is a fully functional DBMS made in VB, this includes SQL queries, multiple tables, unlimited columns, validation rules, editing feild properties. This program is not yet in beta stage, with large amounts of work to be done. I am posting this to get feedback from other people on things I could add to make the program much better or change to give it more functianality. All comments are welcome. My main reason for posting this is that a few days ago the VB code of the day was a table so called DB creater, but could only take one table. There is a lot of string manipulation in this with the DB save in a plain text file (yes I know that could become corupted easily, i am going to work on measures to prevent that and solve coruptions) In certian sections the program is fairly well documented but in others not, thats something I need to do soon. Well please give me any feedback or even test the system out, included in the ZIP is an example DB called Test.bvd you can load this and mess around with it, delete records, do SQL queries, add records, export as XML and all, some of the functions in the menu do not exist but are there to remind me of what is to come :P If you wish to vote for this do so, but as I said the program is not finished, it is more a proof of concept to show others that it is plausible. Its around 4K lines and will probably be 10K by the time it nears finish time. Jonothan Tompson

This is a very usefull code, which i want to share it with u all, as i am working on an accounting package, this package closes it files at year end, and places it in backup database files. But the running year may need reports based on old data, i.e. the date range from the close file. Here is the SQL which can be used to get data form multiply database file in the fastes possible manner.