Lookup columns in sharepoint to access

if allow multiple values the ado.field type will be 109(complex text) if not then it's a regular 10 (text)


many bugs

house analogy

build one house that fulfills 100 people's design requests - that's software

jsom set datetime to null

use null ;)

sharepoint worklow history

to see how long the process took add modified to the view

vba doesnt short circuit

here

"in" in access

in ssql server this

select * from

(select 1 as p union select 2 as p union select 3 as p ) as main

where p in (1,1)

will give you  1 row

in access - you will get 2 rows

sharepoint lookup threshold hit in access

set no caching in current database settings