Search results

  1. A

    VB Script: vbs to move selected files and folders in the current folder to a new custom folder by input box

    You already knew that? You didn't tell us. ;)
  2. A

    VB Script: vbs to move selected files and folders in the current folder to a new custom folder by input box

    I expect the script will be called for each folder/file separately. You could check that by taking a look into 'WScript.Arguments.Count' (maybe with a message box).
  3. A

    Cosmetic Problem: Default File Name Appears to be Truncated in File Dialog

    Hi Phil, I can reproduce the behaviour here too with your code and wasn't aware of this and wonder that no customer ever complained. All I can provide is that I use GetOpenFileNameW to support unicode, but the behaviour is the same. Really odd...
  4. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    You're welcome. Just for info: The database I uploaded has been DEcompiled/compacted twice before uploading to avoid any trouble with precompiled modules.
  5. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    Thanks for your upload, which makes it much more clear now. I took a look into your sample of #53. These are the things I sorted out: 1. Your initial cleaning loop For Each Con In Me.txtDescription.FormatConditions Con.Delete Next Con does not delete all existing format conditions. You...
  6. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    The situation is now somewhat complicated, but there is no point in being rude. To answer your question: yes, I understand. The code and the things I am talking/writing about. What I'm talking/writing about is the solution I propose all the time in this thread. It works well when I patch @MajP...
  7. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    Sorry, @arnelgp , I tested @MajP s database already and modified it for him to show him what I mean. He agreed, all is online, you can dig inside. Something is mixed up here. Maybe we stop here and use our precious weekend in a different way. ;)
  8. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    I am confused now. Your form 'Query1' doesn't use 'FormatConditions.Add(acExpression, ...)' at all. Instead it adds conditions with 'Me.txtDescription.FormatConditions.Add acFieldValue, acEqual, 1' and tries to read a fourth condition with 'Set Con = Me.txtDescription.FormatConditions(i)', what...
  9. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    Why? Is it like this on your PC? Only @MajP s database works on your PC but no new created one? Suggestion: Upload a database where it is not working for you. Then I will take a look into it on my PC and on my colleagues.
  10. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    @arnelgp : I have now had access to the PC of a colleague who uses Access 2021, and it works perfectly there too.
  11. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    @MajP : Thank you for your approval and review. I was not aware of the fact regarding square brackets, as I have always used them there. @arnelgp : It would be very interesting to find out whether it shouldn't work like this under Access 2021. I am currently using Access 2016 and have just been...
  12. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    Why don't you just exchange the procedure 'CreateExpressionFormat' in your sample by mine of post https://www.access-programmers.co.uk/forums/threads/vba-conditional-formatting-error-because-i-have-more-than-3-formatting-requirements.332763/page-2#post-1943036 ? Edit (it is your sample...
  13. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    Already did so. See my edit. If you mean my code provided in https://www.access-programmers.co.uk/forums/threads/vba-conditional-formatting-error-because-i-have-more-than-3-formatting-requirements.332763/page-2#post-1943001, it adds 4 not 3 conditions. Did you try it at all?
  14. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    @MajP : That workaround by adding dummies (and in my workaround also deleting them later on) was the solution I used until I saw that it is not necessary any more when removing the spaces around the operator in the condition (see above). Getting rid of the dummies also brought a speed up. Edit...
  15. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    This is a known bug regarding the limt of 3. @arnelgp : Did you try my suggestion at all? I stripped the threadstarters code to a minimal sample, because I have no Outlook and don't get his huge sample running well: Make a new form with a textbox named 'JobStatusTxt' and use this code in the...
  16. A

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    @klsblues : The error "7966: The format condition number you specified is greater than the number of format conditions." is caused by having spaces in the condition of the third parameter of "FormatConditions.Add" around the operator. In your case it is FormatConditions.Add(acExpression, ...
  17. A

    Solved TextBox rendering issue (possible a bug)

    How about 100% scaling? Same issue?
  18. A

    Solved TextBox rendering issue (possible a bug)

    Do you maybe have any scaling in the Windows screen settings other 100%?
  19. A

    Emmanuel Katto Dubai : Question About Running ACCDE Database in ACCDR (Access Runtime)

    In fact it doesn't matter at all if you want to run an accdb, accde oder accdr with a runtime. All is possible.
  20. A

    Unable to create .accde

    To question #1: My experience has taught me to always create an ACCDE with the oldest required Access version. There was always trouble the other way around. But I have to admit that I haven't tested how it currently behaves for an estimated 10 years... To question #2+3: Unfortunately, I can't...
Back
Top Bottom