Question about Microsoft Visual Basic 6.0 for PC

1 Answer

How can i display tables result from query in access using listview in visual basic 6.0

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 285 Answers

Return the query in a recordset and loop through it. In each loop iteration, add an item to the list.

Posted on Apr 23, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

4 Answers

HOW TO SOLVE VFP FILE CURRUPT WHEN POWER FAILURE


At times, you may view that your MS Visual FoxPro 9.0 database is behaving abnormally. Some of the abnormal symptoms could be an error message while opening any database table, invalid characters in place of pre-defined values, and and more. The main reason for abnormal behavior of the database is its corruption due some logical crash. Few common reasons for corruption of MS Visual FoxPro 9.0 database are abnormal termination, faulty network devices, simultaneous modifications, conflicting third-party software, and incompatible service packs.
To overcome such database corruption scenarios, the user can use an up-to-date backup and perform restoration. However, restoration fails in cases where the user either forgets to create a database or the database backup itself gets damaged. In such cases, the database users can use a third-party DBF File Repair application to repair his/her corrupted database.
To illustrate the above case, consider a real-time scenario wherein you execute a query to modify your MS Visual FoxPro 9.0 database. While the query was performing the modification, the system shutdown due to power failure. However, the next time you tried to mount the database, you encountered an error message that did not allow you to access the database records. Moreover, the same error message appears every time you try to access the database.
Cause:
The root cause for the error message is MS Visual FoxPro 9.0 database corruption due to improper system shutdown.
Resolution:
The database corruption error message can be surmounted by following the below steps:
Use a complete database backup and perform restoration. However, in case of database backup unavailability, you will need to search for a commercial DBF File Repair utility.
A third-party DBF Repair application uses effective repair techniques to repair logically damaged MS Visual FoxPro 9.0 database and restore it at a new and safe location. The original database during the repair process remains intact. The tool is easy-to-understand and allows even a non-technical person to perform repair.
DBF Recovery Software is a comprehensive solution to repair databases created in MS Visual FoxPro 9.0, MS Visual FoxPro 8.0, and MS Visual FoxPro 7.0. The tool also repairs databases built in dBase III, dBase IV, and dBase V. Supported by Windows 7, Vista, 2003, XP, and 2000, the DBF Repair tool creates a new repaired file that can be attached to existing database.
Tanvi Sharma is a self employed Internet entrepreneur and product reviewer. This DBF Repair utility is extremely useful when the dBase and Foxpro database gets corrupted due to internal program errors, hardware malfunctioning, accidental deletion of data and more. This DBF Repair software repairs all types of database components including table name, column name, column data type, indexes and primary keys.

May 31, 2010 | Microsoft Visual FoxPro Professional...

1 Answer

How to insert datepicker value in access with use of C#


1.U have to create one acess database .
2 create connection to database using odbc or oledb connection.
3.Write one insert query.
4 execute that query.
5.close the connection

Nov 16, 2009 | Microsoft Visual Basic .NET Standard 2003...

1 Answer

SYntax error in from clause


Hi

Try to run the record set query (the one rs.open uses ) directly in the db you are using .

If you are not sure what is the query concatenate it into variable and get the full query just before you open the record set.

once you do that you will get better idea of what is wrong with the query .

Jul 20, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

I want to programaticaly modify an SQL statement in VB6


If I remember correctly you need to call ExecuteQuery or something similar otherwise it does not update the database.


Regards
GeWiz.

Jun 16, 2009 | Microsoft Visual Basic Enterprise Edition...

1 Answer

I have a visual basic program in which i have to display the record from access table by using connection of adodc.and then select record from datagrid will display in another form. plz reply as soon as...


hi,  you may visit this site www.kidwaresoftware.com/ and download all free visual basic source codes with tutorials..  One of the source code will solve your problem.    However their paid Visual basic source codes will most powerful.    As I am total deaf and no source to communicate others... I want to share the  payment source codes with tutorials from  www.kidwaresoftware.com/.  Are you ready... If you download the  source codes with tutorials (only Fee for it) I will share with you.    esakkisivaganesh@yahoo.co.in

Apr 08, 2009 | Microsoft Visual Basic Enterprise Edition...

1 Answer

Microsoft Access query in VB


first you need to create a record set to do this, after creating a record set RS1. please follow the code below:
Update the code as per your requirement.
Rs1.Open "Select * from table_name where UserName = '" & UName & "'", Cn1, adOpenDynamic, adLockOptimistic

Mar 14, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

How do i use date in visual basic 6


Hi,

I am not getting your problem clearly.
If you are referring to save the input dates as date in database with the help of sql query then you need to provide hash(#) mark at the beginning and end of date values. It will resolve your problem.

Hope this helps and let me know if you are not getting the solution clearly.

Thanks.

Mar 06, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

How do copy a table from an access database in one folder to another access database in another folder through visual basic code


Simple method Open both tables (or create second) and copy each record from source to target through 'do while not eof' or 'for each' syntax.

Second solution create link in target DB for first table, and use SELECT INTO statment in SQL.

Mar 02, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

How to Export Listview Data in Crystel Report through VB 6.0


Dear friend you can get your answer easily in http://www.codeproject.com/
This website is all about .NET programming and VB and by a simple search you'll find your answer
Good luck

Feb 27, 2009 | Microsoft Visual Basic Professional...

1 Answer

How to create a multiple access query and put altogether into 1 SQL Scrip(.sql file)


Suggest using Union Query. Thus, you can add more queries from many table and the output will be in one (1) query. Bear in mind that all fields must have same Field Name.

For example:
tblOne contains dtDate1 fieldname. Your query will select [tblOne].[dtDate1] As myDate.
tblTwo contains dtDate2 fieldname. Your query will have the following SQL:

Select [tblOne].[dtDate1] As myDate
UNION Select [tblTwo].[dtDate2] as myDate

Thus the output will result dates from tblOne and tblTwo in a column called myDate.

Regards,
Maha

Feb 05, 2009 | Microsoft Compilers & Programming Tools

Not finding what you are looking for?
Microsoft Visual Basic 6.0 for PC Logo

Related Topics:

92 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers

Alex Krenvalk

Level 2 Expert

401 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...