Search results

There was a recent discussion regarding the Onpaint. Use the forum search with OnPaint.

Can the code and use conditional formatting.

You asked for help without providing any information about your environment or controls. Do other forms/reports open okay?

There is a method using a single generic function for almost any multi select listbox here. It would not be the most efficient with larger numbers of records.

If the number of records isn’t large, you could add a new column to the query using DCount().FindDup: DCount("*", "[your table]", " PKField<>" & PKField & " And Year(SomeField) = " & Year(SomeField)) I typed this on my iPad so there are bound to be errors.

Elaborating would be easier if you provided a table structure and possibly significant field descriptions.

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.