Update sales system
After some time without updating the Blog, I finally got some time to update the sales system. Many readers could not get due to the system login password asked. So, I removed the login system for easy access.
Apart from this change made the following changes:
V 0.5.0 (2010-08-19)
- Removed the login and users.
- Added fields (family, iva and unity) in the products table.
- I created a table of VAT.
- Amendment of the Products form. (New fields, look, new way to find records).
- I created the table family (of products).
- Changed the form of shopping is only inserted one product at a time. I put in the form of purchasing a subform where you can enter multiple products purchased in a given supplier.
Download: 2010 Sales
All comments in a new update to fix or add features.
In the future I'm thinking about changing the location of where are the downloads of files, since if there is activity in a file for some time, the file is removed. So I will seek an alternative to easy-share for this not to happen.
In the next post I'll put a version of how to calculate benefits similar to what is already here in this post , but instead of having monthly payments can only choose the number of days elapsing between each installment. This example will also serve to answer a question from a reader ( Marcelo ).
Since metadsted ee years following his blog come even though he is dead I have learned much more by creating a doubt was also selling my system and tried to create a module equal to its procurade of products to add the desired product clicansorbos and he could not but I can help?
Note: Invez of "ref" use "Bar Code" instead of "product" use "description"
Desuclpe comments to two equal but not here came the post
Beware of giving names to the fields .... "Bar code" is not a name very advisable since it has accents ...
Hello I have been following your site for a long time even though he is dead alguras seized things but not enough to make a coizinhas you made in the sales system and would like your help.
Items with a question:
Search in product-form produtoscon adicionalos to form the products for sale ... could not create a similar on my project.
Do not forget to set the global variable in the module:
Global txtreferencia As String
After the form produtoscon by double-clicking a line we want to assign the value of this line for variable txtreferência:
Product = txtreferencia
After the form assign the sales value of the Ref txtreferencia
Dude you could not change a thing that was bad. Q The time you FEXA sale, if qr apareece print. This is perfect, but the formula is made for printing q ta bad investment for ID.venda puts the product.
Thank you.
The field id.venda is what sets the record you want to print, which I do not understand the purpose of getting the product!!
Explain that you want the best ...
Hello, I have been following your excellent work in the field of databases, in which I also love working.
Your Sales System is very good, really good muiyo, Congratulations on this
I wonder if I could help in the following:
I wonder what the code to place a button, Purchasing Today, so that when you click, I return only the records according to the present date.
Does it help me?
Congratulations for your excellent work!
Cumpimentos
Just make an appointment and as a criterion to put in the date field = today ()
Dear Mr. I came across your site and could not resist to take a look at the complete system of sales.
I liked it, but the similarity of VAT shall not be able to create a home addition to the percentage of profit on the product?
Thank you.
The VBAs are not working in office 2010 64bit.
All examples are made in Access 2003, so it's normal that does not work in 2010.
I've been testing its system sales in 2010 and came across a problem:
In Sales Form when creating a new sale does not erase the previous one and if you delete the item it returns to stock.
I went back to the site and downloaded the previous system with that login and that works corrtamente, checked whether it will give me a warning.
I also find that printing should have a description of the product and not the code.
Hugs
[...] Example of shelter animals and sales system in the example there is a form where we can put a photo. After using this code checked [...]
I thank you for the great tips and the availability of being able to download the system vendas.Contudo this was done in x86 and x64 I have gives me an error saying more or less what "I have to actulizar for x64 and to review and update the "Declarate statament" and mark it with the attribute "Ptrsafe" .. just understand where the n-by?
Could please give a little hint how to do so run in 64 bit?