How do you create vb forms?
How do you create vb forms?
How do you create vb forms?
How do you create vb forms?
How do you create vb forms?
How do you create vb forms? How do you create vb forms? How do you create vb forms? How do you create vb forms? How do you create vb forms? How do you create vb forms? How do you create vb forms? How do you create vb forms?
How do you create vb forms? How do you create vb forms?
How do you create vb forms?
Go Back  Xtreme Visual Basic Talk > > > How do you create vb forms?


Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2000, 10:19 AM
shiatsu
Guest
 
Posts: n/a
Default How do you create vb forms?


Please, please can anybody help me as I am really stuck? I’ve created an SQL Server 7 database and would like to create forms to enter the data. I have managed to create forms using the form wizard for data that is from one table but I do not know how to create forms whereby I use data from multiple tables. The form wizard does not seem to allow you to select specific fields from various tables.

Is there anyway I can create a form “manually” using fields from various tables and with the functionality to navigate, add, delete and refresh the records?


If anyone could help I will be incredibly grateful


Shiatsu


Reply With Quote
  #2  
Old 12-20-2000, 11:08 PM
LafNGravy
Guest
 
Posts: n/a
Default Re: How do you create vb forms?

This is a tall order, yes it is possible to create one form that connects to multiple tables, but it is not something you are going to do with the form wizard. What you need to learn is how to connect to databases and how to create recordsets.

There is no real quick solution for your problem. I am guessing you are relatively new to VB?

If you want, I can help you, just send me a e-mail, but what you will learn will not be quick or easy at first.

Reply With Quote
  #3  
Old 12-28-2000, 09:08 PM
anhmytranHow do you create vb forms? anhmytran is offline
Senior Contributor

Retired Moderator
* Guru *
 
Join Date: Aug 1999
Location: Hartford, Connecticut, 06
Posts: 1,487
Default Re: How do you create vb forms?

You can use a fake MS Access database with the same tables and relationship with your SQL Server one.
Then create an Access Query that similar to the one in your SQL Server Store Procedure.
Use VB Wizard to create a VB form that works with MS Access Query.
Modify the form to work with SQL Server, in which you can place the SQL string in your connection, or you may call the store procedure from SQL Server.

This works fine, saving a lot of coding in VB, but you should create a fake database in Access first.

AnhMy_Tran
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
How do you create vb forms?
How do you create vb forms?
How do you create vb forms? How do you create vb forms?
How do you create vb forms?
How do you create vb forms?
How do you create vb forms? How do you create vb forms? How do you create vb forms? How do you create vb forms? How do you create vb forms? How do you create vb forms? How do you create vb forms?
How do you create vb forms?
How do you create vb forms?
 
How do you create vb forms?
How do you create vb forms?
 
-->