Access Examples

Measure the time it spends an operator to insert a record

This was certainly a player Elton Rueb and he even managed to solve before I help. What the reader was intended to measure the time it takes a user to insert a record and it has three fields: one for the start time when it opens the form, for the first time to end that is inserted when you click the record button and a field to calculate the difference. This is a simple example but may be lacking to those who want to calculate difference between two times. So the Elton Rueb (Rio de Janeiro - RJ - Brazil) provided the example that could help someone else.

Download: Test Time

Posted in Dates , Samples , Examples transferred , Expressions , Form , Time | 2 Comments »

Answer the question: Format date

The reader Jacinto put a question here on how to change the format of a date of 12/06/2008 for 2 0 0 8 0 6 1 2, the response as explained in the comments is as simple as a text box with the following expression:

= Format ([date field name], "mm dd yyyy")

and properties of the field put the following words in the input mask: 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0

Pretty simple and easy. Follow the example for download: Format date

Posted in Dates , Examples , Expressions , Forms | No Comments »