Monday, January 14th, 2008 |
Through a small code we can welcome the user depending on the time you open the form. In this example we can see three different messages:
1-Morning Until 12:00;
2-Up at 19:00 Good afternoon;
3-Between 19:00 and 00:00 Good evening.
Just need a small code, which is as follows:
Public Function Greeting ()
Dim strMsg As String
If Time <# 12:00:00 PM # Then
strMsg = "Hello! Have a nice day! "
ElseIf Time <= # 7:00:00 PM # Then
strMsg = "Hello! Good afternoon! "
Else
strMsg = "Hello! Have a good night! "
End If
Compliance = strMsg
End Function
Then to call the code, we use a text box and as the origin of the compliance monitoring write = ().
Download: Compliance
Posted in Examples , Forms , Hours , modules | 2 Comments »
Saturday, January 12th, 2008 |
Through a small module can see how much we have records on a form and in which we meet them. That is, for those who do not want to have the navigation buttons at the bottom of the form, which allows you to browse the records, you can alternatively use this method to inform that the registration number that is and how many there are in a form.
Download: Records
Posted in Examples , Forms , Modules , Records | No Comments »
Tuesday, January 2nd, 2007 |
This is a very useful application that uses a module to write a number in full. For example, we introduce the value 100.50 in a field and another field he writes in words the value in Euros (Hundred Euros and fifty cents).
Download: extensive
Posted in Examples , Expressions , Modules | 1 Comment »
