Search results

Totally Incredible! Works perfectly! THANK YOU!!!!!!! Just curious - how in the codes does it say that January = janvier? What kind of course could I take to learn how to write these wonderful functions? I am totally amazed by the difficulty and the simplicity!

THANK YOU - I know it will help many of us!

No - the settings must remain English-Canada. I only need the date for the many French Reports. The entire database (and the PC) is English based.

Hi all! I have create a series of text boxes through much hardship (newbie!) to change a given date, in a given report, into French. I have save it in a report so I can easily retrieve the text boxes and copy and edit them for other reports. However, this is really cumbersome and may be even...

This worked great - just missing a parenthesis (for the benefit of others): on sorting, cast the return value from our function into an integer. on your sql: Age:IIf(IsNull(fnAge([DOB])),Null,CInt(fnAge([DOB]))) Again, THANK YOU

The other issue, you can create new post. by the way, how do you want your date to display. french (i see). but how do you format it. is it like yyyy-mm-dd? __________________ Ok will create a new post. I can't format it as a date. It becomes an expression that is put together... and since...

WOW! Gees you make it seem so easy!

Arnel, Can we ad the following in the function? Would be sooooo much better than the conditional formatting I set everywhere. When the age turns to 16, the following field should be set to "yes" (ticked). There are and will be no exceptions to this. Table: tblTenants Field: Maillist -...

Re: Calculate age - needed quickly Also, may I impose on you for something else? I wrote some code (took a while, a long while to figure out!!!) in control text boxes for a given date to change into French. It works. However, each time I need a French date, I have to go back to this...

Re: Calculate age - needed quickly Great! Error word gone. However the sort goes 1 10 to 20 than 2 ... I set the DOB as Date/Time, Medium Date (guess that can be the problem, right?). THANK YOU - this is so great! I think many people will want this. I certainly will share it.

Re: Calculate age - needed quickly Got it! Went into Create Module - then View - then Project Explorer. Was able to delete Module 2. So error message is gone :). AND, 13 is showing!! :))))) However, can something be done for: 1) When trying to sort on that column, I get "Data type mismatch...

Re: Calculate age - needed quickly If I could see it, I would. As I said, it is not showing in the navigation pane. I don't know how to get to it. I looked on the Web for a solution... can't find one. The options settings are set to show ALL.

Re: Calculate age - needed quickly Dear Arnelgp, 1) I pressed ALT F11. Copied the coding you generously provided. I closed the "editor". I can't see the module group in the navigation pane. I checked in Options, everything was/is selected - nothing to be hidden. I also used to be able to...

Re: Calculate age - needed quickly Sorry, forgot to say it told me about the missing bracket which I did put in. Just copied the coding you provided. The first one (FirstPart) still returns age "14". The second one, returns 0 or -1 (not sure I understand that one). So why is it not returning 13?

Re: Calculate age - needed quickly Thank you both. The query now returns "14" but he is 13 years 8 months 13 days... so should return 13. Should this be written like "every year, on that date (DOB), add 1 to this number..." (sorry can program this, lol) or am I complicating things?

Re: Calculate age - needed quickly Mmm... Must be doing something wrong. In the form, it returns: #Name?. For the date of birth, the control name is txtDOB and the field name is DOB. For the age calculation, the control is called txtTenantAge (not that it matters)...

Re: Calculate age - needed quickly I also need this expression for a query. As is, it cannot work in a query but should be great in a form's control. In the query, the field name is DOB. So tried : Age: DateDiff("yyyy",[DOB],Date())+Format([DOB],"mmdd")<Format([Date],"mmdd") I get no error...

Hi everyone! I am using the expression below, in a form control, to get the age from a date of birth. In this database, it is very important that it be accurate as when the member turns 16, some paperwork has to be issued among other actions. Expression: =DateDiff("yyyy",[txtDOB],Date())...

LOLOLOL! Too funny! ohno! Thank you!

Update done! Thank you --------------------------------------------------------------------------- Other question: You are right! What I meant is: It is ONE lease for Unit 1 - with many people who live in Unit 1 and have to sign that lease (document/report). It is ONE lease for Unit 7 -...