by Khalifa Ahmed Tarhoni (1 Submission)
Category: Complete Applications
Compatability: Visual Basic 3.0
Difficulty: Beginner
Date Added: Wed 3rd February 2021
Rating:
(3 Votes)

This application demostrates the creation of Master/Detail form in VB, VB programmers always felt handicapped by the fact that there was no concept of sub forms in VB but here we show how to create such forms in VB using RDO. Users are encouraged to customize the code to use ADO inplace of RDO or wait for us to write another article in which we will show you how to accomplish the same task using ADO.
Inputs
User will have to change the UserID and Password of the SQL Server in the code, see the attached document for details.
Assumes
The application uses a SQL Server at the backend, the user will have to run the SQL files (included with the application) after creating a database in the SQL Server. RDO and DAO 3.51 should be present on the user's machine, these are installed when the user installs VB.
Code Returns
Returns a resultset that is displayed in the grid control.