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
Autofit height iframe
iframe with animated gif to show while loading content, when iframe is fully ...
May25
Excel ribbon
Add ribbon menu to certain macro-based workbook to run macro, will only be ...
2021Aug13
Remove_Between2Quotes
Remove any char (or string) found between two quotes in a string This is an ...
2020Mar9
CreateThumb_IrfanView
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22