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

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

A powerful grid which was abandoned by the original author (Richard Mewett). As said by Morgan Haueisen "this grid is too good to let die". Now I want to support this grid as most of my application is using this for my master/detail and or parent/child form. This grid can support also any control which in my case I added a multi-column combobox. The primary purpose of this code is to learn how to integrate combobox and other control like datepicker, checkbox, etc. in lynxgrid. You will also learn in different way on how to save using a master/detail form. How to delete record in table which was deleted in lynxgrid control.

This utility allows you to easily update the structure of one .mdb file from another. It analyzes the source and creates the changes to the destination. It is a good tool for quick updates to multiple files. Please keep in mind that this was kinda 'thrown' together to serve my own purposes and is by no means a finished work.. it has helped me and I thought it might help someone else... :-)

It dynamically writes the code needed to create a new tables/fields in an Access 97 database. You simply add the new fields and it writes the code. This is particularly useful if you have an existing application and wish to add new supporting tables when you release new versions of the software. Uses CreateTableDef and CreateField. This utility has saved me a ton of time.

This code connects to a given SQL server and database and returns field info from a specified table. Handy if you need a quick printout of a table definition and you don't have time or patience to wait until EM has launched and connected to the server.

This copies, renames or deletes stored procedures on an SQL server. Also the ability to copy procedures cross database, or even cross server. This thingy is way easier and faster then the import/export wizard.

A report wizard which allows users to create their own simple reports and outputs them to a word doc. Includes sorting and criteria. I have modified this from Oracle to Access for demo purposes. I am also still working on it so any positive feedback would be appreciated. There are a few more things I would like to do like sort the Criteria operators according to datatype with, add totals. Feel free to use and modify. If you come up with anything good send it on!! This is the first app i have uploaded so I hope it works!!!!! Please read the attached readme file as there is a few things to do before the app works. i.e. add a query to a database.

Creating a user friendly error handler. This Friendly Error Handler pops up a VB liked dialog box to display error messages.

It lets the user compact any database including password protected ones. And it also over writes the old one. Uses no controls only API.

** Release 3 ** New cTREEVIEW features: Flat border; IsChildNode; CopyNode with cancel option; Cut Icon state. ADO example supporting: Load on demand; Find First/ Next/ Previous; Label Edit; Drag'n'Drop; Node & TreeView context menus; node specific Open/Closed/Drag icons. ADO Example now supports: New Nodes/Records can be added; copy treeview node(s); Cut/Copy/Paste through right-click context menu; and functions are now benchmarked with results displayed. ** Release 2 ** cTREEVIEW class features: Scroll treeview Up/ Down/ PageUp/ PageDown/ Home/ End using code; Dragging with auto-scrolling (not supported by Microsoft in the TreeView control); NodeFirstViewable; & NodeLastViewable. ADO Example fixes: Find Next/Previous didn't work if branches already loaded. cTREEVIEW class fixes: correct node drag icon displayed. cTreeview features include: fast clear a treeview; extended Add/Rename/Delete nodes; copy & move nodes through code &/or Drag'n'Drop including parent nodes onto child nodes (not normally possible!); find node using text and (optionally) key properties; check if a node is a parent of another; checks if a node is a root node; a safe get parent node text; right-click context menu (before/after click event); collapse/expand all nodes; collape/expand all child nodes; enable/disable redraw. This example shows how to:- work with multiple tables of data and load data on demand. As a bonus, I've included cDB class that encapsulates working with an Access Database using ADO. All code is heavily commented. If there are any routines that you feel are missing or code/bug-fixes that you wish to contribute, then please let me know and I'll add them in. *** Latest version can be found here:- http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=37553&lngWId=1 ***