Search results

Agree. but then again, my Access applicaitons when run from RDP launch the local copy of outlook (and with attached PDF's etc.). And we do the same for hyperlinks in Access - we launch + use the local copy of web browser. So, only software we install on the RDP is the free Access runtime. .Full...

We just turned it on about 2 months ago. We have a screen in which comments for a project (one of multiple components for the project) could be searched. We also wanted to be able to search for a project name, and also that of a company name. Hence, there was about 2-4 fields, and we always had...

As noted, just turn on full text indexing. Full text indexing will pluck out each word, and thus any word any place in the text will use a high speed index. As a result, you probably not require the % sign. So, say for this text The user purchased a dell computer With full text indexing, then...

Nice tip to share! - And I often use the above. And as such ? Well, VERY hard to make the "lazy" case that no getter/setter is required, since that's what your suggesting does anyway! However, while in .net you can still just declare the var as public? (but BETTER is to use your suggesting)...

As noted, not a huge deal anyway. But, as per above, I would have just made m_Error public - and then you don't need the Get/Let. It's a minor point on my part, and in a lot of cases, I skip the Get/Let, and just declare the var as public at the class level. As such, then the var is exposed, and...

But any var declared as public in that class? You get intel-sense anyway - hard to make a case for then writing out a getter/setter, right? There are SOME use cases for Get/Set, but 99% of the time, if you just setting a var value? Make it public - you don't need the get/sets..... and in...

I not tested nor attempted to sink events into such .dll's. But, few require this ability. So, for last 10+ years of building interfaces to accounting packages, PDF merging, and a whole lot more in .net? Never needed or wanted to sink events into such external library code anyway. However...

Well, if you add a reference to the runtime host, then that's another reference that can break. So, with my .net loader, then zero additional references are required. So, if the .net .dll is written to support regasm, (exposes a com interface) then it should work with my loader. Only difference...

Yes, that FileDialog requires a office reference. To be fair, that is one reference that RARE breaks. >>My code is clearly using early binding, so you're saying I cannot call the msoFilePicker if I use late binding because that office picker is dependent on a specific Office library version...

What you share is 100% normal. If you don't want such subs public, then they will not be exposed. Some go to all the trouble to then make a public get, and set - but, really, why bother? Same goes for variables. I just make them public, and not worry about or bother with get/sets for such...

Yes, 100% correct in terms of hard coding such values. And a simple example? While I used the Office "FileDialog"? It does require the Office 16 library? You can over the years have used late binding, and thus that file dialog code would become: ' Original posted code: Dim f As FileDialog...

Yes, they should just "work", and no need to re-compile, assuming say .net 4.x. So, lets complete this example. We will build the above, and then copy the .dll into the same folder where our front end is. Our Access form looks like this: And the code behind for this simple form? There is...

Ok, so let's put all the steps together as to what you need for this to work. First up, you need the code module (and 2 .dll's) from the sample PDF merge utility I posted here. Assuming you have the above? Ok, then let's from scratch create a .net .dll for use from VBA. As noted, the .net...

Ok, a great question! >Could you give us some more details on how to create an external library, usable in Access The short answer? (with some caveats attached?) If you have some existing .net .dll’s and were/are using regasm? Well, in theory, you don’t have to change anything at all using...

1156 km! I went to the Molson Indy about 9 years in a row (done that trip many times!!). R Albert

I certainly remember your name from UA. Thanks for the kind words. As noted, Access and the community just seems to live forever. I really can't think of a platform that I used as long as Access. It's been around though what I call "several" computer generations and iterations of technology...

As I pointed out, you can get away without having to use regasm to use/load such .net .dlls. Thus, you only have to place the .dll in the same folder as the Access front end. And rather nice? Since you not using a global regasm.exe? Then you can deploy multiple front ends, and each can have...

Well, in fact I signed up to this forum in 2009, but somehow over time I spent most of my time on Stack Overflow, then then over on Utter Access. But, now, it looks like this forum is the place to be for the Access community, and thus I'm here! Regards, Albert D. Kallal (Access MVP 2003-2017)...

No worries, and no problem. Appreciate the heads-up and explain. R Albert

So, after my long post above? The question then becomes this: You have to shuffle data from SQL server to the object. You then have to shuffle data from the objec to the form. You then after editing, have to shuffle data back from the form to the object. Then shuffle data from the object back...