In visual basic , how to store data or retrive data in or from a various tables
I m a beginner in visual basic , now i had a doubt that when i store or retrive data from a table it is possible for me.
but storing a data or retrieving data from different table it show error , it blocks, it stores one table data and says error for other table as object required
An expert who has achieved level 2 by getting 100 points
An expert who has answered 20 questions.
An expert that has over 10 points.
An expert whose answer got voted for 2 times.
Re: in visual basic , how to store data or retrive data...
You must not be referencing the second table properly, the reason your first one works is because it is automatically referenced, what I mean is that Me.dataTable and dataTable will both work in the same scope.
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need. Goodluck!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.
To make a library management s/w we need to break down the whole system- 1)Stock:Where we keep the records of books and add new books. 2)Members:Where we keep records of members and add new members. 3)Lending:Where we keep records of people who took the books.
STOCK -------------- The stock should consist of various attributes of books,like book no.,book name,author,price etc. LENDING -------------- This must contain the attributes of members, like reg no.,of books, like book no, due date,fine due etc. This module must control the restrictions put upon the members by the library, like only 4 books at a time.The violations of due date must also be controlled in this page. MEMBERS ----------------- This must contain the details of members like their reg no, membership fee, membership expiry date,fines due, contact details etc.
All these modules must be connected to a minimum of 3 tables in the back end.Linking these tables to various forms at once produces best results.
One of the first and best things to do is begin to
understand the Visual Basic IDE (Integrated Development Environment).
By understanding the IDE you will be able to develop VB programs
quickly and effectively. Start by reading the Getting to know the VB6 IDE tutorial
classic first program in any language is the Hello World tutorial. As a
beginner you should make sure you write this program to get your feet
wet. Check out the Simple Hello World VB6 tutorial
programmers figure out how to use a consistent naming scheme when they
develop applications. The quickest way to graduate out of the beginner
VB6 level is to check out the Object Types and Naming Scheme VB tutorial
Variables are used in any real development. Make sure you visit the Quick Variable tutorial to see how variables work in Visual Basic 6
you need to make comparisons or have your program choose between
options you will need to understand Visual Basic's if statements.
Luckily there's a beginners tutorial that explains just that: Understanding the if conditional statement
a beginner understands how to use functions and subroutines he or she
is on the road to being a full fledged VB6 guru. A solid grasp on
functions and subroutines allows you to reuse code and functionality
throughout your program and in future programs.Functions and Subroutines in VB6 tutorial
Once you have finished these tutorials you should have a very good
understanding of the fundamentals of the Visual Basic 6 language and
development environment. Feel free to download some more advanced
tutorials and continue learning on your own. If you have any questions
or comments related to this Visual Basic 6 guide please post them
Hi - You cannot scan directly into VB6 unless you use a third-party control (OCX). You would need to get the data into a database table and use ADO, or, hard-code the data directly into your source code. You can actually grab it from Excel too but that involves automation programming - not hard to do - just more to learn. Have fun!
You will need to use a connection string. But - before you can configure the string correctly, I'd need to know how the data is stored (Access, SQL, ODBC, etc). You can find examples online. Just know that you are looking for "Connection String." Here's two examples:
1. For MS Access (Jet files):
' Set up the connection string.
m_strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strDestDBPath & ";" & _
"Jet OLEDB:Engine Type=5" ' NOTE: Use Type=5 for Jet 4.x.
before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.