reggied's latest activity

  • R
    reggied reacted to Gasman's post in the thread Loop thru files in specified directory with Like Like.
    As far as I can see, those changes will not hurt any normal paths.
  • R
    reggied replied to the thread Loop thru files in specified directory.
    Ah, that seems to work! amended his code: If lst Is Nothing Then For Each varItem In colDirList Debug.Print...
  • R
    reggied replied to the thread Loop thru files in specified directory.
    I have the code: Call ListFiles("K:\CONTROLLED_DOCS\Drawings, CasaBella (SDRxxx)vE\9 Install Dwgs", , , Me.lstFileList) The list...
  • R
    reggied replied to the thread Loop thru files in specified directory.
    Tried using Allen Browne's code but the the file paths have a comma so the list box is only showing the file path up to the comma. When...
  • 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...
Show older items
Back
Top Bottom