Search results

  1. D

    How to format a date?

    No data entry. But Editable.
  2. D

    How to format a date?

    Still the same. Single digit hour. Thanks for the advice though.
  3. D

    The Virus that came from China.

    If he wants to win a larger audience, I think he should be softer with media and the way he talks to others. Changing the facts and his belief just to win the election, is not what I support. If he really changed his mind and believes there may be a chance that China didn't spread the virus, I...
  4. D

    The Virus that came from China.

    This morning I was listening to the morning news in TV while I was preparing to go and start another busy day, . Listening to a part of President Trump's yesterday speech, I was thinking he will never change. But then I was shocked when I heard him saying : The virus that came from China. I...
  5. D

    How to format a date?

    Thanks for your advice. But too many to follow up. Let's walk one step at a time. 1- Sql server shows the data type as datetime. (as I explained in my original post) 2- The database I attached has a local table. The datatype is data/time. Still it shows the same problem. It proves no sql side...
  6. D

    How to format a date?

    Here it is. Thanks. Edit: I had to cut off several hundred thousands of records to be able to upload the file. How much is the max allowed size for uploads here?
  7. D

    How to format a date?

    I can not go changing personal settings of all PCs in a company with tens or hundreds of PCs. I think format is sitting there to prevent the need of changing any settings outside of Access.
  8. D

    How to format a date?

    I don't have any problem with uploading a simplified version of my db but I don't understand how anything else may interfere formatting a date. How is your short time and long time format in control panel? You may have it as hh: Mine is h:
  9. D

    How to format a date?

    Dropping AM/PM doesn't give me the result I need either.
  10. D

    How to format a date?

    You mean I can not show something like this? 2020/07/03 08:51:33 PM
  11. D

    How to format a date?

    How can I format a date to show the hours as two digits? This is the format I use, but still the hours shows in one digits: The form is bound to a sql server database with a timestamp data type. Thanks.
  12. D

    Happy Birthday Mick!

    Happy birthday 🎂
  13. D

    Poll spam sorted

    I've not seen them for a while. Good job.(y)(y)(y)
  14. D

    Largest Programs Ever Written

    You know I didn't meant it this way. :(
  15. D

    Largest Programs Ever Written

    How? The code reads every module in one go, not line by line. ModuleLines = Modules(strModule).CountOfLines Should I export each module to a text file and read it line by line to recognize the blank lines?
  16. D

    Largest Programs Ever Written

    Most of my comments are in-line comments. It means at least there's a line of code for each comment. But for sure, I have a lot of blank lines. Is there any way to skip counting blank lines?
  17. D

    Largest Programs Ever Written

    If you want to check yours, Allen Browne has an utility you can use: http://allenbrowne.com/vba-CountLines.html
  18. D

    Solved How to use Power operator in VBA?

    As you see, I'm in the next line, but the spaces are not there.
  19. D

    Solved How to use Power operator in VBA?

    No. Thanks. No need to test. In 64 bit the spaces are not added automatically. No big deal. I will add them manually. https://stackoverflow.com/questions/29035672/why-do-i-need-a-space-before-the-operator-in-vba-for-excel-2013-or-it-will-p
  20. D

    Solved How to use Power operator in VBA?

    I think I got the point. It seems in vba 2^2 is different with 2 ^ 2 So I must add the space manually. 2+2 will be changed to 2 + 2 as soon as I move to another line. But 2^2 throws the error until the space is added manually. Thanks for your help.
Back
Top Bottom