Search results
-
D
How do I display module results in a form text box
Thanks. Someone else actually provided =Year([ReqDate]) Mod 10 & Format([ReqDate]-DateSerial(Year([ReqDate])-1,12,31),"000") which I placed in the control source of the text box and it works fine.- drewship
- Post #3
- Forum: Modules & VBA
-
D
How do I display module results in a form text box
Hello all, I have played around with many variations and this what I have come up with so far. The below code as you can see is a function and I have it in a module called JulianDateConvert since I have not been able to combine it with the Sub (probably cant combine them). Public Function...- drewship
- Thread
- Replies: 2
- Forum: Modules & VBA