Search results 59

Sorted from new to old.

NextID_Reset

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

2020Mar31

Excel sheet textbox

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

2020Feb22

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

2019Dec22

Tabulator

A nice, advanced powerful table control in js From

2019Sep18

Freeze table head

Freezing head (thead) of a table when scrolling. Needed this feature for a ...

2019Sep5

LastInsertedID_SQL

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

2019Jul18

Tabs18-BS4

Simple tabs in bootstrap 4 (with tables)

2019Apr18

Bootstrap 4 cheat sheet

Bootstrap 4 cheat sheet, quick direct link as image

2019Apr9

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

MSSQL backup

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

2019Jan6

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

1 2 3 4