Funny behavior reading controls on Subform / Access 2010 / Just want to know.

Facts
Version:  Access 2010
I have the below on a form to see the total of the subform.
                    =[Subform_01].[Form]![txtTot_Depositing]
It works fine on my computer and I've used the similar on forms - reading of subform values on multiple different applications at multiple clients in the past.  The worst that has ever happened - It took 3 to 5 seconds to populate.
I have the appropriate indexes.
The current client (Hospital - can't change anything on the machine) just sits there for a full minute and it doesn't populate.

They have the exact same problem if I try to read from a query
=DSum("[Amount_Owed]","qry_Clients_Invoice","[ClientIdd] = [txt_Id_Number]")

Question
I can solve the problem, my question is mainly has anyone seen this happening and know why?   Is it low memory?   Is it we are close to holloween?  :)

I can solve the problem
I can solve the problem by using a dao recordset - run the code and populate the field.
1) I like just reading the control on the subform because if the user is moving through 30 records, Access doesn't slow things down to figure the value.
2) I always want a better understanding of WHY something happens I didn't expect (Why the above is not populating).  It makes me a better programmer.


Just to repeat - It's a Hospital - can't change anything on the machine - Only changes can be in my database.
LVL 2
LJGAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
Slow network?

Is this computer hard wired to the network or or Wi-Fi?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you using an Access database as the "backend"? Or something else, like SQL Server?

Is this installed on a SINGLE machine at the hospital, or multiple machines?

If multiple, does the same behavior occur on all, or just one (or some)?

What's the ControlSource of txtTot_Depositing on the Subform? Is it bound directly to a table field, or are you running calculations in the ControlSource (like =SomeFunction(), or =DSum(blah blah)).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LJGAuthor Commented:
Answers:
   * Don't Know   -  Slow network
   * Yes  -  Computer hard wired
   * Yes - Access database "backend" - (Against my recommendation)
   * Yes - SINGLE machine
   * Control Source txtTot_Depositing
           =(nbrRound(DSum("[Amount_Paying]","qry_Inv_Deposit_Form_Sub_Invoices")))
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Jeffrey CoachmanMIS LiasonCommented:
Just to be clear, is the database properly split?
So in addition to having a single backendDB on a server, does each user has their own copy of the front end of their workstation?


Since you imply that it is for all users, then I would look at the network.
But may things can contribute to "slowness"
For example, if you are dealing with hundreds of thousands of records, this may never be "fast"

<Control Source txtTot_Depositing
           =(nbrRound(DSum("[Amount_Paying]","qry_Inv_Deposit_Form_Sub_Invoices"))) >
Here you are aggregating on a query, ...so if the source query is complex, in and of itself, then the Aggregation will slow it down a bit more.

Also, please clarify if this is the only aspect of this database that is slow?
0
LJGAuthor Commented:
Answers - #2
   * Yes  - single backendDB on a server,
   * Yes  - user has their own copy of the front end of their workstation
   * No  - hundreds of thousands of records - The application is just starting - Less than 100 records

   * Yes  - This is the only aspect of this database that is slow.  (It's happening on two different forms - but the same concept)

   * Don't Think so  -  query is complex, - qry_Inv_Deposit....    
                - It has 3 IIf statements
                - a few field additions
                - a few places it's reading a field from a
                      form --> [Forms]![frm_Inv_Deposit]![cbo_Client_ID]
0
Jeffrey CoachmanMIS LiasonCommented:
Then the quick thing to try would be to run the compact repair utility...

I see no need to this one value to take that long to generate...

So lets see if the other experts have any ideas...
0
LJGAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.