You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
There is a new article on MSDN that has some useful code samples. This was based off a post by Kerry Westphal on the Access blog a while back. Here is the intro:
Many Web 2.0 applications are designed to make it easy to visualize complex data. I found myself recently challenged with this task while working on a project where I wanted to display on a report to show the time elapsed between the current date and another date. Some example scenarios could include how much time has elapsed since a user profile has been updated, the time that remains until taxes are due, or how long a library book has been checked out. I did not just want to show the hours or even days elapsed, but something more in sync with the way I want the information given to me─specifically, that when dates are closer to the current date and time they are represented precisely, and dates and times that are farther away are shown generally. I wrote the ElapsedTime user-defined function to accomplish this task. The function can be used in a query to obtain a string that represents the time elapsed. The string returned is either specific or general depending on the length of time elapsed. For example, if the date is close to the current date, it appears as "In 12 hours, 27 minutes". If the date was long ago, it appears as, "A year ago". The following screen shot shows the results of the ElapsedTime function when it is used to track items in a calendar.
Nice stuff. I've had vague thoughts of implementing such myself but it was way down on my roundtuit list. Thanks, Tony
I would have added a second parameter instead of using Now(). And I changed the TimeStart to a variant so it won't blow up if the date being passed is null.
I should have said the TimeStart should be a variant because if a null date data type is passed it will be read as 00:00