Recent content by Adelina_RO

  1. Adelina_RO

    ConditionalFormat in VBA

    Two year later with a solution for a 10 years old problem: don't add space between the expression elements. For I = 1 To 10 With Telefon.FormatConditions.Add(acExpression, acBetween, "1=1") .FontBold = True End With Next --> works perfectly; For I = 1 To 10 With...
  2. Adelina_RO

    OnPaint Event for Form

    I have. It's at the beginning of this thread. What the onpaint achieves (especially for continuous forms) it that it offers a way to handle each control formatting in a way that delivers more options then CF and, for me at least, in a faster and less flicker-prone manner. As you probably know...
  3. Adelina_RO

    OnPaint Event for Form

    I understand your point, but the thing is there is no place to put the DoEvents in my code as i have no loop structure. I mean, there is one, as the OnPaint runs for every row in a continuous form, but there is only one procedure. So that doesn't make sense in this situation. but i'll keep that...
  4. Adelina_RO

    Run-time error ‘-2147217900(80040e14)’ : Invalid SQL statement; expected ‘Delete’

    For me it was a driver issue... I installed Mysql connector 8.0.26 and i had this issue, but then i downgraded to 8.0.25 and things worked normally. The thing is that if i used a command instead of recordset, the update would work normally, so it was an obvious driver issue
  5. Adelina_RO

    OnPaint Event for Form

    I just might take you up on that, especially since learning from books is not my strong suite... i'm more of a trial and error type of gal' :P I have had two tries before to work with Ado.net, but always with an access backend, so now i'm going to go with an ADO mariadb connection. i imagine it...
  6. Adelina_RO

    OnPaint Event for Form

    i don't think it has a lot to do with how complicated the code behind is, but more with how many controls access has to redraw. For a few (under 20) i remember being super fast and with almost no flashing. But my forms have around 26x12 for the small one and 26x20 for the big one. I think that...
  7. Adelina_RO

    OnPaint Event for Form

    Call it as you will, but it's annoying as hell. Flash, flicker, the sensation the whole form is blinking... doesn't look very pro :))) I have played with .net and i do know about the steep curve... it got me off it a couple of times already, but each time with more knowledge :D - luckily i'm...
  8. Adelina_RO

    OnPaint Event for Form

    This was one of the first things i tried :D. Unfortunately (or, by design) the moment the Echo becomes True, access repaints everything on the screen, which in turn makes the annoying flicker. What do you disagree on? On my machine, the semi-flicker is more obvious with CF than with onpaint. :)
  9. Adelina_RO

    OnPaint Event for Form

    as you've seen, i have both options: OnPaint and CF. For me, OnPaint is slightly easier on the eye, but still... LE: i found that i can do a combination of both: i use CF for the one time painted controls (like those colored ones) and OnPaint to highlight the current row. Even faster and with...
  10. Adelina_RO

    OnPaint Event for Form

    i looked at your example and it works, but you only format a line's back color. That works as intended since, first it changes only on property of one control and it's not overlapped with other controls... i need smth more complex. I've attached a sample to give you an idea
  11. Adelina_RO

    OnPaint Event for Form

    Well, first of all, i'm super happy i got all of you to answer - Thank you! The thing is, i used to use Conditional Formatting, but i have quite a few dynamic conditions which I would change on FormLoad. i don't like that approach since i still get the flicker and if the user scrolls fast enough...
  12. Adelina_RO

    OnPaint Event for Form

    Hi people :) Basically i have one question: why does Access repaint each row by a random number of times and in a random order? (Are those two questions... :unsure:) Here is the layout: i have a continuous form where, in the OnPaint event i do some stuff (format some textboxes based on values in...
  13. Adelina_RO

    Detecting User activity and waring about idle time

    theDBguy + The_Doc_Man: thank you both for your kind messages. I'm new to this forum (actually to any forum - i'm more of a lone rider myself) so i'm still getting used to the rules and how to write a comment. And about the resume next issue, @The_Doc_Man , i know what it's used for. I was just...
  14. Adelina_RO

    Detecting User activity and waring about idle time

    The guy who wrote the initial function. Moreso, anyone using on error resume next :p. But i took that down since i don't want to offend anyone. To each his own. I just don't like that construct. It got me in a lot of trouble back when i started using vba
  15. Adelina_RO

    Detecting User activity and waring about idle time

    Just a thought: this kind of function is more usable in a small app, where setting the "Break on unhandled errors" option is an option :)P pun intended). I try to evoid that as much as possible (alway almost) since it opens a whole can of worms. I found some code here...
Top Bottom