 |
| VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the VB Databases Basics 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
|
|
|
|
December 1st, 2005, 12:09 PM
|
|
Registered User
|
|
Join Date: Dec 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
VB6 +EXCEL2003
I should be grateful for code to declare an Excel Database in a VB6 program, and code to access a particular Cell in the Excel File.
Thanks
Dani
|
|
December 2nd, 2005, 01:15 AM
|
|
Authorized User
|
|
Join Date: Nov 2005
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
That means, u wanna go for Database programming with Visual Basic 6, right?
Do only one thing, in Open VB6, See the tool bar which containing File,Edit,View.. In that Toolbar, click on Project -> Components -> check the box "Microsoft Hierarchical Flex Grid Control 6.0(SP4), click OK..
then see ur "General" Tool bar on left side, click on "MSHFlexGrid", drag to ur form, then press F1, It will open MSDN page containing "MSHFlexGrid Control", learn it properly, u will get all ur answers from there..
Especially, see Methods, there are 14 methods..
~~Dev~~
|
|
December 2nd, 2005, 12:04 PM
|
|
Registered User
|
|
Join Date: Dec 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Dear davekrunal,
Thank you for your instructions. This does not solve my problem at hand, but it solves another problem I ran into some time ago with data entry.
My problem is that I am working in a voluntary organization. The Membership Database has to be in Excel, because my fellow mwmbers, the Purser, the Chairman and others who have to see the data, do not know how to use anything else - like Access.
To do all the work (we have by now over 2000 members and growing fast) in Excel is very tedious.
I have written a program in VB6 to check names, to check for duplicates, to find couples who are subscribed in order to save postage. Not being able to read and write to the Excel File directly I convert back and forth to Tab separated Text files which is also tedious.
All I need is the code a) to open the Excel file and b)to read and write to a particular cell.
|
|
December 3rd, 2005, 01:38 AM
|
|
Authorized User
|
|
Join Date: Nov 2005
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
See First of All, you have done mistake by using Execel to manage a database for more than 2000 members.. My advice is, use Microsoft SQL Server or Oracle, I am using Microsoft SQL Server, where u can make ur table very easily with Query Analyzer or Enterprize Manager, Do one thing, Go to Enterprize Manager and Using HELP, learn how can we create tables and all that, and for your duplication problem, in MSSQL/SQL, it could be solved by just single key word called "DISTINCT".. To be Frank, I do not have idea about Excel, but in our P2P Forum, there is one more category called "Database", might u get some help from there..
Best of Luck..
~ ~ ~ There is no Right, There is no Wrong, KNOWLEDGE is Only the POWER ~ ~ ~
|
|
|
