MajP's latest activity
-
MajP replied to the thread Windows Colour Dialog (aka ChooseColorA) - can the "basic" colours be changed?.The "More Colors" uses the Windows color picker (not Access) so you are limited to what the windows API exposes. I am not very good with... -
MajP replied to the thread Database Properties - Did you know.That seems unlikely, but there are cases where you can add a property and add a value where one does not exist. Example. You have a...
-
MajP replied to the thread Windows Colour Dialog (aka ChooseColorA) - can the "basic" colours be changed?.There are two parts to this. The form I developed is an access form and can be positioned through code wherever you want. The "More...
-
MajP replied to the thread Database Properties - Did you know.The thing that took me a while to get my head around is that there are all kind of Default properties that "do not exist" until you add...
-
-
MajP replied to the thread Database Properties - Did you know.For a long time I used this db example for property setting and getting. It was a nice utility, but it is 32 bit and I cannot even open...
-
MajP replied to the thread 2424 or 2450 error.I was getting flicker too.
-
MajP replied to the thread Solved Starting Appended Data at 1.No just like you did. Remove the related table. C&R. Add the related table back. I am guessing that is needed in both methods.
-
MajP replied to the thread 2424 or 2450 error.This should give you 50 colors per order. On current remove all conditions, loop only the colors in that order and add those...
-
MajP replied to the thread 2424 or 2450 error.But that is the problem the OP is trying to avoid with the Paint event. The OP already has the colors in the table. My question is why...
-
MajP replied to the thread Sorting in access queries.To have tables post correctly see discussion. This used to work...
-
MajP replied to the thread Solved Starting Appended Data at 1.I am wondering if you delete the relationship if C&R would do the same thing.
-
MajP replied to the thread 2424 or 2450 error.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...
-
MajP replied to the thread 2424 or 2450 error.Yep. This works no flicker. need to remove the errors in the color query. Private Sub Form_Load() removeFormatConditions...
-
MajP replied to the thread 2424 or 2450 error.As far as I can tell this is some kind of timing error. That control is not rendered when the call is made. This fixes the problem...
-
MajP replied to the thread 2424 or 2450 error.I you want to use conditional formatting instead of the paint event then here is how you do that dynamically...
