Similar codes

Card image cap
ANmaSQL_UpdateDateStatement

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

2022Jul4

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
Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

Card image cap
Replace Single Quotes

This script will replace single quotes so the data is SQL-safe

2018Apr16

Card image cap
Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...

2018Sep26

Card image cap
Register OCX in 64 and 32 bit

Copy and register ocx using cmd (DOS batch) in Windows 32bit and 64bit.

2020Feb9

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
MSSQL backup

The practical way I found to backup database (or tables) to be moved into new ...

2019Jan6

Card image cap
Char(39) in SQL table

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

2019Aug31

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

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

Tue 7AM

Card image cap
MatchIf2Up

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

Mon 9AM

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

Random Codes

Card image cap
ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Feb4

Card image cap
DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Card image cap
Checks if URL is valid

Checks if URL is actually working. Uses XMLHTTP object to see if that URL ...

2018Dec9

Card image cap
Hex2Int

Converts hex to Integer

2018Sep27