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

Analysis any kind of report from a company. Cash Flow Analysis Working Capital Analysis Ratio Analysis

The Code auto-resizes all columns of a DataGrid. The longest string of a gridcolumn is the new width of the column. Similar to this ListView- or FlexGrid- feature. I havn't found anything similar here, so I just want to put it in the codebase.

This is a nice program for Browsing through the MS Access file i.e. *.mdb. It works quiet fast comparatively. This shows you the number of tables present in the selected Database. Further it will show the fields in the selected table.Theres also a provision for seeing the whole selected table in the grid. Its quiet a good thing for using & even for the users who are not well known with the usage of Access Databases & dealing with the uncertainity tables into it.

my english is bla bla so try to understand my words first i want to thank mr.opal coz of the code he put here about the same thing printing flexgride. i want to say to mr.opal great mind = great code but vb has a great tool called DataReport what u need to deal with this tool is imagine take ur mind a way. if u don't understand my words u will understand my code.

A viewer and editor of a database with 10,000 computer acronyms.

This is a program that uses the ADODB connections to link to an Access database. All connections are created/opened at runtime. Security,passwords,usernames are in Database. Users are in two user groups. Uses SQL statements such as INsert, SElect etc. Links to website uses MDI form and Child Forms. Toolbar with Image list. Status bar that displays a random message. Data Reports using Datareport control. Class Module Example. ISnumeric validation. Search facility for searching the database. examples of using the List View Control

I created this for work to maintain a list of databases that we have for different product lines. It uses the Access 10 Object Library to perform this functionality "behind the scenes", so to speak. By doing it this way, you should notice a vast performance increase. NOTE: If you do not have Access 2002, this will not work for you unless you have msacc.olb registered on your system, but there are other options that work in much the same way.

A VERY simple guide to aid the beginner in creating a simple database.

Example shows how to connect to an Access database; browse, add, and delete records.

This is a real simple demo on how to use Inet's sockets.. This will make Inet run a lot faster when you need it to execute a lot of stuff at the same time.

I worked really hard on this for my VB2 college class.. I got a REALLY good grade and even my teacher said it was the best she has ever seen.. I am really proud of it and I hope to get more out of it by giving to everyone to help them out on ideas and what not. I spent about 100+ hours on it but it's not perfect. Had a last minute crash and had to do some crappy coding.. But, I spent most of the time on the GUI.. It uses Flash, Nicer Looking Buttons, CoolXP, Listview, MDI, etc. I hope everyone enjoys it! Please, Vote or Comment! Thanks...

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.

This sample code is an example of how to put text and graphics into a richtext box on a form and then save that information into a database. The example uses MS Access, but should work with SQL Server as well. I needed this for a specific purpose and when I could not find any examples, I created my own solution. Use this however you like there are no copyrights on the code.

Using this code You can easily backup your sql database. There were some code here that used ADO for the backup purpose, here in my code i have used the SQLDMO object for all the sql transactions. Few code are taken from here and are upgraded with comments. Hope you all would like the work

Database Operations Using Automatically Generated Class This is demo application that demonstrates powerful database functionality of database class automatically generated by CLASSter 2.0. Demo is for MS SQL Server, but CLASSter supports now MS Access, Sybase and Oracle server. Powerful features implemented by class - executing stored procedures, parameterized SQLs, multiple recordsets, batch execution, XML processing. The class code shows full implementation of these features

Unfinished video rental proj.(currently working on int) Shows you how to make your code multi-tier ready, reusable, how to use class, how to dynamically add toolbars, this is kinda basic but will help begginers to intermediate! I like the way PDSA codes that's why i pattern my code to them :) Begginners if you like my code or learn from my code pls. vote!

Clinic Management for Doctors

it is hospital lab management system,manage the patient profile and their diffent Test record

Flex Grid is Made to be More Flexible. A editable Flexgrid with textbox moving along to cells on a click or a cursor movement:)

Tired of seeking through your hard rives to find Access databases, to compact them and gain some free space? Then this tool could help you. Basically it parses all the directories and sub-directories of a given hard drive unit, and tries to find Access Databases. When this operation is done, you can repair or compact them. I gained on one of my HD unit over 6Gb of data. What you need to make this project work: vbalSGrid6.ocx and ssubtmr6.dll fro vbAccelerator. These files should be in the libs directory. If ever they had been removed then, just go to this url: http://www.vbaccelerator.com/home/VB/Code/Controls/S_Grid_2/S_Grid_2/VB6_SGrid_2_Binary.asp 1- Open a blank project. 2- Goto to project -> references and select ssubtmr6.dll, it should register it for you. 3- Open your the test project (an error should appear), then goto project, components, and select the vbalSGrid6.ocx 4- close the test project. 5- restart it it should be ok. You'll also need Microsoft DAO 3.51 or 3.6 (depending on the Access version installed on your computer). Generally 3.51 works well with Ms Office 97 databases 3.6 or above should suit best to newer versions of Access. I'm currently using Ms Office PRO 97, and thus for referenced DAO 3.51. If you have troubles or do not understand how to make this thing work, don't hesitate to send me an email.