Codes Required

Similar codes

Card image cap
DB_Connect_Install

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

2020Mar24

Card image cap
DB_Connect

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

2020Mar20

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
Records Affected by Execute command

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

2018Sep1

Card image cap
MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29

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 connection driver

What is the Driver part in ConnectionString

Jun2

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
Connect to UDL

Use a UDL to make your connection to a database

2018May27

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
PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

Dec2

Card image cap
OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

Card image cap
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

Card image cap
Screenshot_IrfanView

Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...

2019Jun27