reggied's latest activity

  • R
    reggied replied to the thread 2424 or 2450 error.
    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...
  • R
    reggied reacted to isladogs's post in the thread 2424 or 2450 error with Like Like.
    Clearly I only skim read the thread! No idea .... but I get no flicker with the use of the Detail_Paint event in my code / example app...
  • R
    reggied replied to the thread 2424 or 2450 error.
    Gasp! You are an Access VBA Savant! Works like a charm. I only added an If Then statement to differentiate backcolor and forecolor for...
  • R
    reggied reacted to MajP's post in the thread 2424 or 2450 error with Like Like.
    This should give you 50 colors per order. On current remove all conditions, loop only the colors in that order and add those...
  • R
    reggied replied to the thread 2424 or 2450 error.
    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...
  • R
    reggied reacted to MajP's post in the thread 2424 or 2450 error with Like Like.
    You may be able to do a work around. Would one order ever have more than 50 colors? If not then you could on the current event remove...
  • R
    reggied replied to the thread 2424 or 2450 error.
    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...
  • R
    reggied reacted to MajP's post in the thread 2424 or 2450 error with Like Like.
    Yep. This works no flicker. need to remove the errors in the color query. Private Sub Form_Load() removeFormatConditions...
  • R
    reggied replied to the thread 2424 or 2450 error.
    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...
  • R
    reggied reacted to MajP's post in the thread 2424 or 2450 error with Like Like.
    I you want to use conditional formatting instead of the paint event then here is how you do that dynamically...
  • R
    reggied reacted to plog's post in the thread Sorting in access queries with Like Like.
    When you have ties there's no predicting how its going to sort. If you want to ensure the same sorting you should add a unique field...
  • R
    reggied replied to the thread Sorting in access queries.
    Trying to figure out how t delete this post because the tables are not viewing correctly. Also, I solved the issue by adding a...
  • R
    reggied posted the thread Sorting in access queries in Queries.
    I have a query that only has 4 fields: SalesOrder, SalesOrderID, FabSO, and PODate. When it is sorted by PODate it sorts as shown...
  • R
    reggied replied to the thread 2424 or 2450 error.
    Attached is the db. frmSalesOrderEntryCabs is the parent form and is a list of Sales Orders. sfrmSOShipInfo is a subform that was only...
  • R
    reggied replied to the thread 2424 or 2450 error.
    good question. I currently use conditional formatting to color the cboFinishID control. Originally, I thought there would only be a...
Show older items
Back
Top Bottom