This is an example of using Excel for a front end for SQL server using Excel to validate your data. It has validation in it to notify the user of the database constraints. This whole project is solely ...
The VBA SQL Client Data Integration System is designed to streamline the process of retrieving and managing client information within an organization. This project features a robust class module that ...
In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...
ActiveData assists Visual Basic 5/6 developers in their data application development. It helps you see and edit a DAO or ADO recordset's data, connection properties, recordset properties, and field ...
If your business does any programming in Windows, then a basic knowledge of VB6 programming concepts is essential. Windows provides a set of objects and functions to streamline development on PCs, ...
I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...