Similar codes

code image
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

code image
DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

code image
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

code image
LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

code image
ChrW

Insert special characters inside Cell, using ChrW

2018Sep19

code image
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

code image
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

code image
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

code image
Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

Recently by developer

code image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

code image
Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

code image
PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

code image
TrimLines

Remove all line breaks from text from a text. Not like

Jan31

Random Codes

code image
ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Jul13

code image
HTML redirect

Redirect using HTML Sometimes you need to do what you need to do The 0 in ...

2019May3

code image
Tabs19-BS3

Rounded tabs control in Bootstrap 3

2019Apr19

code image
Paging with Alternating Colors

This script will take the results of a query and sets up number of records per ...

2018Apr18