Results for "Category: Databases/ Data Access/ DAO/ ADO"
Allows users to select any DSN-less ODBC data source, or an MS Access database, to display the tables in it, and select a table, which is automatically loaded into an Excel spreadsheet, complete with column headings (field names). Based on project submitted by Ian Mitchell: http://www.planetsourcecode.com/xq/ASP/txtCodeId.25934/lngWId.1/qx/vb/scripts/ShowCode.htm I just changed it to use ADO instead of DAO, and DSN-Less ODBC data sources, instead of just MS Access. Slight modifications (error handling etc) on august 9, 2001
Finds SQL Servers on your LAN
If you're ever wondering what's contained in a recordset you currently have open, here's a quick and dirty way to dump all the data you could want to the Immediate window, which you can view there, or copy and paste into a notepad document or other textfile for printing, etc. I like to keep this somewhere I can quickly copy and paste it into any module or routine that uses a recordset in case I lose track of which field is which. (I've only tried this with VB 6.0 and AO 2.6, but I imagine it would work with other versions.) --Brian Battles WS1O Middletown, CT USA
CompactAllMDBs is a Microsoft Access 2000/2002 (XP) application that will (1) Search for all specified files (default is .MDB and .MDA files) in a specified directory (and optionally, in all subdirectories below it) (2) Display all such files found in a listbox with their sizes (3) Compact all the files it found or only the ones selected from the list by the user (4) Search for the same files it found the first time and compare their size as compacted with their original size, to see how much disk space has been reclaimed It's handy to keep your ever-inflating MDB files of a manageable size, and it works nicely on networks. This can't really eb smoothly ported to MS Access 97 because it uses ENUMs in the code, which isn't supported by VBA in Office 97, to my understanding. Also included: (1) A simple routine for calculating and displaying elapsed time for the process down to milliseconds. (2) A "Browse For Folder" routine, based on a Windows API call (I originally wanted to make this start with a specified default folder, but I haven't had a chance to figure out how to do that yet) (3) Uses the Access (2000/2002) routine to Compact and ReCompile the application when it's closed down. In your VBA code, this application requires a Reference to MS DAO 3.6 library If you have any comments or questions, drop a note to brianb@battleszone.com
Undocumented Trick for calling stored procedures in vb using ADO
This application will take any table from any database, and converts it into a HTML page, with nice looking tables. I have included a database with the entire 2000-2001 hockey season schedule as an example. The user can then view the schedule for any given date and convert it into a HTML page. Good idea if you're a hockey fan and want to update your page with the games scheduled for the day. Please remember to vote for me!
This is an updated version of a previous project, to demonstrate the use of a MSChart control with ADO to show scientific data. Some other tricks are shown... A newer version will be coming out very soon to teach DML with ADO.
This application was written with the intent to serve as an example of how to use the MSChart control that is shipped with Visual Basic. I've found out, the hard way, that the documentation for Microsoft's chart control is poorly written, if not totally useless! This example might be silly but I garantee that it will help you understand how to manipulate and create graphs, specially for those who work with scientific data (like me).
A complete Database application. Based on ADO Database.It has some new mathematical features. I used here FLEX GRID. Moreover coold design. For more code Please Contact with GENERAL CORPORATION BANGLADESH didar911@yahoo.com tahmina911@yahoo.com
A Simple Love Calculator.. Just Fun.... For more code Please Contact with GENERAL CORPORATION BANGLADESH didar911@yahoo.com tahmina911@yahoo.com
I just put a bunch of controls on a form to play around with it and thought others might be interested in looking at it. Basically it allows you to conect to a mySQL database and ADD, EDIT, and DELETE records. You will need to create a table in mySQL called feedback with the following Fields. Field username Type varchar Size 50 Field emailaddress Type varchar size 50 Field subject Type varchar Size 50 Field message Type Text Requirements: This program requires that you have mySQL loaded somewhere you can connect to it. You must also have myODBC loaded on your machine. This program uses Windows ODBC 0to connect to your mySQL database. Written in VB6
Megacomputing - Waren Sortiment, enables yor Store your Sortiment, Computers Hardware etc in a database, with price EK _german buy price , and Sell price VK it wars prog for my hardware store i need it ************************************************ Updatet: Some bugs Fixed.
Address Book XP is a contact management and address book organiser. This program currently supports user logins, reminders and some advanced uses of Access XP and 2000. This code was designed for Windows XP with Office XP or 2000. It hasn't been tested on other machines yet but hopefully you guys and girls will be able to help with that. There is a lot of work that needs to be done with this code such as a suitable search engine and some user managemet. If you feel you can add to my program, please be my guest, as long as you mention my name somewhere in there. Comments will be greatly appreciated. Tom
response.write is okay for simple debugging but can become intrusive and cause formating problems itself. This simple script will display your debuging in a pop up window.
It's not true you can't use Seek with ADO in Access.
This code will let you repair and compact an Access 97 or 2000 (haven't tested on other versions yet) database. Using JRO, when you call the CompactDatabase function, it automatically repairs the database first. You must have a reference to Microsoft Jet And Replication Objects x.x Library in your project. Also, where I have a DoEvents in the code, there really should be some routine that checks to see when the file is actually deleted. I've tested this on databases that are about 5 megs in size with no problem. If anyone has any ideas (maybe a routine that checks to see when the file is unlocked or deleted), let me now. Thanks and enjoy!!
This code snippet will show you how you can convert an ADO recordset to a delimited text file in just a couple lines of code using the ADO GetString Method. You can easily export a recordset to a csv file using this method.
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.
This code is used to store, track, research and share recipes. I got the application about 8 months ago from PSC from a posting by Bob Davis from Tallahassee Florida. I loved the concept and some of the recipes were cool too. I really liked what Bob did but since I'm a database programmer I had some challenges that I was interested in tackling with regards to his initial design (plus I was board) so this is the result with a few added plus's that my wife dreamt up. There is one thing that is bothering me about this application though and maybe you fellow coders can help me out. For some reason I cannot distribute this to any family members or friends without installing VB6 on their computers. They are using 95B and 98? I have traced it down to the Data Access pieces for the errors (particularly the compact and repair commands). I have installed the MDAC on their PC's and it does not work until I install my copy of VB (Pssst, Please Don't Tell Bill). If you have any advice or critisisem, go ahead and let me know because there is always a better way, a different perspective or something that everyone did not think of. Pardon some of the not so neat code. ;-) Best Regards, Tom Williams
Save binary objects to a DAO database, eg: pictures, exe files, dll's etz. Its a generic class module that allows saving/extracting from any access database. Also gets additional fileds if required for example a persons name if it was stored in the same table