Search results

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

Lets try a bit of regular code here to ask a few questions about our tour. Lets assume we have a booking record for a customer. Ok, lets display the Tour name, and the hotel a user is booked into. Lets just assume that the user is booked to tour in the tours table (the tour table will define...

Ok, first up, there ARE reasons to start building some class objects to deal with business logic. HOWEVER, and it is a big one, in 99% of cases? Keep in mind that when you build a form + VBA in access, you ARE building a class object! Why would I want to use a class object in ms-access? The...

My answer? don't try and do this in VBA!!! Ok, keep in mind there are 3 types of .dll’s that are “common” used with Access. First type: - windows .dll with entry points A standard windows .dll, one with entry points. These are the ones that you use VBA declare statements. Such as this one...

I outline the concept of splitting here: http://www.kallal.ca/Articles/split/index.htm And here is a great primer of mine on running multiple users on a LAN and WANS: http://www.kallal.ca//Wan/Wans.html Regards, Albert D. Kallal (Access MVP) Edmonton, Alberta Canada

You can send the back end tables up to SharePoint/365, and then continue to distribute the front end to your users. The “trick” with SharePoint (SP) tables is there are several considerations: During the up-size process, the PK (auto numbers) are changed. This means that ALL of your...

As for using x64 bit version of office. That is not currently recommend (using x32 office on BOTH x32 and x64 machines is what everyone been doing since windows 7 came out). And having a mix of x64 and x32 office is going to be a source of HUGE issues The word merge code should run just fine...

Actually, you do NOT want to change nor remove the DAO prefix in your VBA code (doing so will make things WORSE and more difficult to tell if you have messed up references). All of your existing DAO code, even code going back to Access 97 should continue to run in 2013. The ONLY change I am...

Actually, since Access 2007, we do NOT need a DAO reference. JET has been replaced with a new version called “ACE”. By default the DAO reference should not be checked, and not be used and in most cases will not be checked if you create a new blank database. So for Access 2010, you use...