Similar codes

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
ANmaSQL_UpdateDateStatement

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

2022Jul4

Card image cap
RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

2020Sep7

Card image cap
API in ASP Classic

A simple REST API technique reading record from Access mdb, then generates json ...

2019Feb1

Card image cap
DB_Connect_Install

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

2020Mar24

Card image cap
Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

Nov2

Card image cap
ANmaSQL_InsertStatement

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

2022Jul3

Card image cap
Char(39) in SQL table

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

2019Aug31

Card image cap
Shrinking DB

Steps to shrink database in MS SQL

2019Jan6

Recently by developer

Card image cap
ANString_Location

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

Tue 8AM

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

Card image cap
CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

Random Codes

Card image cap
List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

Jul9

Card image cap
Send To folder

Where can I find the SendTo folder? I always wanted to modify that list and ...

2019May15

Card image cap
Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

2019Apr25

Card image cap
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24