Access MS Access - Is this possible?

X

xkokox

Joined
Jul 3, 2012
Messages
2
Reaction score
0
Hello, I'm new at creating databases so I don't know much about macro and vba but I am making a database about the transactions of products my company does with various customers and suppliers. So I have all the relevant tables, queries anf forms, all ready and working but my boss(has no idea aout DBs and Access) has asked me to add these features to the forms and I've looked all over the internet forums but I can't find any solution that seems relevant...

So, he is asking me to create checkboxes for the Outstanding payments from customers and Payable payments to suppliers for when these amount are paid. So far that is fine (I have the yes/no fields in the respective tables and works fine on the forms etc). But what he wants is:
1. when the Outstanding checkbox is checked on the Transactions form, the payable amount and checkbox should appear in the Supplier Reference List form (from a query)
2. at the same time, the outstanding amount is cleared from the Customer Reference List form (another query based form) (this is so that when he runs the query for "total outstanding per customer", the result is a sum of all the outstanding amounts that hasnt been paid.)
3. Then, when the Payable is paid to the supplier, he can, again, check the checkbox, which clears the amount, this time for Suppliers.

I don't know if i explained myself enough but please let me know if you need more information and I hope there is a way.
Thank you very much!!
 
xkokox said:
Hello, I'm new at creating databases so I don't know much about macro and vba but I am making a database about the transactions of products my company does with various customers and suppliers. So I have all the relevant tables, queries anf forms, all ready and working but my boss(has no idea aout DBs and Access) has asked me to add these features to the forms and I've looked all over the internet forums but I can't find any solution that seems relevant...

So, he is asking me to create checkboxes for the Outstanding payments from customers and Payable payments to suppliers for when these amount are paid. So far that is fine (I have the yes/no fields in the respective tables and works fine on the forms etc). But what he wants is:
1. when the Outstanding checkbox is checked on the Transactions form, the payable amount and checkbox should appear in the Supplier Reference List form (from a query)
2. at the same time, the outstanding amount is cleared from the Customer Reference List form (another query based form) (this is so that when he runs the query for "total outstanding per customer", the result is a sum of all the outstanding amounts that hasnt been paid.)
3. Then, when the Payable is paid to the supplier, he can, again, check the checkbox, which clears the amount, this time for Suppliers.

I don't know if i explained myself enough but please let me know if you need more information and I hope there is a way.
Thank you very much!!
Click to expand...

Hi
Question is a bit complicated however
When you do something like push a button or check a box you can create an event.
This Event can the contain the code you need to do whatever you want.
Start by creating a button, use it's 'on click event' to show a messagebox e.g. msgbox "Hello World"
VBA is very powerful.
Macro before Access 2010 were a waste of time.
Good night.
 
Back
Top