Recent content by AlexN

  1. AlexN

    Solved Date to DateTime

    You guys are all wonderful, @Gasman , you showed the way @KitaYama , man you gave THE idea, that saved me from days of work! @MajP , once again you've been so helpful! So, I added one more field to my table, used the update query suggested to display time too, kept the "only date" one to...
  2. AlexN

    Solved Date to DateTime

    @MajP Wonderful job MajP. Once again you show the way. Still... This will do for new records. For the existing ones problem remains. So I've been awfully wrong not only for the question asked, but in initial design as well, and yeah it's "here we go again..." It's alright, I'm learning things...
  3. AlexN

    Solved Date to DateTime

    @Pat Hartman Thank you, I was using the pop up calendar control to input date in that field so yes, it was only date. Problem is at that time, time wasn't needed but now is. So here we go again ... @The_Doc_Man Thank you, I know date, date/time, date/time extended are the same, and I also know...
  4. AlexN

    Solved Date to DateTime

    Thank you so much @The_Doc_Man, Although I knew (or thought so) the difference between "display format" and "storage format", you've been more explanatory than everything I've read so far. Problem still exists though. The more I dive into it the more I understand that it's a design problem. I...
  5. AlexN

    Solved Date to DateTime

    That said (and understood) I think I'm gonna do it all over again because there's no way I can calculate day's fragments the way it is. Thank you so much.
  6. AlexN

    Solved Date to DateTime

    Any way it's getting too philosophical and too complicated. Is there any way (custom function) to turn the Format([Field1],"yyyy/mm/dd hh:nn:ss") value to a date value or the answer is No as @arnelgp initially stated? In that case I'll have to do it all over from the start :(
  7. AlexN

    Solved Date to DateTime

    But 01/01/2017 is also 01/01/2017 00:08:30 ?
  8. AlexN

    Solved Date to DateTime

    ok let's go again from the start. I have a date field Field1 (e.g 01/01/2017). i want to convert it to a datetime field FieldA (e.g 01/01/2017 00:00:00). If I use the Format function I'll get FieldA value = 01/01/2017 00:00:00 but it will be a string not a date. Therefore in my vba code...
  9. AlexN

    Solved Date to DateTime

    Thank you, I'll give it a try but I feel it won't work. Somewhere in my vba code I use DateValue(FieldA) and TimeValue(FieldA) (FieldA being the one in question), and I don't think FieldA being a string will give proper results.
  10. AlexN

    Solved Date to DateTime

    Well, I suppose I should put the resulting string between #s and then use the DateSerial function ? Is that what you're suggesting or I'm wrong again?
  11. AlexN

    Solved Date to DateTime

    thank you both @arnelgp, @ebs17 This field's value would later be used in vba code to position records sorted by date and time (after some calculations). Since the field is a string (no matter how it appears) can't do that. Am I misinterpreting something? p.s. Changing the field's type in the...
  12. AlexN

    Solved Date to DateTime

    Hi everyone again, I have a date field in a query and I want to convert it to a datetime one. e.g I want 01/01/2017 to become 01/01/2017 00:00:00 but, result should also be a date field, not a string (as a Format function outcome) Any ideas?
  13. AlexN

    Report hiding behind forms

    Well, you all know that Queen's song "I'm going slightly mad"? That's what happens to me now. I open all forms in window normal mode (without closing the previous one). I open the report in window normal mode to keep its ribbon in sight. Guess what. When I close the report, all forms are...
  14. AlexN

    Report hiding behind forms

    @gemma-the-husky , @isladogs thank you both. Fact is, I don't really know why I use these forms in dialog mode. I guess it was to avoid closing and re-opening every time. But...to avoid that, I had a hard time positioning dialog forms to cover one another :ROFLMAO:. Anyway I learned something...
  15. AlexN

    Report hiding behind forms

    Still struggling. Can't find why the report calling form doesn't re-instate. I'm almost oriented to directly print the report without previewing it. Meanwhile, should anyone of you kind gentlemen comes with a solution, please do post it here. Thanks
Top Bottom