Recent content by aivars

  1. A

    why is this place so republican?

    Putin is NOT winning in Ukraine.
  2. A

    compile error: qualifier must be a collection

    Thanks indeed, @MajP.
  3. A

    compile error: qualifier must be a collection

    good evening, I have found the problem. It was/is Enum definition in a function ListObjects I took recently from https://www.devhut.net/ms-access-listing-of-database-objects/ Enum ObjectType Tables_Local = 1 Tables_Linked_ODBC = 4 Tables_Linked = 6 Queries = 5 'Forms =...
  4. A

    compile error: qualifier must be a collection

    Thanks everybody for the feedback. I'll try to follow the advice and check what happened. Will report back.
  5. A

    compile error: qualifier must be a collection

    Just found out that I had to put Access.Reports(reportName), Access.Forms etc... in the code, and no more errors!! Why it worked before and then not?
  6. A

    compile error: qualifier must be a collection

    Thanks, @CJ_London, now a new error popping up!
  7. A

    compile error: qualifier must be a collection

    It used to work OK. Now for some time it throws an error, as per attached picture. It happens not only in this form, but in others as well. Tried to use [], without [], imported/exported the forms, used Application.SaveAsText/Application.LoadFromText, even made a fresh frontend file. Nothing...
  8. A

    Open .exe without Shell

    Thanks, @arnelgp , yours does the trick too.
  9. A

    Open .exe without Shell

    Hello, on my computer Application.FollowHyperling gives a warning window (picture) Using API function, as suggested, works without popping up that window. Windows 10, Access 2021, 2207 version
  10. A

    Tabs - controls showing on all tabs

    Yes, indeed! Was going nuts for a couple of hours. Thank you.
  11. A

    Navigation pane frozen/inactive in Query builder

    Yes, everything is normal when a new query is opened. Having read what Pat said I understand it's a normal behavior and I'm amused why didn't I notice it earlier. From now on I will also make the rowsources and recordsources saved querydefs. Thanks for the tip. This forum is great and you guys...
  12. A

    Navigation pane frozen/inactive in Query builder

    office update force said I'm up to date. Ok, let it be, but I somehow feel it was not like that before... in this windows I could see the Navigation pane, open any other form, report, etc.
  13. A

    Navigation pane frozen/inactive in Query builder

    Thanks, arnelgp. I am not very experienced Access user and honestly, I do not remember how it was before. While in this rowsource of the combo I wanted to see some other table and found out I could not. If this is how it should be then ok.
  14. A

    Navigation pane frozen/inactive in Query builder

    Hello, Not sure where to post this. When getting into query builder from a combobox row source on a form (clicking ...) the Navigation pane and other open tabs (tables, forms, etc) are greyed out and are frozen/inaccessible (see yellow arrows). Navigation pane closes as well. I suspect this...
  15. A

    Free books

    Thank you.(y)
See more
Top Bottom