Search results

That's weird. From a file system point of view those folders are just completely normal folders. On my end Everything shows the expected result:

@isladogs, the above statements are incorrect. The files in the VFS folder are not "provided as a backup", as explained in my previous post, which I started to write before seeing yours. IIRC the stdole2.tlb is optional. The library is added by default to new database projects, but it is not...

Please note: I'm not qualified to properly explain App virtualization. - The terminology I use might not be entirely correct and I might miss relevant details. The Office 365 C2R Apps are running in a partially virtualized ("Sandboxed") environment. When running these MS Office applications...

I would do some more research on the cause of the problem. It might (rarely!) happen that an Microsoft update breaks references, but then it is usually a problem that cannot be solved by simply registering a library.

What exactly do you thing is "wrong"? If the correct information about the location of a library file is in the Registry, Access should automatically update the reference to that file or still be able to find and use without updating the path.

Nice try, but the latter causally determines the former in this particular case only. Because the extension is no longer in the main file name textbox, the file name is 4 characters shorter than before and thus you now see the 3 first characters, which were previously visually truncated. If the...

Indeed, this is rather unusual. I don't think I ever tried to do that before. In the specific case of this scenario, it is very likely that the user wants to import the same file again and again. - It's an Excel file that gets updated periodically. - So, I thought it would be convenient for the...

You can copy, paste, and run the function provided in the original post to see for yourself. No. As per my research, it started with Vista and affects every Windows version since. I see this on Windows 10. As far as VBA in other MS Office programs is concerned, yes it does. The other mentions...

The size of the dialog and text box is mostly irrelevant to the problem. Only when the dialog is displayed at full-screen size the file name is displayed in full. I personally dislike it when a file dialog is opened full size. But this is also irrelevant, as its not me who is using this but...

Not sure what you feel guilty about. It actually makes a difference. While the initial directory is still set, there is no file name pre-selected at all. - So, this difference does not really help.

Has someone a simple(!) workaround for the default file name appearing to be truncated (on the left) when it is displayed in a File Open Dialog? The full file name is: "test_default_file.txt" This is also the actual content of the control, it just appears truncated. Only the rightmost 18...

Exactly. That was the problem. Access automatically changes the new correct code, as posted by arnelgp, to the old incorrect code. There is nothing you can do about that unless you change the Regional Settings. PS: If you want to see the effect yourself, try to use: $#.##0,00

They didn't ignore that. They reported what happens when applying the suggestion. @arnelgp's suggestion is basically correct. I guess that @access2010 has different Windows Regional Settings configured for his computer. I can fully reproduce the problem with German Regional Settings, where the...

Check the Find and Replace version history. There were some small update releases that fixed a couple of issues of this kind. If you can pin down a property or scenario where it still fails to find something, let the Access DevTools support know. If such a problem is reproducible, it usually...

Option Strict Unfortunately, not available in VBA.

No. It's the very definition of a function that is has a return value. If you want a method to not have a return value, you must write a Sub. Public Function TestWithNoExplicitReturnValue() End Function Public Sub TestTheReturnValue() Dim dummy As Variant dummy = "Not empty"...

That is impossible to know, if you just look at the function's signature.

Because the default method of a returned object may also be a Sub. Controls is a collection and you must pass in the index or key of a collection item. In similar previous examples this would only be certain a run time but not at compile time. So, then it would only cause a runtime error. With...

It's the other way round. ;-) There is no compile error if the return type of the function is Variant or Object. The latter is they key as to why there is no compile error. If the SetTestMode function would return an Object, the code would call the default method of the returned object and pass...

Why not?