I am pulling the CreationTime of a message in Outlook and putting it into an Access table. I want to see if it already exists in the table.
(The format for CreationTime looks like this 3/29/2012 10:35:03 AM. It is saved in a date field with the format set to general date.) The data exists in the Access table so the recordcount should be returning a one instead of a zero. How should the varDateTime be handled in the sql string?
dim varDateTime as date
varDateTime = oMsg.CreationTime
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…