Hi everyone - My name is Christian

[chgeiselmann]

Dear all,

Searching for a solution for an Access-to-Word data transfer problem i discovered your community here and I already found 2-3 very helpful threads for this topic.

My name is Christian, I am working at the municipal community education centre in Hannover, Germany. I use Access databases from time to time for managing complex projects. I once created a customer and orders handling database for a small business, then a database for handling contributions to a regional educational database for a regional adult education network, and currently (2025) I am working on a database to help me personally manage staff training activities. So, questions I might ask or topics I might search will always be related to solving concrete problems I face when programming Access databases using VBA.

I am not a trained programmist; rather a completely self-taught amateur. Anyway I went through projects with over 10000 lines of code (and comments).
This experience is balanced by the sporadic character of my VBA programming activities, and you know very well: muscles that are not used will deteriorate.

Kind regards
Christian

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[The_Doc_Man]

Hello, Christian, and welcome to the forums.

Since you identify as a self-taught amateur, I will make a suggestion that will help you in your current and any future Access projects. An important topic I HOPE you have studied is "database normalization." If you HAVE studied this, great! It will help you in all future DB design issues. If you have not yet done so, take a little time to do the research.

Since this is a database forum, you can search in-site for "normalization." However, if you choose to search the general web, be sure to look for "database normalization." This is because the word "normalization" appears in databases, mathematics, chemistry, psychology, and international relations among other topics. Start with articles in the .EDU domain, but once you feel comfortable, the .COM domain is good, too. I suggested to start with .EDU sites because the .COM sites frequently have something to sell you.

We recognize that there are many kinds of database normalization, but we recommend that when you start designing, you at least try to reach what is called 3rd-normal form. Anything beyond that is valid, but for simple situations, the higher levels of normalization would be overkill.

 

[theDBguy]

Hi. Welcome to AWF!

 

[chgeiselmann]

Hello, Christian, and welcome to the forums.

Since you identify as a self-taught amateur, I will make a suggestion that will help you in your current and any future Access projects. An important topic I HOPE you have studied is "database normalization." If you HAVE studied this, great! It will help you in all future DB design issues. If you have not yet done so, take a little time to do the research.

Since this is a database forum, you can search in-site for "normalization." However, if you choose to search the general web, be sure to look for "database normalization." This is because the word "normalization" appears in databases, mathematics, chemistry, psychology, and international relations among other topics. Start with articles in the .EDU domain, but once you feel comfortable, the .COM domain is good, too. I suggested to start with .EDU sites because the .COM sites frequently have something to sell you.

We recognize that there are many kinds of database normalization, but we recommend that when you start designing, you at least try to reach what is called 3rd-normal form. Anything beyond that is valid, but for simple situations, the higher levels of normalization would be overkill.

Hi Doc_Man,

As far as the good practice of avoiding redundancy (no piece of information being stored in more than one place) is meant here: I am following this principle since my very beginnings. That's the very idea of a database: storing and processing data effectively. And be it avoiding typing in one and the same information twice.

Kind regards,

Christian

 

[NauticalGent]

Welcome aboard!

 

[jwcolby54]

Welcome @chgeiselmann. A lot of us started as self taught, myself included. Many of us continue that way. This board is a great resource for real world experience from helpful folks.

 

[mdlueck]

Searching for a solution for an Access-to-Word data transfer problem i discovered your community here

Very good way to discover this very helpful on-line community!

This year, exactly 30 years ago I was developing a solution involving: WordPerfect for Windows / Paradox for Windows / DB2 running on OS/2 to drive creation of documents. I used DDE to interact between WordPerfect and Paradox.

I then used that skill to do it again involving: MS Word / MS Access / SQL Server between 2012 to 2014. I used Word objects within Access VBA to allow the database to write Word documents. I use Late Binding type syntax for all VBA objects in my code.

Welcome!

I am thankful,