Hi, I am making an purchasing program. I would like something that when I enter the details of the purchases, it will automatically create a journal accounting entry.

I googled already, searched here for samples and in other forums but found none that fit my need.

Could someone give me a sample of this so I can start with.

Thanks. Badly needed.

iamresearcher,

(IMG:style_emoticons/default/welcome2UA.gif)

When creating a new database, the most important step is creating Normalized data tables. In other words, you should make sure that your data is organized into logical groups of data (tables), and the relationships between these tables must make sense. Here is a list of online articles that can help you get started on the right foot:

UA Wiki article on Normalization
Database planning tutorial Part I
Database planning tutorial Part II
argeedblu's FAQ on Design Strategies
Noah's FAQ on Normalization
Jerry's FAQ on Normalization
GroverParkGeorge's PDF on Normalization
A Discussion on Storing Calculated Values and Audit Trails
Jerry's FAQ on Fully Qualified Naming
Jerry's FAQ on Glossary
Danny's FAQ on Reserved Words
Autonumbers - What They Are / Are Not
Primary Keys - Natural vs Surrogate
Naming Conventions - Hungarian Notation
Crystal's ACCESS BASICS
MSKB 283878: Description of the database normalization basics
The Evils of Lookup Fields in Tables
Sharing/Splitting a Database

Hope this helps,

Dennis

Why are you posting in Visual Basic 6? Do you have an existing Visual Basic 6 program you want to improve?

Thanks for the replies.


I am was hoping that someone could give me sample how to make a program that will automatically generate accounting journal entry when I enter/save purchase transaction or any time of transaction like sales, collection, payment etc.

Have you tried QuickBooks, Peachtree, or SimplyAccounting?

projecttoday,

Yes, I have checked those softwares. But I would like to make my own software with accounting capability of those above mentioned softwares.

Google "ms access accounting database" or go to http://www.databaseanswers.org and click on data models.