Search results

  1. A

    Glitch in Replace function / Object Browser documentation

    I have accidentally noticed a behavior of the String.Replace function that does not match the documentation from the Object Browser. According to the Object Browser, the default value of the optional parameter 'Compare' is 'vbBinaryCompare': However, the actual behavior is not like this...
  2. A

    Ensure releasing/closing of a handle without losing err-state in case

    I've been looking for some time for an elegant way to definitely release/close a handle (to a file or similar) in the event of an error and at the same time ensure that the Err object does not lose its current error status. If my code is in a separate class, I can use its destructor...
  3. A

    Add a "Thread starter indicator"

    Hi all, in some forums around the web there is an indicator in postings of threads (similar to the `Staff member' badge), stating that the user is the thread starter. I like this badge because I can instantly see if a posting is from the starter of the thread or not, especially in longer threads...
  4. A

    May the fourth be with you.

    Happy Star Wars Day! 😉
  5. A

    Using a Windows 10/11 client computer as a 'quasi server' for other client computers.

    I am writing this question to clarify for myself whether what I assumed so far is really (still?) true. Required services of the 'quasi server' would be file services (SMB) and Microsoft SQL Server (ODBC). The clients would use the services of this 'quasi server' from a Microsoft Access...
  6. A

    VBE custom code colors (syntax highlighting)

    I'm just wondering that here in the forum the topic of custom code colors in the VBE is not so widespread. I can't imagine for the life of me to code with the default colors of the VBE anymore. First a small digression to the topic "VBEThemeColorEditor": In the past years, I still...
  7. A

    Is SQL-Injection a topic for Microsoft Access 2007?

    Hi folks, today I was asking myself if SQL-Injection is a topic for Access (and maybe for linked SQL-Server tables/views). I expect problems for example in the filter-property and when sql-statements are 'glued' together in VBA and finally used as a query: Sample: strSQL = "SELECT Field1...
  8. A

    Search for a kind of DLookup-Field...

    Hi folks, an every few months recurring question I have is, that I would need a kind of DropDown-Box without a dropdown. :) Or lets call it a DLookup-field. Reason: In a table-field there is a value stored (a '1' for example). In the form now, I want to display the regarding text, which should...
  9. A

    Make a form completely borderless during runtime.

    Hi. As you know it's not possible to set the "BorderStyle"-property of a form during runtime. But thats a kind of functionality, i need to use in my Access 2003 application. I need to 'simulate' the value "none" during runtime, that means that there is absolutely no frame/border around the...
  10. A

    Prevent subform from being displayed in a mainforms datasheetview.

    Hi folks. I would need some help with Access 2003. I have a mainform, which contains a subform. The mainform is bound via the recordsource-property to a query. The subform is NOT bound to any recordsource and is NOT 'bound' to the mainform in any way. It is just beeing displayed (i use it for...
Back
Top Bottom