By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,388 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

Help me I, am new in ms access

P: 1
hey friends,

I want to create some database for my invoicing needs.. but i dont have any idea how to create database and invoice in ms access. below is the structure which i need to work on..
-------------------------------------------------------------------------------------------------------------------
Distributor Name: ________________ which put from a distributor database.
Reference person: ________________ which put from a reference database.
Debit Note #: ______________ Month: ___________
================================================== =======
Invoice # : Invoice Date: Customer Name: Product : Quantity : Company Discount %: Distributor Discount%: Company discount in Rs. Distributor Discount in Rs. : Total Discount in Rs.
================================================== =======
1111: 02.10.2006: ABC Clinic: Fruit Jelly: 10 : 3%: 2%: 10*3*product rate: 10*2*product rate: + company discount + distributor discount:

================================================== =======
Total Company disc: Total Dist Disc: Total
above is a sample of invoice which i want to make in access. If anyone can make this invoice with reports plz help me.
Regards
Rahim Jan
Oct 31 '06 #1
Share this Question
Share on Google+
2 Replies


southoz
P: 24
hey friends,

I want to create some database for my invoicing needs.. but i dont have any idea how to create database and invoice in ms access. below is the structure which i need to work on..
-------------------------------------------------------------------------------------------------------------------
Distributor Name: ________________ which put from a distributor database.
Reference person: ________________ which put from a reference database.
Debit Note #: ______________ Month: ___________
================================================== =======
Invoice # : Invoice Date: Customer Name: Product : Quantity : Company Discount %: Distributor Discount%: Company discount in Rs. Distributor Discount in Rs. : Total Discount in Rs.
================================================== =======
1111: 02.10.2006: ABC Clinic: Fruit Jelly: 10 : 3%: 2%: 10*3*product rate: 10*2*product rate: + company discount + distributor discount:

================================================== =======
Total Company disc: Total Dist Disc: Total
above is a sample of invoice which i want to make in access. If anyone can make this invoice with reports plz help me.
Regards
Rahim Jan


Good ay Rahim

I'm pretty new to access myself and know how fustrating it can be ,
I'v only been working with access for just over 4 weeks but have put together a database that may have most of the answers you need.
Feel free to fiddle around with it an change what you want , you may find some of the vba interesting an use full , sorry for the lack of comments in the code but I have found most of the routines in such forums as this one.
the link to the database is

http://members.dodo.com.au/gjevers/gregw.zip


Good luck
southoz
Oct 31 '06 #2

P: 9
One of the invaluable learning resources I have (other than this community) is Smith,R and Sussman,D (2003) Beginning Access 2000 VBA, Wrox Press
its a must read for newbies
Oct 31 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.