brunces
Registered User.
- Local time
- Today, 17:41
- Joined
- Sep 12, 2004
- Messages
- 45
Friends,
Another doubt of mine. (Sorry, but I'm a real begginer.)
I want to calculate the age of a client, but you know it's not simply to do this:
=Date()-[DateOfBirth] & "years old"
For, depending on his date of birth and today's date, the calculation should be:
=Date()-[DateOfBirth]-1 & "years old"
So, I don't know how to do this, using a simple expression, inside a text box. If someone knows and can show me, I appreciate it very much. However, my doubt is another one...
I want to know how to link a VB code to a textbox. I mean, I want to calculate that age, using a VB code I found in Google, for example, but I don't know how to put its result inside a textbox (in a form or report). I know what to do, but I don't know HOW to do (where to click on, where to put the code, how to identify the code and link it to the textbox). It must be very simple, but I really don't know.
If someone could help me, I'd appreciate it.
Thank you so much for the attention.
Hugz.
Bruno
Another doubt of mine. (Sorry, but I'm a real begginer.)
I want to calculate the age of a client, but you know it's not simply to do this:
=Date()-[DateOfBirth] & "years old"
For, depending on his date of birth and today's date, the calculation should be:
=Date()-[DateOfBirth]-1 & "years old"
So, I don't know how to do this, using a simple expression, inside a text box. If someone knows and can show me, I appreciate it very much. However, my doubt is another one...
I want to know how to link a VB code to a textbox. I mean, I want to calculate that age, using a VB code I found in Google, for example, but I don't know how to put its result inside a textbox (in a form or report). I know what to do, but I don't know HOW to do (where to click on, where to put the code, how to identify the code and link it to the textbox). It must be very simple, but I really don't know.
If someone could help me, I'd appreciate it.
Thank you so much for the attention.
Hugz.
Bruno