Recent content by DHookom

What have you tried?

I recall someone in this thread bringing politics into a technical forum. I should have reported it. Thankfully this has happened only once. Some technical threads get a bit dicey since most of us are stuck in our ways and OPs won’t head to our advice. I hope for my sake, getting a bit snarky...

You don’t have to remove the error handling code since “Break on all errors” is available in the Options. Remember to set this back to unhandled errors when finished debugging.

I wasn’t aware that Daniel was a forum site owner.

I was aware of Daniel’s opinions a while back and agree.

The Watercooler and elements of this thread remind of an old Cherokee tale: One evening, an elderly Cherokee told his grandson about a battle that goes on inside each of us. He said, “My son, the battle is between two ‘wolves’ inside us all. One is evil. It is anger, envy, jealousy, sorrow...

Thanks, Jon. I wasn’t aware but I’m good with the “Watched Forums”.

I monitor Watched Forums only which does not include any non-Access forum. I checked out Watercooler but it was toxic.

You could also combine the two fields into one expression with a Row Source of: SELECT Symbol_Stock, [Symbol_Stock] & ": " & [Stock_Name] AS Expr1 FROM Investments01_tbl WHERE Symbol_Stock Is Not Null ORDER BY Symbol_Stock; Then set the Column Widths to 0",3"

I would not create and possibly maintain three reports when a single would work with three text boxes as part of the link master. txtChips ="Chips" txtDrinks ="Drinks" txtCleaning ="Cleaning"

In my calendar solution, the criteria for each instance of the subreport is provided by the link master/child. There is a sample in the calendar example at http://access.hookom.net/Samples.htm.

I have created a calendar report based on a query with unique Sunday values only. I added seven text boxes across the width of the detail section and added 1, 2, 3, ..6 to the Sunday in the control source like: =DateAdd("d",1,txtSunday) I named them Date0, Date1, ... I added the same "day"...

I don’t recall having set a format in the query since formatting can easily be set in a control on a form or report.

Some environments don’t allow access to files in the root directory of C.

Don’t use strings in DateSerial DateSerial([Forms]![BankTransactions ]![ComboYear],1,1)