Wrox Programmer Forums
|
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 3rd, 2006, 01:49 AM
Registered User
 
Join Date: Oct 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to use Spread in VB

Hi,
Im just started using VB.
What is Spread and how can I apply it?
Is there a free spread software
or do i need to buy it from specific vendors?





anne
 
Old October 3rd, 2006, 01:06 PM
Friend of Wrox
 
Join Date: May 2006
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Farpoint Spread is a grid or spreadsheet control which is bindable to a data source.
There are numerous other brands of similar controls as well.
These are GUI controls that are displayed on a form, and are configurable and programable to provide a "rich" (and sometimes confusing) user experience. Anyway - there are similar controls that come with VB6, such as the datagrid and the flex grid. These are scaled down versions of the more powerful commercial third-party products.

To use one of these you:
1 - Buy it or get an evaluation version if you don't already have it.
2 - Install it on your development box if it isn't already there.
3 - Add it to components toolbox
4 - Drag it onto a form
5 - Set its properties
6 - Write code for it

Thats about it. It can be very complex to get easy to use (and useful) functionality out of these things. Learning to use them isn't all that hard, but with some of them there are a lot of properties, events, and functionality available which makes them powerful and flexible, but it can be hard to learn how to make them work well. However, they sometimes are the only reasonable way to provide features that would otherwise take a lot of work to accomplish, and they are generally easy enough to get the basic features working reasonable well.

I have done a lot of consulting on projects where a number of various third-party controls were used to provide a complex UI but had ended up with serious problems. When I review the project the main issue I see usually has to do with using the databinding features of these controls. It seems so simple and clean to just hook up to a table or view and allow users to edit things directly in the grid, but this often leads to all kinds of issues if it isn't thought through properly.

So... have fun!


Woody Z http://www.learntoprogramnow.com
 
Old October 3rd, 2006, 07:30 PM
Registered User
 
Join Date: Oct 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you. Your reply was very helpful. :)

anne





Similar Threads
Thread Thread Starter Forum Replies Last Post
format report like spread sheet michael193nj Access 0 March 19th, 2008 05:17 PM
Create an Excel Spread with multiple worksheets hewstone999 Access VBA 1 March 7th, 2008 08:21 AM
SPREAD SHEET pallone Javascript How-To 12 June 27th, 2005 10:36 AM
Archiving excel spread sheet in zipped form Hudson40 Excel VBA 0 January 5th, 2005 12:33 PM
save Excel spread-sheet to SQL Server ybao Classic ASP Databases 1 July 12th, 2004 03:02 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.