Alright, I now want to clarify what you want.
The point 1 is that I want to develop a form which includes labels named username and password. These two labels must be able to compare the username and password entered by the user to the username and password that already exists in database.
This is for some sort of login system, right? If so, the first user would have to set up all accounts which are allowed access. Would you like to know how to do this too?
The point 2 indicates that I want to create two tables: one table that stores available goods ready to be sold and the second table that stores the information of the goods already stored. Now, when I sell a good using table two I want the number of the goods in table one to decrease per number of the goods sold in table two.
This could be easily done, but you don't expect it to be done dynamically do you? I suppose it could be done, but you would have to somehow connect the database to your cash registers or something, and would have no idea how to do that, you would probably need to hire a professional who is familiar with that. Instead, you would have to manually tell the database that you sold "x" amount of goods.
The point 3. When the number of the goods comes to a certain number (for example 20 jackets) I want the software to inform me that I have only 20 jackets remaining and that I need to supply my store with jackets. Also, when I supply my store with more jackets I need the notification window to go off.
Again, this couldn't be done dynamically without connecting the database to your cash registers. When you tell the database you sold "x" amount of goods, if it goes below your preset threshold, it could automatically alert you, and keep alerting you until you told it you restocked your store.
Please tell me if I got that all right and understand what you want.
Now a last question I have for you:
Is using VBA and Microsoft Access imperative? The reason I ask is that VBA is based on classic VB, which is an obsolete language. I started programming after classic VB became obsolete, so I'm not very familiar with it. However, I am very familiar with VB.NET, and I could probably write you an entire database application in VB.NET a lot easier than I could give you code snippets in VBA.
So, my point is, would you like to try making your own VB.NET database application which I could help you with a lot better, or would you like me to research VBA for you?
Either way is fine with me.
Edited by stettybet0, 13 May 2007 - 08:05 PM.