In today's video, we're going to talk about application parts and how to create them to quickly add commonly used objects to your Microsoft Access database. This will be an expert-level video, which is a little bit more advanced than beginner but not quite up to developer level, so we don't need any VBA programming today.

So in yesterday's video, we talked about ACCDT templates and how you can package up an entire database. And then, if you want to send it to someone else, or if you want to make copies of that yourself quickly and easily, you can package it up into a template. Well, sometimes, you might have parts of your database that you might want to do that for. Not the whole database itself, but just certain parts that you might reuse on a regular basis. Let's say your customer stuff: Your customer table, some queries that go with it, a form, a report, that kind of stuff. You can package up just certain pieces, certain objects in that database, and that's what a database part is, or an application part.

So let's say here's my TechHelp free template. Let's say just the customer stuff. So the customer table, maybe I got some related customer queries here, some customer forms in here. Let's pretend I had some reports, maybe a module or so. Now normally, you could just import this stuff if you wanted to, you know, open up both databases side by side, even just drag them over from one to the other. I've shown how to do that in a couple of different videos.

But one of the nice things about application parts is that they will maintain relationships between the tables as well. So let's say you want to do customers and contacts. You want to make an application part about that. Remember, contacts are when you talk to a customer. Every time you talk to me, you put a note, like a journal, in here. That's what I consider a contact to be. I know some people say contacts are people. Yeah, it's terminology, folks. So for me, a contact is every instance that I talk to them.

So let's say, in my other databases that I build, let's say I'm building a database for client A, and he's like, well, okay, I want customers and contacts. Okay, great, I got that as an application part. I can just quickly and easily pull that into my database.

So we're going to set it up the same way we would normally set up a template, like we did yesterday, but we're going to remove anything from here that we don't want with this bundle of stuff. So I'm going to keep just the customer and the contacts. So I'll delete all the order stuff. Order stuff can go. Let's see, this order stuff can go, these blank things can go, that's contacts and customers. I can see what you're in the main menu, this stuff here. I'll delete this, delete that, delete this, and we'll keep our... No, I'm going to get rid of the global module because usually in an application part, you've already got that in the database. So, you just want to pull in the stuff you want that are related to customers and contacts.

Obviously, if you've got customer or contact related code that you always use like, you know, verify email address or something like that, and it's not in your global module, you could have a module that you do bring in. But I'm going to get rid of all these objects. Okay, so that's just the stuff I'm keeping. That's just the stuff related to customers and contacts. Okay.

Now, in this particular database, I don't think I have any relationships set up because it's my training database, and I put the relationships in here when I'm covering relationships, but normally I don't use relationships myself. Very, very rarely do I ever use database-level relationships. And I explain why in my relationships video. So if you want to hear more about it or you need to learn about relationships yourself, go watch this video. I'll put a link to it down below.

So let's set up a relationship real quick. I'll go to Database Tools, Relationships. I'm going to bring in customers and contacts and I'll make a relationship between the customer ID to that one there. We'll do referential integrity and cascade delete related records, which is dangerous, but just for demonstration purposes we'll do that. Save it, close it, and now we're going to save this as a template. So just like we did yesterday, File, Save As, make Save as.

Alright, this guy pops up. Let's call this RIC's customers and contacts app part or whatever. Description goes there. User templates is fine. If you want an icon and a preview, all that, that's fine.

Now, down here we're going to check application part. Once you do that, you can set up this thing here called a primary table. I never use this, to be honest. When you import this stuff into your database, it'll try to help you create relationships between the other tables based on your primary table. There's usually application parts. There's a primary table, like the customer table. Personally, I find this whole process confusing. I would much rather just make the relationships after I've imported my parts myself.

Okay, so I never use that. But if you want to use that go ahead and play with it. You can set something up like the customer key, and then when the wizard runs when you pull these parts in, it'll ask you what you want to set up relationship-wise. I never use that myself so I skip that.

Okay, again, instantiating a form if you wanted to run a particular form, open a form when you pull the part in so you can do some setup stuff or whatever, that's up to you. Again, I never use that. If you want to include the data, great; if not, it comes in empty. Alright, you ready? Hit okay. It does its little thing, and once again, it saves it in this spot here. So, if you want to share this with someone else, that's where you've got to go digging. Alright, but usually, application parts are stuff I save for myself. Alright, just make sure if you've got stuff in here and you don't want to lose it, if you're not doing a full system backup, make sure you add this folder to your backup routine. Alright, you've got stuff in there you don't want to lose.

Okay. All right, so we're done. We've set up the application part. There's now a template sitting in that folder. I can now delete this.

Okay, so let's create a brand new blank database. I'm going to open up Access, just open up regular old Access, create a blank database from this guy here. Alright, Database 7, whatever, that's fine, I don't care. Alright, here I am in a blank database, and I can tell it's a new blank database, and I hate it because it's got the tabbed interface on it instead of the overlapping windows. Everyone always asks me about that. If they just come across one of my videos and it's the first video they watch, they always ask, why do you not have the tabs across here? Because I like overlapping windows. I like this, old-school design, right, where each form is a window, each report is a window. That's my preference. If you want to set it up yourself, there you go.

But anyways, okay, let's pretend, you know, you're building your database, you've got a couple of tables set up, you've got a couple of fields set up, that's fine. Save changes, yes, all right. I've got table one in here. Whatever other objects you've built in this database. And then you say to yourself, oh, you know what? I kind of need some customers and contacts stuff added to this database. So, I've got an application part already set up for that. I can just pull that stuff in.

All right, so we're going to go to Create, and then over here is Application Parts. Drop that down. Here's one I was playing with earlier, basically the same thing. And here's the new one I just created, Rick's customers and contacts app part. Click on that, a little wizard runs, it'll process it. Okay, pulls it in. You're going to get a security warning unless, you know, that other database was from a trusted location, which I'm not sure if it is or not. You just enable content, it'll load it.

Okay, and there are your parts that you brought in. Now you get your customer form. See, and see, it doesn't keep your fonts and stuff. It put you, I think it put you to the new, what is the new, Aperçu or whatever it is? Yeah, see, it doesn't keep this up. This is one of the reasons why I prefer just using my TechHelp free template. I take this guy, I copy it, I modify it. I've been doing that for 30 years. So, I personally don't really use this stuff as far as application parts and stuff go, or even templates. But you guys ask me about it all the time, so I have to show you. But this is one of the reasons why it doesn't keep all of your customizations.

And if you look, if you open up the customer T, okay, let's put some data in here, blah, blah, blah, blah, blah. And okay, so there's that, the subdatasheet comes in there just fine. Sometimes it doesn't turn on the subdatasheet. Sometimes you won't see the related contacts table in there, but it does keep the relationship for you. So that's one of the benefits of the application parts, it keeps all your relationships if you like to use them.

If not, if you don't see the subdatasheet, just come into here, into design view, go to the property sheet, and this is where you can set up the subdatasheet over here. And it's got it automatically, but you can specify which one it is. This is a setting that you use, and I did a video on this too. You might have your customer table related to multiple other tables, like contacts, orders; they can all be related to customers. You can pick in here which table is in the subdatasheet.

And this is just for you; remember, this is not for your end users. We never let our end users play with our tables directly. We hide this stuff, and we make them work with forms that have subforms in them, and you can control what they do. This is just for you if you want to quickly come in here and see some stuff.

Alright, there you go. That's application parts. Not that difficult to use. Again, it's a feature I never use personally myself. I just, you know, have to show you guys how to use it because some of you have told me in comments before, because I cover this in my full course, some of you have said, yeah, it's pretty nifty. I use it a lot. You can use it for stuff that's like, you know, maybe you got an email system. It's an email form and some tables and maybe some code that's just for sending emails. And not every database you build is going to need sending emails. But let's say you're designing something for a customer, and they say, oh man, it would be great if you could send emails from the database. And you're like, oh, I've got that already built. Make it an application part. You can easily bring it in if that's what you want to do.

Alright, if you like learning this stuff with me, come on by my website, check it out. No matter what your skill level is—beginner, expert, advanced, developer—I've got all kinds of stuff in here for you. You name it, I got it. It's in there. It's like that spaghetti sauce. What is it? Prego? Ragu? One of those? It's in there.

And if you do search for something Microsoft Access related, you have a question, you Google it, you search on YouTube, whatever. If one of my videos doesn't come up, I want you to tell me about it. I want to know. I want to show up in the top search spot for every Access-related topic. That's my goal. That's my goal for 2024. New Year's resolution.

Alright, but that's going to be your TechHelp video for today. I hope you learned something. Live long and prosper, my friends. I'll see you next time.

TOPICS:
Creating application parts in Access
Using ACCDT templates for databases
Packaging database parts for reuse
Objects that can be part of application parts
Importing objects between databases
Importing tables with maintained relationships
Defining contacts within a database
Deleting unrelated objects for application parts
Setting up database-level relationships
Configuring referential integrity and cascade delete
Saving a customized segment as a template
Choosing application part and primary table settings
Specifying a form to instantiate upon part import
Including data in application parts
Locate the saved template for sharing or backup
Creating a new blank Access database
Changing interface from tabbed to overlapping windows
Using the Application Parts feature in Access
Running the wizard to import application parts
Enabling content for security warnings
Handling customizations that are not preserved
Verifying relationships and subdatasheets are intact
Adjusting subdatasheet properties for related tables
Application of application parts in different scenarios