Search results

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

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

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...

How does computer AI learn? Bit by bit.

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"

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.

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

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

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...

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

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

(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.

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

You could add another field -Reason (for leaving) ie Expelled, Transferred, Graduated

In the Update event of the combo, look up the values of Address and Mobile and insert values in the unbound text boxes. Better if you based the form's source on a query which combined the Sales and Customer details. For getting the address and mobile for a new customer, I'd have a separate pop...

"The Timeless and Universal Truths and Principles About Order and Disorder That Are Most Relevant Now. I believe that it is true for all people in all collective activities (sport, organizations, governments, etc.) that if… a) there is no acceptable way to agree on what is probably true (e.g...

Could you understand the English spoken in NZ?

When the button is clicked, call the fnElapsed routine and insert the results into an unbound text box.

Proven skills can obviate the need for a degree. I wonder how many posters on these forums have a degree in computing. I for one don't.

Have you checked for any occurrence of Dim SUrname