Results for "Category: Databases/ Data Access/ DAO/ ADO"
The code demonstrates 3 common combobox tasks: 1.) Filling a cbo with a recordset 2.) Setting the cbo Text to a recordset field using a numeric rst field 3.) Setting the cbo Text to a recordset field using a non-numeric rst field
This simple code allows to make an auto-filled textbox (like an adress box in IE). This example uses an DataEnvironment connection, but it can be easy used in any other cases.
Converts the timestamp data type of SQL server into a string that is then suitable for use in a where clause
Haven't made a visual basic program for a long time. Made this for a place that I work. I haven't finished the program yet but couldn't wait to see any comments you make.
Complete ownerdrawn listbox with xp theme support, that can show and edit information from a database. Double click on text to edit the infomation.
how to use SQL to extract desired information from a database
Heres the update to my Address Book Example that pulls it information from an Access Database. I finally added the search and delete functions because I got tired of getting email from people asking me to write the update. :) Sorry it took so long but I've been busy opening up my office... Email any questions you have or comments to plexxonic@softhome.net
Easily Compact & Repair a MS Access Database and display the size differences.
Accesses any ODBC database using ADO. Records are displayed in a table withe rows that alternate colors. Paging control code allows the user to select which page in the recordset to go to. Current code has been tested with Microsoft Access and SQL 7.0.
((UPDATED!!!)) I commented the code and added a "Generate Character Stats" button on the Add Character form... I still need to add some rules for the generation. This is a new program I am just beginning to work on. I would like ideas on what to add. It is far from finished, but like I said, I would like some ideas. It uses an Access2000 database (included) and I have included an executable.
This is a new version. New additions include 2 types of code, one project-based the other snippets and functions. More settings added, including large or small toolbar icons, dock list on left or right, activate and maintain transparency. Checks to see if the program has run before, and if not, it sets up the default Registry settings, and if so, it just runs the program. Now asks for database location based with the default bein App.Path\codelib.mdb. I am starting to get more reuseable code. Combining forms and functions based on the type of code and user action. I will eventually combine the ViewCode and Add/Edit code forms for both types. It will require a full rewrite of most of the functions and redesign of the forms. Also in the works is the program's compiled HTML help file. I have almost completed the commenting of the Sub/Function purposes. Please bear with me as the commenting of the code is not the highest priority, getting a working, useable application is the priority. I have included two (2) versions of the actual database: codelib.mdb-Access 2000, and codelib-97.mdb-Access 97. Please leave me comments and questions on the code itself. Votes are appreciated, but not needed. I would rather have the comments.
Stores CD-Keys, serial numbers and registration information for software. This shows database functionality with viewing, adding, deleting and updating records using DAO as a reference. Also, shows using the database to authenticate users, a simple encoding and decoding mod is included to somewhat encrypt the data in the database. This is worth the look, even if you do not plan on using the database. Sorry guys, I only include the database structure, not data. No serials/keys included. That's illegal ;> No votes requested, however I do like comments on how to improve the code. I will be adding comments when I get the chance.
Very simple application that stores information about software. Stores Title,Serial#/CD-Key, Company/Author. Most significant thing is the use of DAO 3.6 to manipulate the database and write the report for printing. Code is commented, and clean. Limited error-checking and input checking. I do not plan on doing much more with this program, other than use it to keep a list of my own software. Please give me comments, votes NOT needed or requested.
New and improved database application for storing Serial numbers and CD/Product Keys. It uses DAO 3.6 (part of MDAC, downloadable from Microsoft) flex grid, simple encode/decode function for keeping the database "secure." Let me know what you think, I dont care about the votes. Sorry, but I did NOT include ANY actual serial numbers or CD/Product Keys.
Asynchronous Database Processing via Active EXE - When processing thousands of requests for a multi-user real-time application, you cannot afford to wait for the relatively slow database processing to occur. Here's the scenario: You have 1000 people already online and playing your multi-user game, and 10 people in the process of logging on right now. What do you do? You could process the logons right now, searching through thousands of user records, to load up their information - but then the game would appear to 'hang' for everyone already playing, waaaay bogus. You could process only 1 person at a time, in the main processing loop - that's better, but will add unnecessary slowdown to your program. What if you could log on the person in a BACKGROUND process, which wouldn't slow down the existing users? Ooh yeah. Or better yet, hand the request off to a machine across the network, dedicated to database processing? NOW we're talking! :-) You can do this easily, using Visual Basic ActiveX EXE's. Have fun with it!
Explains how to hook a 'lookup' combobox to a data field at runtime. Doesn't use the ADO control - uses pure recordset manipulation. Illustrates what the differences are between 'DataSource' 'RowSource', 'BoundColumn', 'DataField', and 'ListField'. M$ documentation is truly bad at explaining this topic.
This code allows you to connect to a SQL Server database without creating an ODBC Connection.
This project uses ADO to copy tables from one Access database to another. I did this up as a demo of ADO at work. It (probably) has no actual use but demonstrates ADO connection. This is my first submission, so please, Be Gentle!
These Functions will allow you to determine WHO is logged on to the Acces Database as well as HOW MANY users are logged-in. As always the code is FREE, if you want support can consult me in my professional capacity. ENJOY
This is a Class that encapsulates the ADO object Model and make life a little easier for Developers. I have included the SmartSQL class for which all credit must go to FreeVBCode.com The ADO class simplifies DataShaping, SQL, Connection Management, XML RecordSets and many, MANY more