Form footer functions suddenly stopped working

[shztexn]

I have a simple Count function and some Sum functions in the footer of a form. They are based on fields in the detail. They were working and now they just show the field outline and are blank. I have tried creating a new form, to no avail. I've tried compacting and repairing. And I've even tried a new database and they still don't work. Anyone else have this problem? This is so bizarre! HELP!

[June7]

Would have to analyze db. If you want to provide, follow instructions at bottom of my post.

[shztexn]

Here we go... My mini database form footer functions don't work for one of the groups of records. I noticed that, after a while, the totals popped up. Then I noticed on the main database and now on the mini one, that "Calculating..." can be seen in the bottom left hand corner. It doesn't ever seem to finish calculating. Hope there is an easy fix for this!

Thank you in advance.

[June7]

The Property table is not a normalized structure. Multiple similar fields is an indicator. This will probably cause you lots of frustration in the future.

What is purpose of the form? Do you want to do data entry? Into which table?

I never use dynamic parameterized queries. In this case, have to type in a complete valid property name and a valid tax year (and a valid combination of the two) for any records to be retrieved. Tax year isn't even shown on the form.

The query this form is based on makes no sense to me. Should probably be using form/subform arrangement anyway.

Not seeing issue with the footer calcs. They show immediately always as long as records are retrieved.

[shztexn]

Thank you for your input. Yes, I am self-taught and really know just enough to be dangerous. The structure of the database should be reworked to separate the similar fields into another table.

The purpose of the form was to pass the values, some as totals, to another form where the user can edit the information in unbound texts to then be passed to a report and some of the data written to a separate table at the time of print. For the original application of this form, the user selects the individual record, but in this case, all records queried are used. I am needing a count of those records to determine the appropriate report to load.

I am still baffled that the records display quickly when pulling from a database of over 110,000, but that the totals in the form footer never "finish" calculating.

Obviously I should try to think of a work around based on your feedback. Maybe the form/subform is the way to go.

PS Usually, the user enters the first part of the property name. I didn't set it up that way for the sample database. And year is a text field, not a date field, because the appraisal year spans two years, but your point is well taken! I've learned so much since the database was designed, wish I could go back and easily fix some of the structure.

[June7]

My point about combination was not the combination of years to define the tax year but the combination of property name and tax year.

Popup input parameters are just not friendly. The input can't be validated and if user errors (spelling) the query will fail and user is frustrated. Better to use unbound controls like combobox on form for user input. Review http://www.datapigtechnologies.com/f...tomfilter.html

110,000 records is not so much and the summary calcs should work. Works fine in my database. Issue might be the query. Which table has 110,000 records? Try a form that calcs on just that table, not a query.

[shztexn]

Gotcha' on the combination of property name & tax year.

Interesting about combo boxes. I was using a pop-up dialog box (form) before. But I can see where the combo box might be better.

The 110,000 records are not in one table, it is three tables with one to many relationships between them. So for the combo box there would be over 3,800 records. Is that not too many for a combo box?

Thank you so much for the link! Lots of great videos on that website!

[June7]

Maybe. If the combo has performance issues, review http://allenbrowne.com/ser-32.html

[shztexn]

Just saw your response! Thanks, but I got it working.

BUT here I am 10 months later and having the exact same problem, again! Well, guess what?! As it turns out, the way to fix it is to RESTART YOUR COMPUTER!!! We discovered this as other people were having this problem in that the totals were missing but would show up if they clicked in the field!