Search results

Yes, you are correct!!! (happy to be corrected on this issue == thanks for the follow up). So, ignore my "narrative" on needing some extra textbox or control to receive the focus - not required. So, good = don't try to use the UI for this - use recordset data processing. So, bad = my bad is...

As a general rule, no, if there are no other controls on that form, then hitting tab will not fire the after update event. However, in this case, we MOST certainly have another control on the form - that's the sub form control! And that means that focus is now moving from main form to sub...

Excellent! And the UI will be smooth as butter for this operation...... And like everyone else here? Just adding my 2 cents worth here..... As noted, if there is only one control on the main form, and when that "scanner keyboard" hits tab for you? Make sure there is another control on the main...

A few things - but just a quick look here at what we have so far? First, don't use on-current - avoid if possible. Next up, a goToControl is placed/moved to the sub form. I suggest to NOT do this. So, keep/write ALL of the code in the main form - don't use the "UI" to set focus in sub form...

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