LouL's latest activity
-
LYou were not creating a valid file path? You were just throwing in another parameter that was invalid for that command.
-
LLouL replied to the thread Solved Saving a report to a specified folder.Thank you, that "&" did the trick. Much appreciated. 😊
-
LTry: DoCmd.OutputTo acOutputReport, strReport, acFormatPDF, strFolder & strFileName, False Please post code between CODE tags to retain...
-
LMS Access 365 Hello everyone, thank you for your past help. I've now got a little problem trying to save a report in a specified folder...
-
LLouL reacted to GPGeorge's post in the thread Solved Problem calculating correct age from birth to death with
Like.
Except IsNull() in SQL Server TSQL is a different function from IsNull() in Access SQL, so maybe it's not so clearcut. TSQL... -
LLouL reacted to The_Doc_Man's post in the thread Solved Problem calculating correct age from birth to death with Like.
The issue, I believe, is that DateDiff will isolate the years before doing the subtraction. (2021-1923 = 98). Take a look at this...
-
LLouL reacted to theDBguy's post in the thread Solved Problem calculating correct age from birth to death with Like.
Hi. I moved your thread out of the introduction forum. A quick fix is to just subtract one day to the result. Would that work?
-
LLouL reacted to The_Doc_Man's post in the thread Solved Problem calculating correct age from birth to death with Like.
Check the first two articles in the "Similar Threads" section below. They might be helpful.
-
LLouL reacted to GaP42's post in the thread Solved Problem calculating correct age from birth to death with Like.
This may be more than you need but: Public Function CalcAge(dteDOB As Date, Optional dteEnd As Date) As String 'years, months &...
-
LLouL reacted to arnelgp's post in the thread Solved Problem calculating correct age from birth to death with Like.
you may also try this: Public Function Diff2Dates(Interval As String, Date1 As Variant, Date2 As Variant, _ Optional ShowZero As Boolean...
-
LLouL replied to the thread Solved Problem calculating correct age from birth to death.Thank you for your advice, I'll keep that in mind. :) Regards, Lou
-
LLouL reacted to raziel3's post in the thread Solved Problem calculating correct age from birth to death with Like.
I think everyone pretty much covered your problem but just one more small thing. Try to limit the use of the Nz() function. If in the...
-
LLouL replied to the thread Solved Problem calculating correct age from birth to death.Thank you, I was able to do what I wanted to do with that code! :) Regards, Lou
-
LLouL replied to the thread Solved Problem calculating correct age from birth to death.Thank you, sorry, I had a look at that but my old grey matter is not what it used to be, I still can't fix my problem from the info...
-
LLouL replied to the thread Solved Problem calculating correct age from birth to death.Hi, no, the calculation is out by 1 YEAR! Her age should have been 97 years and 7 months NOT 98 years and 7 months Regards, Lou