Similar codes

Card image cap
Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

2018Sep1

Card image cap
DB Functions (By AI)

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

2023Apr23

Card image cap
DB_Connect_Install

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

2020Mar24

Card image cap
ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Card image cap
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

Card image cap
DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Card image cap
NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

Card image cap
ANmaSQL_UpdateDateStatement

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

2022Jul4

Card image cap
DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

2018May31

Recently by developer

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

Random Codes

Card image cap
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

Card image cap
Is64Bit

Determine if system is 64 bit or not. Related to

2020Feb7

Card image cap
ANmaBrowser v20.19.01

Single file, Classic ASP, Bootstrap 4.1 and FontAwesome 5.0 file manager. ...

2018Sep19

Card image cap
oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6