I am running a DMS system and I want to add a update two of its features.
?
## Deliverables
Q1)
I have a DMS system, I want to differentiate between read and unread inbox documents same as Outlook messages. Knowing that the inbox showed in a grid view that? fetches the data from an sqlDatasource? as follows:
?
sSQLBaseSelect = "select * from vDmsInboxDetails" WHERE RecipientID = " & Session("intuserID")
?
Knowing that when a document is being accessed the table tblDocCirc is updated:
?
sSQL = "update tblDocCirc set Ack = 1 where docID = " & [login to view URL]("intDocID") & " AND (recipientID = " & Session("intUserID")
?
?
?
Q2)
DMS sends email notifications which include the DocID, I want DMS to be opened by clicking the DocID in the following conditions:
1.? ? ? ? ? DMS is opened in IE with none of the bars being showed except the title bar and IE be in a full screen size.
2.? ? ? ? ? DMS automatically opens the Doc being accessed.
?
?
?
Please feel free to revert with any further queries you may need.
?
Thanks in Advance.
Ali
00971503444988