by Ken Ashton (4 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(3 Votes)
This is a One Form One Ini solution to the frustration of writing repetitive VB/ADO/ASP Database code. I hope you will find this extremely useful for certain tasks, and a sound concept for improved coding and tailoring to individual requirements. As I can't live without it now - so I thought I would share it.
(1) Opens any Access 97/2000 Database and Lists Tables, Fields, Types.
(2) Type one line of code, program will replicate the line using the
correct Fieldnames/Numbers/Types and Sizes - ASP programmers dream.
(3) Create a choice of connection strings based on the Open database.
(4) Create Sql INSERT, UPDATE & SELECT statments with actual field names.
(5) Print your output code, or Double Click Ouputbox to send to clipboard.
(6) Split Screen to adjust to preferred ListBox v Outputbox areas.
(7) Most settings saved, return to where you were when restarting.
(8) MRU File List, Auto-Open last database, Synchronized Clipboard etc.
(9) Tool Tips explain most items, can be turned off when desired.
(10) Reminder bar shows current User Keys, DblClick to turn off.
(11) Disconnected Recordsets, freeing off DB during development.
(12) All Translation 'Keys' are user definable.
At the simplest level, Open a database and type in a template like -
MyArray(##) = rs("$$")
In the Ouputbox, ## and $$ get translated as FieldNumber and FieldName
MyArr(0) = rs("ID")
MyArr(1) = rs("qCode")
MyArr(2) = rs("Title")
MyArr(3) = rs("Lastname")
MyArr(4) = rs("firstname")
...........
........... and so on to n fields
VBcoders
