Hi all..
I have a linked table to an Outlook folder (Inbox) and I have a list box on a form within my database that shows the contents of the inbox so that I can read emails to this mailbox from within my app. Unfortunately, as I have linked directly to an Outlook table (Inbox) I do not have a PK in the table so the best identifer I can use to open the record from the list box is the received date (Time stamp). I am using the following code to try and open it
docmd.openform "Re-Mail", , , "[Received]='" & me.lstMailbox & "'"
With the bound column of the list box being the received date/time.
I have also tried:
docmd.openform "Re-Mail", , , "[Received]=#" & me.lstMailbox & "#"
buit for some reason this will happily show records with todays date but nothing older...(Very strange).
Could anyone please help me out of this one?
Many thanks
Gareth
I have a linked table to an Outlook folder (Inbox) and I have a list box on a form within my database that shows the contents of the inbox so that I can read emails to this mailbox from within my app. Unfortunately, as I have linked directly to an Outlook table (Inbox) I do not have a PK in the table so the best identifer I can use to open the record from the list box is the received date (Time stamp). I am using the following code to try and open it
docmd.openform "Re-Mail", , , "[Received]='" & me.lstMailbox & "'"
With the bound column of the list box being the received date/time.
I have also tried:
docmd.openform "Re-Mail", , , "[Received]=#" & me.lstMailbox & "#"
buit for some reason this will happily show records with todays date but nothing older...(Very strange).
Could anyone please help me out of this one?
Many thanks
Gareth
