Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > Database and Reporting > How do I access a database from my form???


Reply
 
Thread Tools Display Modes
  #1  
Old 03-08-2003, 10:25 PM
abrogard
Guest
 
Posts: n/a
Default How do I access a database from my form???


I am totally new to VB. But I've programmed in Access.

I've got a form. I put a text box on it. I want it to:

1. show a value from a table (in access, say) that already exists.

and/or

2. accept user input to write to a table (or even create it first).

How do I do it?

This question was too easy for the last area I asked it in.

Too easy for the MSDN help screens to spell out, too.

I hope it is not too easy for someone here to help me with.

regards,

abrogard.
Reply With Quote
  #2  
Old 03-08-2003, 11:22 PM
Wildbeliefs
Guest
 
Posts: n/a
Default

Hi,

You can do this in two ways:
1) You can either do it by use of an ado data control object that you would place on your form.
2) You can code it yourself.

The first way is by far simpler and quicker, but once you get experienced in database programming, you will 99.99% of the time choose the second choice and do the code yourself. This is because code gives you a lot more versatility, and is also more efficient.

I'm not going to get into the details of how to do it exactly. That's why there's a great FAQ in this forum (the second post in this forum called Frequently Asked Database questions). If you're still lost after reading the FAQ, then I can hold your hand and guide you through it step by step. But seriously, check out the faq, and if you still have questions, just reply to this.
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2000 HELP?? Database on server form problem from remote computer nfear24 Word, PowerPoint, Outlook, and Other Office Products 3 02-28-2003 10:32 AM
use Access to close another Access app strBean Word, PowerPoint, Outlook, and Other Office Products 20 12-20-2002 02:47 PM
Database problem for database Guru`s cballe Database and Reporting 5 08-08-2002 02:24 AM
User-defined type not defined (im new) skript_kiddie General 8 06-16-2002 02:06 PM
select Access Database from the User Form vbahelp Word, PowerPoint, Outlook, and Other Office Products 3 12-17-2001 05:37 PM

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
 
 
-->