My brain has pretty much gone to mush after three days of banging my head, so I am reaching out for help! I hope this does not get too confusing during my explaination.
I am using Access 2003 (and must use Access 2003 due to standardization) to set up a financial database to track transactions applied against pre-set budgets, that will reduce as they are used.
I have a number of issues, but we will start with the calculation of the warning message first.
I have been asked to include a warning message that, while the user is attempting to take money from an account that will be placed in a negative balance, will warn the user as soon as they enter the amount requested.
In essence, the input form asks for:
IO (account from drop-down list, number from tblIOLookup)
GL (subaccount to IO, drop-downj list, number from tblGLLookup)
Substantiation (Memo field)
Amount (number, to be entered)
The Budget amount is by GL (subaccount) which is stored in the tblGLLookup table. Part of the issue, which stems into another problem, is that the GL accounts are sub accounts to multiple IOs, or perhaps best described as the other way around:
IO's can be referrenced to any GL Account (i.e. IO 200494, IO 200495, IO 203760 can apply funds from GL 1131, GL 1132, GL 13999, GL 4128, etc)
(There are more than 30 IO accounts and more than 800 GL Accounts, any any IO can use funds from any GL account)
So, I believe I need assistance with the following:
a) while entering a new transaction, I need to be able to know how many dollars from a GL Account have already been used, so that when the user enters their requested amount into the Amount field, a warning will appear IF the user will put the GL Account into a negative balance; and
b) how can I query the TransactionEntry Table to have it total each GL Account and show me with IO Account has referenced the GL Account; and
***Bonus Marks!!
I have been asked to not allow a record to impact the Budget amount unless the record has been "approved" - as in the "Super-User" will go in and check off each record after reviewing the substantiation. I am at a loss as to how this can be done.
ANY any ALL assistance will be appreciated - I am on a tight timeline (I started Monday afternoon and they want to have this done by Friday, I said doubtful) so your input is appreciated!
Thanks!
I am using Access 2003 (and must use Access 2003 due to standardization) to set up a financial database to track transactions applied against pre-set budgets, that will reduce as they are used.
I have a number of issues, but we will start with the calculation of the warning message first.
I have been asked to include a warning message that, while the user is attempting to take money from an account that will be placed in a negative balance, will warn the user as soon as they enter the amount requested.
In essence, the input form asks for:
IO (account from drop-down list, number from tblIOLookup)
GL (subaccount to IO, drop-downj list, number from tblGLLookup)
Substantiation (Memo field)
Amount (number, to be entered)
The Budget amount is by GL (subaccount) which is stored in the tblGLLookup table. Part of the issue, which stems into another problem, is that the GL accounts are sub accounts to multiple IOs, or perhaps best described as the other way around:
IO's can be referrenced to any GL Account (i.e. IO 200494, IO 200495, IO 203760 can apply funds from GL 1131, GL 1132, GL 13999, GL 4128, etc)
(There are more than 30 IO accounts and more than 800 GL Accounts, any any IO can use funds from any GL account)
So, I believe I need assistance with the following:
a) while entering a new transaction, I need to be able to know how many dollars from a GL Account have already been used, so that when the user enters their requested amount into the Amount field, a warning will appear IF the user will put the GL Account into a negative balance; and
b) how can I query the TransactionEntry Table to have it total each GL Account and show me with IO Account has referenced the GL Account; and
***Bonus Marks!!
I have been asked to not allow a record to impact the Budget amount unless the record has been "approved" - as in the "Super-User" will go in and check off each record after reviewing the substantiation. I am at a loss as to how this can be done.
ANY any ALL assistance will be appreciated - I am on a tight timeline (I started Monday afternoon and they want to have this done by Friday, I said doubtful) so your input is appreciated!
Thanks!