Search results

It's hard to follow your explanations just mentally, but what immediately popped into my head was whether you might have created circular references of two or more objects that prevent each other from being deleted by the garbage collection...

How about the double 'P' in 'PProvider'? Edit: I can't check it myself any further because I don't have the provider 'Microsoft.Jet.OLEDB.4.0'.

How about storing a Null instead of 0 in the field?

@DickyP : I suspect the preliminary check whether files/folders fit on another medium/volume. I had a similar issue decades ago.

It should also be noted that, at least on NTFS volumes, very small files may be stored directly in the MFT and therefore do not occupy a single extra cluster: See Windows Confidential: Just What Is ‘Size on Disk’? and/or How can a file's size on disk be 0 bytes when there's data in it?

You load the image for each form from a file every time? You could place it into the Image Gallery once for the current project and put a reference there into every form. I would give it a try. See this answer from a well known forum member which belongs to that Image Gallery. :)

If I understand this point correctly the windows of the modules in the VBE open visually one after the other and that takes some seconds over all? This behaviour I know well. The VBE will open all windows that have been opened in your last session. If that are many it takes some time. What I...

@ListO : Your problem is that forms open too slow, correct? - Does this also happen when the form is not bound to any data (table/query)? - Do you have any code in form-Open and/or -Load event procedure(s) which could cause this behaviour? Try to skip those code and test. If it only happens...

You have to set the `VB_PredeclaredId` attribute of the class `cls_EditImovel` to `True` to support calls like `Set novo = cls_EditImovel.Create(2)`. This attribute can only be set by first exporting the class to a text file in the VBE. Then edit it with a text editor and change the value of...

Did you ever read about data type characters? You have the possibility to use them to give your constant values a specific datatype, so that the automatism of VBA can be overwritten: ?&HFFFF, TypeName(&HFFFF) -1 Integer ?&HFFFF&, TypeName(&HFFFF&) 65535 Long

It could be a difference in the encoding of your password. Your stored procedure uses NVARCHAR, in your test you use VARCHAR. That results in different bytes which are sent to HASHBYTES I expect (have no time for tests right now), so the result between both calls can vary.

The author of the article uses a different character as an apostrophe than you do.

@sonic8 : Please take into account, that @TheSearcher uses a salt additionally, at least that's what it looks like, as he has listed it in his exemplary table. So assuming that this salt is concatenated to the users password before hashing, VBA would need to read this salt if it should...

Me too, very powerful, clean and good to maintain. Regarding your sample about parametrized constructors: I like to use static classes in VBA having a public method named `Create` which then can be feeded with parameters and returning a new instance of 'itself' or in more detail returning it as...

Thanks for your reply Josef. I would prefere a real finally block there, that would make life easier. :) I guess I will find places in code where I used it before then, in case I can't remember. ;) Oh, I do so, mostly, as I wrote, but sometimes for what reason ever do not. Maybe old code...

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...

@riktek : I didn't read all posts here yet, but regarding to your procedure in your opening post: If I call it in the Immediate Window like this: `?TypeName(TestNullVariant())` it returns `Null`, so it definitely does not return a string, but type `Null`.

Maybe with some fiddling and usage of this? xenforo.com/community/threads/thread-starter-op-indication.54453/

This Add-On supports different ways of making the indicator visible. I would prefer this one (marked red):

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...