UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Need Help On This Please, Access 2016    
 
   
basehumax
post Mar 14 2019, 11:15 AM
Post#1



Posts: 40
Joined: 17-June 18



Hi everyone,

Please help to record like bookkeeping so i can track when a someone take something a stuff record and give a credit limit CR DR - FROM AMOUNT which they take that time and it records next time same thing till reaches the credit limit and warm me, please note no need inventory just a field of the amount please have a look the database, you can add or change the database if you want thank you
Attached File(s)
Attached File  Credit_and_debit.zip ( 55.17K )Number of downloads: 2
 
Go to the top of the page
 
June7
post Mar 14 2019, 05:10 PM
Post#2



Posts: 373
Joined: 25-January 16



Determining remaining credit allowance requires calculating net balance of existing transactions and payments then subtracting from credit limit to determine if there is enough left to allow the new transaction. Probably use code in form BeforeUpdate event. Get ideas from http://allenbrowne.com/AppInventory.html

This post has been edited by June7: Mar 14 2019, 05:11 PM

--------------------
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
basehumax
post Mar 15 2019, 12:50 AM
Post#3



Posts: 40
Joined: 17-June 18



Hi

Thanks for the link but that only talks about inventory help please thanks
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st March 2019 - 06:55 AM