Reputation
Next privilege 50 Rep.
Comment everywhere
Badges
4
Newest
 Tumbleweed
Impact
~532 people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Feb
1
comment Blank Date Field (Calculated) in SP shows as #Error in Linked MSAccess Table
I haven't found a resolution to this yet. All that I understand is, a NULL value for date is impossible to be set. If I use the expression "" in the IF THEN ELSE formula, it is a text-null and MS Access does not like it. If I let the field blank by NOT updating any value, SharePoint sets the date as 12/30/1899. Is there no way to set a NULL for a calculated-date field?
Jan
28
asked Blank Date Field (Calculated) in SP shows as #Error in Linked MSAccess Table
Sep
12
awarded  Tumbleweed
Jan
22
awarded  Supporter
Jan
22
comment SharePoint List View Threshold Error on Delete and Re-load of Data
Hi Craig, Thanks for suggestion. But I am afraid that is going to have problems for me. I have distributed excel sheets to country users that connects to these tables using connection string and macros. Further, I use KwizCom for view level permissions. Every time I create a new list, I would have to redo that as well. Hence, that would be very difficult, especially doing it once a fortnight!
Jan
20
comment SharePoint List View Threshold Error on Delete and Re-load of Data
Hmm... I have either asked an uninteresting question or a too difficult one...
Jan
18
awarded  Editor
Jan
18
revised SharePoint List View Threshold Error on Delete and Re-load of Data
Additional inputs on tests that I did - inconsistent behavior of list views.
Jan
17
awarded  Student
Jan
17
asked SharePoint List View Threshold Error on Delete and Re-load of Data