Codes Required
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Similar codes
Reset ID Column
How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...
2020Feb9
WaitFor + ShellWait
Tell App to wait for number of seconds and Execute command and wait for it ...
2018Jun16
List of Databases
Script to list databases available in a server using ADODB connection
From
2019Oct6
API in ASP Classic
A simple REST API technique reading record from Access mdb, then generates json ...
2019Feb1
Evaluate
Execute any command in Excel VBE, using Application.Evaluate to execute almost ...
2020Feb16
BinaryFile_Read + BinaryFile_Save
Reads binary file in chunks, if not chuck defined, all file will be red/saved ...
2018Jun18
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
ANmaSQL_UpdateDateStatement
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
LastInsertedID_SQL
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Hiding chart in Excel
How to hide a full chart in Excel. By treating it as shape, not as chart.
2020Dec31
User-Defined Formatting
Apply special Conditional Formatting, color cells based on their values. This ...
2019Jan9
