Search results

I'm not sure what you mean by "gridlines" on reports. You can add lines and borders. There are also grid "Dots" in design view. What do you mean by not being able to use gridlines. Maybe it's Doc's WAG.

Consider storing a spouse ID. Dates are rarely reliable as unique.

Without judging your table structure, I would add the warehouse table to your append query with no join. Then pull the WHID from the warehouse table and exclude the [Forms]![frmProducts]![boBranchPKID].

I like The_Doc_Man's solution also that avoids confusion between Null and zero length strings. I also like his signature "Certified Grandpa (3 grandsons, 1 granddaughter). Retired and loving it. Must be doing something right 'cause my wife hasn't clobbered me after 30 years of marriage." I...

I would use Instr() to determine if the item already exists. There may be an issue with items that end with the same letters. Dim strSelected As String Dim varItem As Variant With Me.lstLiveWorksOrderList For Each varItem In .ItemsSelected If Instr(strSelected...

If I understand, don’t place the IIf() expression in the criteria. Place it in the field (first row) of the query design. I would use Nz() rather than IIf(). Nz([ManagementDeliverability],"N/A")

Your End_Time value is 9:30 but your criteria is tbl_Schedule.End_Time)>#12/30/1899 9:30:0#)); without the =.

I would try a different mouse.

I should know since it was my contribution to the template. I don’t believe the MS Print to PDF supports the embedded page links.

The Northwind 2 Development Edition creates the table of contents but the pages aren't hyperlinks to the pages (unless it's been updated).

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"