Similar codes
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
DB_Connect_Install
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
LastInsertedID_SQL
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
NextID_Reset
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Records Affected by Execute command
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
Triangular coded msg in file
Decodes message from file based on number in each line of text. Attached ...
Mar4
CreateUniqueList
Create list of unique items from a column into another column This is similar ...
2022Apr26
fotorama 4.6.4
jQuery photo gallery Dont you just love those small simple libraries that do ...
2019Jun27
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1