Search results

  1. Cronk

    Imperial System

    If America is the most technological country and the third biggest (by population), why is it that America is one of three countries who adopt the imperial system? The other 2 are Myanmar and Liberia.
  2. Cronk

    Mike Wolfe - an Old Dog!

    Yes. Which is the same as we admitting we or should I say, I don't know everything.
  3. Cronk

    Mike Wolfe - an Old Dog!

    I didn't either. But then again, I mostly hide navigation buttons in my forms.
  4. Cronk

    How to print all the records after each working day

    And I wrote Docmd.OpenReport And you put Docmd.outputTo You'll see ArnelGP also uses docmd.OpenReport
  5. Cronk

    How to print all the records after each working day

    Works for me. Did you put 3 commas in? Transcribe it accurately?
  6. Cronk

    How to print all the records after each working day

    DATE(NOW()) is not valid syntax CDATE maybe but that would keep the hours/minutes with NOW()
  7. Cronk

    How to print all the records after each working day

    docmd.openreport "Report1",,,"Transdate=Date()"
  8. Cronk

    Government Spending

    US National debt is now $33.7 trillion. About half of Treasury debt matures in the next 3 years. If that debt is rolled over with current interest rates, the interest on debt will rise from around $700 billion to about $2 trillion. They keep kicking the can down the road but that road is not...
  9. Cronk

    What's your best/worst joke?

    How does computer AI learn? Bit by bit.
  10. Cronk

    Save on a different DataBase

    You can insert records into a table in another database, if you want to go against the advice proffered by others, by using currentdb.execute "insert into tblExternal (Field1, Field2) in 'C:\path\yourOtherDatabase.accdb' select Field1, Field2 from tblSourceTable"
  11. Cronk

    Old Code

    I wrote the code in 1991 in dBase 4, a DOS database program which I started using in 1985. The client had me replace it in 1995 with Access 2, the first time I got to use Access.
  12. Cronk

    Old Code

    Close but no cigar. It was dBase 4, a Borland product.
  13. Cronk

    Old Code

    I could have been clearer. It was code I'd written over 30 years ago. The file extension was .PRG
  14. Cronk

    Old Code

    Just browsing through some archives. Anyone know what program was used for the following snippet of code ? * POUND_IN * Program for in/out management of dogs at pound * * Modifications * (1) Nov 1992 to include POPUP menu for impound code and transaction processing * (2) Jul 1993 to...
  15. Cronk

    The Roman reason

    He also sang Money. That’s What I Want. The best things in life are free. But you can keep 'em for the birds and bees
  16. Cronk

    Solar won't work without the Sun...

    No. Power is generated by light so even with cloud cover there will be some power generated by solar panels. Earlier it was raining here and my solar panels were generating 210 watts. The theoretical maximum power if full sunlight with the sun directly overhead is 6.4kW
  17. Cronk

    Adding a new record and getting ID

    With rs .AddNew ![createdate] = Date YourID=rst!ID .Update .Bookmark = .LastModified End With If ID is an autonumber, you can save it before the update
  18. Cronk

    Adding a new record and getting ID

    (a) You could add an autonumber ID to the table so that it is automatically created. (b) If you want some other unique ID, you could add one to the last ID, or generate a random number but checking first it does not exist already. (a) is easiest and would be what most developers would use.
  19. Cronk

    The Australian voice referendum

    The referendum was to make a change to the Australian Constitution. “A Proposed Law: to alter the Constitution to recognise the First Peoples of Australia by establishing an Aboriginal and Torres Strait Islander Voice. Do you approve this proposed alteration?” The Voice will be an independent...
  20. Cronk

    If with . Attachement

    What DBguy is saying is that if Msample is Null then Msample & ".pdf" will be ".pdf" which is an invalid file name
Back
Top Bottom