britesynth
Registered User.
- Local time
- Today, 18:37
- Joined
- Mar 11, 2013
- Messages
- 88
hello and good day!
Need your thoughts on this...
1 client - many loans
ex.
John Doe
[loanID] 10 [loanNumber] 1 [Loan] 60,000 [renewed] yes
[loanID] 28 [loanNumber] 2 [Loan] 45,000 [renewed] yes
[loanID] 45 [loanNumber] 3 [Loan] 55,000 [renewed] no
if a client wants to renew his loan: [proposedLoan] - [outstandingBalance] = [renewable] 23,000
I have a table called temporaryLoan which I will use to append the new record to my Loans table
in theory [renewable] will become
[loanID] 79 [loanNumber] 4 [Loan] 23,000 [renewed] no
and
[loanID] 45 [loanNumber] 3 [Loan] 55,000 [renewed] yes
My questions:
1. any other way to auto-generate [loanNumber] every time a loan is renewed?
for now in a query I use - NewLoanNumber: [loanNumber] + 1
2. how do I make a save button which will save my temporaryLoan table only when I hit save, having a problem with duplicates when I close my data entry form (by accident, a client can change his mind, etc...)
Access: append 3 rows?
Me: whaaattt????
this will mess up my entire database
[loanID] 79 [loanNumber] 4 [Loan] 23,000 [renewed] no
[loanID] 80 [loanNumber] 4 [Loan] 23,000 [renewed] no
[loanID] 81 [loanNumber] 4 [Loan] 23,000 [renewed] no
3. save and append only when required fields are complete, I also want to delete the record on the temporaryLoan table after an append action is made - be it on after closing the form or onclick of a button
I tried using action queries and of course, I get prompts for my append and delete actions which are not very convenient after hitting a single button
Me: (clicked on my save button / appendQ / deleteQ)
Access: prompt! prompt! prompt! prompt!
4. can I do all of this inside 1 save button? me trying and failing lol
How would you go guys about this? not exactly asking for codes but flow/approach
thank you in advance
-jake
Need your thoughts on this...
1 client - many loans
ex.
John Doe
[loanID] 10 [loanNumber] 1 [Loan] 60,000 [renewed] yes
[loanID] 28 [loanNumber] 2 [Loan] 45,000 [renewed] yes
[loanID] 45 [loanNumber] 3 [Loan] 55,000 [renewed] no
if a client wants to renew his loan: [proposedLoan] - [outstandingBalance] = [renewable] 23,000
I have a table called temporaryLoan which I will use to append the new record to my Loans table
in theory [renewable] will become
[loanID] 79 [loanNumber] 4 [Loan] 23,000 [renewed] no
and
[loanID] 45 [loanNumber] 3 [Loan] 55,000 [renewed] yes
My questions:
1. any other way to auto-generate [loanNumber] every time a loan is renewed?
for now in a query I use - NewLoanNumber: [loanNumber] + 1
2. how do I make a save button which will save my temporaryLoan table only when I hit save, having a problem with duplicates when I close my data entry form (by accident, a client can change his mind, etc...)
Access: append 3 rows?
Me: whaaattt????
this will mess up my entire database
[loanID] 79 [loanNumber] 4 [Loan] 23,000 [renewed] no
[loanID] 80 [loanNumber] 4 [Loan] 23,000 [renewed] no
[loanID] 81 [loanNumber] 4 [Loan] 23,000 [renewed] no
3. save and append only when required fields are complete, I also want to delete the record on the temporaryLoan table after an append action is made - be it on after closing the form or onclick of a button
I tried using action queries and of course, I get prompts for my append and delete actions which are not very convenient after hitting a single button
Me: (clicked on my save button / appendQ / deleteQ)
Access: prompt! prompt! prompt! prompt!
4. can I do all of this inside 1 save button? me trying and failing lol
How would you go guys about this? not exactly asking for codes but flow/approach
thank you in advance
-jake