Access Invoicing - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Invoicing

Emile Dellieu

5 years ago

Dear Richard,

I own a used goods store in South Africa where we sell anything and everything.
I have looked at several of your free vids and Beginner 2 ($1).
My system uses several tables, however, the vendors vouchers are reports originating from one table and we sell using a different table. I fdid this because I could not get the invoicing to work from the main table that included Vendors, Stock items and customers. Now, it is a procedure to copy the stock items from the vendorsT to the productsT so that we can make an invoice. I have tried AppendQ, UpdateQ etc... But no joy.
I obviously need help, which members package should I subscribe to? Thank you Emile

Adam Schwanz @Reply

5 years ago

By taking the normal courses you'll learn how to do this along the way. Around expert 8 or 9 I think it starts getting into invoicing. I would suggest going this route as I'm sure you'll learn some other things along the way that you didn't know. I strongly recommend doing them in order and not skipping ahead.

More Advanced Option - If you have some access/vba experience, here's a few links that may help.
https://599cd.com/blog/display-article.asp?ID=1664
https://599cd.com/blog/display-article.asp?ID=1667
https://599cd.com/blog/display-article.asp?ID=1666
https://599cd.com/blog/display-article.asp?ID=1515

Richard Rost @Reply

5 years ago

Hi Emile. Doing all of that isn't easy. I take several lessons to show how to do all of that, and to do it RIGHT involves some VBA programming. Adam started you off with some good links. I'd start here: Invoicing. Watch the pre-requisites that go before it if you don't know how to build a basic database, like the Blank template video. Honestly, if you want to build the best solution, I'd suggest signing up for the Learning Connection. Finish the Beginner Series and at least Expert 1 and 2. By the time you're up to about Access Expert 10, you'll be able to do what you need.

Just like a doctor has to go through pre-med and medical school before he's a doctor, you've got to put in some time learning Access and going thru the pre-requisites before you jump right into building a full invoicing system.

Emile Dellieu OP @Reply

5 years ago

Thanks for that, but, I have attended beginner 1 & 2 and 20 years ago created an entire VB system for examinations using Access 97. I'm rusty, but understand the basics of VB and databases. I have seen Invoicing 1 about 10 times (and all the prerequisites) and have followed your instructions.Therefore, what I am looking for is the continuation of invoicing, to use multiple linked tables and querries to get an output.

I'm no doctor, but I am a nurse at this :).

Does invoicing 2 offer multiple table opertion?

	Richard Rost @Reply 5 years ago
The Extended Cut for the Invoicing video shows how to use a separate product table, pick a product, and then add it to the order details table. If you want more than that, I'd suggest moving to Access Expert 10 then.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View