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    
post Mar 14 2019, 11:15 AM

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
post Mar 14 2019, 05:10 PM

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
post Mar 15 2019, 12:50 AM

Posts: 40
Joined: 17-June 18


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