In the last issue, I gave you an introduction to Word Database Connectivity. We looked at ways you could put this ability to use and discussed why you might want to learn to do this, as well as the basic concept of how to do this.
Now we move on with our project. In this video, we plan our attack. We'll look at building the database and our form, as well as matching them up field for field. I'll give you tips so you won't shoot yourself in the foot. Why bother? I've already done that. So I'll share what I've learned over the years so you won't have to stumble down those same stairs!
I'll give you some of my code to help you make the form field building process more foolproof. And we'll consider all the custom dialog boxes you might need for a project like this. I'll show you how to get your brain working in the planning mode so you can have the foresight to consider all you will need before you get knee deep in the process...thus saving you time later.
I've been creating projects like this for years. See my samples here: MouseTrax Solutions. And yes, you can learn to use Word to create cool, custom front-end database applications, too! In this series, I'm sharing my years of experience to show you how to do it!
Note! This series will use Word 2003, but you can use 2002 and 2000, also. Due to the new XML development format in 2007, that version is not yet covered in this DB connectivity series.
Members, click to view this video lesson...
Not a TechTrax Member yet? Get the skills you need to get a better job...for a price you won't find anywhere else. Just $36 for an annual membership to view all our exclusive training content!.
Note: The above rating is for the Video content and not this small intro article.