Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > Account Balances Template
Back to Account Balances Template    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Pending Balances
Eduardo Benaim 
     
2 years ago
I am using your Account Balances Template from day One.
In Update 3 you introduce the use of the scripts.
Some Credit Cards have No indication of Pending Balances when 0.
"Chase Freedom Card" does Not Say NO PENDING CHARGES or anything else when 0.
As a consequence it does not erase the Prior Pending Balance to 0 when 0.

All Cards give you an available Credit.

Can you incorporate something like.
Pending = Credit + Balance + Actual ---- In the Script?

Or something that makes Pending = 0 if the script reaches the end with out a Pending Amount<> 0?

I don't want to add any code myself to stay consistent. Please suggest.
Richard Rost  @Reply  
          
2 years ago
I'll add it to the dev list. I don't think I have any cards that do that. If you could post a screen shot of the webpage, and a copy of the TEXT from the page here (XXXX out any sensitive info, of course) that would be a big help so I could see what you're dealing with.
Eduardo Benaim OP  @Reply  
     
2 years ago
Here is the File I get for CITI Master Simplicity.  
In todays texts' there are two deferent pending transactions but no total.
Skip to Content
Citi undefined
undefined
PROFILE

ATM / BRANCH
Accounts
Payments & Transfers
Services
Explore Products
Rewards & Offers
Open an Account
How can we help?
Sign Off
Good Afternoon, EDUARDO
Last sign on: Sep. 20, 2023 (8:54 AM ET) from computer.
ACCOUNT OVERVIEW
Citi Summary
CREDIT CARD

Citi Simplicity' Card
'7048
$X,XXX,05
Current Balance
Available Credit $XXXX.XX
Make Payment
RECOMMENDED OFFER
citi icon
Citi Certificate of Deposit
Save w/ CD rates over 4.00% Annual Percentage Yield
Learn More

Explore Products

Credit Cards

Banking

Lending

Investing
View All Citi Offers for You

Citi Simplicity' ...-7048

Open a new Citi Checking account

Earn $200-$2000
Cash Bonus

Activities Required.
Member FDIC.

Learn More
Recent Transactions
APPLE.COM/BILL 866-712-7753 USA
$7.74Sep 20, 2023Pending
MOISES BAKERY HB HALLANDALE BE USA
$42.15Sep 20, 2023Pending
PAYMENT THANK YOU
-$200.00Sep 20, 2023Posted
No other transactions since your last statement.
View All Transactions
I want to...

Make a Payment
Lock / Unlock a Card
View FICO' Score
View Statements
Replace a Card
View All Services
Fico' Icon
XXX
XXXX
as of 08/22/2023
XXX
XXX
FICO' Bankcard Score 8 based on Equifax data.
Learn About Your Score
icon
Citi Simplicity' ...-7048
Access My Deals
Citi Easy Deals is now known as My Deals. Find daily deals, gift card offers and local offers.
Access Now

Why Citi
Opens in new window
Opens in new window
Wealth Management
Business Banking
Rates
Help & Support
Equal housing lender
undefined
undefined
facebook
twitter
youtube
' 2023 Citigroup Inc
Important Legal Disclosures & Information
Eduardo Benaim OP  @Reply  
     
2 years ago

Eduardo Benaim OP  @Reply  
     
2 years ago
1. If there are no Pending it needs to delete the prior Pending. Make it 0. What is happening now is that if it does not find pending transactions it does not make the Pending = o.
2. I am not clear on how to parse pending$ for only pending transaction.. It picks all.
Richard Rost  @Reply  
          
2 years ago
The parse pending would be tricky if they're all listed together like that. I've got a card that does that too and I can't use their data without figuring something else out.

However it shouldn't be too hard to calculate the pending by subtracting your available credit from your total credit line. I'll add this to the dev list.
Eduardo Benaim OP  @Reply  
     
2 years ago
Richard:
I found that one of the things that always needs to be done is to ZERO the PendingText
Until you Upgrade this am using this:
'----------------------------------------------------------------------------------------
Private Sub PutValueInBalance()

Forms!AccountF!PendingText = "0"                                                 'Eduardo Benaim
Forms!AccountF.PendingText_AfterUpdate                                           'Eduardo Benaim

    Forms!AccountF!Balance = FoundValue
    Forms!AccountF.Balance_AfterUpdate
    Forms!AccountF!Balance.SetFocus
    DoCmd.OpenForm "ScriptF"

End Sub
'----------------------------------------------------------------------------------------
This way if the script does not find pending. it sets the field to ZERO.
Eduardo Benaim OP  @Reply  
     
2 years ago
One More thing:
I understand why you dont care about decimalsin this application  
To me... it drives me crazy. I need Decimals or I cant sleep. LOL.
How can one find between $ and . Plus 2 places?
Eduardo Benaim OP  @Reply  
     
2 years ago
For Pennies I added One line in "Public Function FindBetween

I Added:
' Find the end text
    If SEnd <> "" Then
        L = InStr(S, SEnd)
        
        If SEnd = "." Then L = L + 3      ' Eduardo Benaim


Now I can Sleep...
Richard Rost  @Reply  
          
2 years ago
Yeah, I could probably add that as an option. See, for me this is just a way to keep track of your day-to-day account info, and pennies just aren't that important. I still download the complete statement every month from the bank or credit card company and THAT definitely keeps the pennies so I have exact figures for accounting and taxes. But do I care day-to-day if my account has $1,203.02 or $1,203.97 in it? Not really.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Account Balances Template.
 

Next Unseen

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2025 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 12/9/2025 7:49:13 PM. PLT: 1s