Recent content by Pat Hartman

The "general welfare" does not say they should pick winners and losers by which silly studies they choose to fund. PLUS, it is not even Congress that picks the silly studies. It is unelected bureaucrats.

Either create a function to extract only the file name or add a second column so you can save the values in two fields from the beginning which is the best solution.

The large monitors are still pretty expensive relative to other monitors. I don't see many clients rushing out to buy new hardware.

NOBODY cared what Hunter was doing except as it related to being the bag man for the Biden Crime Family and the fact that he was a protected class all by his lonesome because he was the President's son. His coverage went so far as to have his SS detail covering up his crimes. I would never...

I believe the clause you are misinterpreting is: To promote the Progress of Science and useful Arts, by securing for limited Times to Authors and Inventors the exclusive Right to their respective Writings and Discoveries. Except you need to read the entire sentence. It doesn't say we will...

I am talking about the way Excel does it. Not scaling it for viewing after I PERSONALLY formatted it to 8.5 x 11. Excel scales the font size to fit within the printer page. That has been the PITA.

Where in the Constitution is it written that the government (i.e. the American suckers) will fund stupid scientific studies?

A much more useful feature would be the ability to scale a report to fit the way you can do with a workbook you want to print.

You're right. I forgot about the functionality they omitted it was so long ago. There are a number of viable replacements out there using native VBA. I still hate many of the changes made from A2003 to A2007.

Large monitors cater to large spreadsheets and people with 20-20 vision. I don't see them as a dire need to Access work. One of my clients upgraded all workstations a year or so ago and I hated working with it. I reverted back to my two largeish monitors.

Welcome to our world;)

Trump has always promised reciprocal tariffs. But that is easier said than done since we usually have a different list of products we import from a country than we export to that country. So adding a 99% tariff to cars won't work if we don't import cars from them. So, his people came up with...

They replaced it with an integrated access control. The old control was ActiveX. The replacement is a native Access control

and fnFinancialYearStart(Date())-1)); is probably what you meant.

The ONLY way you can update an autonumber field is by using an append query. So, instead of importing using transferspradsheet, link the table and then run an append query.