Recent content by reggied

The flicker was not the big problem (I haven't tested this out on other machines but it could be my machine is a little slower). I couldn't figure out why I was getting the 2424 error from the subform when switching records on the parent form. But per MajP it may be a timing issue related to...

Gasp! You are an Access VBA Savant! Works like a charm. I only added an If Then statement to differentiate backcolor and forecolor for non-colors (white or raw). With con If color = 0 Then .ForeColor = RGB(0, 0, 0) .BackColor = RGB(255, 255, 255) Else...

Thanks for this advice! Each order typically has only 3-4 different colors at at time. You are suggesting delete the code in the on load event and move it to the current event of the subform? Remove first, then add in the current event?

This works great! I just had to make a small adjustment to the HextoRGB field to give a 0 for few of the color codes. Just one clarification: this will only work for up to 50 colors?

Nice! But with conditional formatting I would be limited to 50 colors, right? I am told that the color list would grow to 90. We started with 9 and we are now up to 15 a couple months later. . . I am also not crazy about how the On paint event constantly fires. Maybe I can stay with...

Trying to figure out how t delete this post because the tables are not viewing correctly. Also, I solved the issue by adding a secondary sort after the PODate sort.

I have a query that only has 4 fields: SalesOrder, SalesOrderID, FabSO, and PODate. When it is sorted by PODate it sorts as shown below: qryUniqueSOFromtblTempFabReq SalesOrderSalesOrderIDFabSOPODate SDR0493443FAB0225/13/2025 SDR0503444FAB0225/13/2025 SDR0513447FAB0225/15/2025...

Attached is the db. frmSalesOrderEntryCabs is the parent form and is a list of Sales Orders. sfrmSOShipInfo is a subform that was only added to allow the user a familiar way of editing ship info. sfrmLineItemsDE is a subform and contains the code causing the error. It lists line items for...

good question. I currently use conditional formatting to color the cboFinishID control. Originally, I thought there would only be a dozen or so colors. I was just advised that the list would grow to 90 colors! I believe with conditional formatting you can only have about 50 sets or rules...

Interesting thought! Both the parent form and subform are set to allow additions. One of the error instances happens when I move to the blank/new record on the parent form. That's why I put in the Len(Me.cboFinishID & "") < 1 test to see if it is a null value. But the same error occurs on...

I get the 2424 error: What's odd is that the error only appears when viewing specific parent records. The code works when I open the subform directly and for most of the parent records. I will try making a db that has the relevant forms and tables copied so I can easily upload.

Got it. I had revised that line to: FIN = Me.cboFinishID But it still doesn't work. What's odd to me is that the subform errors out to 2424 only when specific parent records are pulled up and there is no reference to any parent form controls or data in this subform code. cboFinishID is a...

So I tried the below revisions based on the link but I still get the 2450 error. And it only happens when I move to certain records on the parent form (including the blank/add new record) But I haven't figured out any meaningful differences between the parent form records that have the subform...

I have the below code in a subform. The code works when I open the subform directly by itself. But it gives me a 2424 or 2450 error when I open the parent form. I've tried a bunch of different ways of referencing the control (cboFinishID) but I keep getting the error message that Access...