Search results

You're welcome. Glad that I could help. Post back If you have any questions on the changes that I made.

Try the attached file.

Can you post a copy o your db

IMHO a good db starts with good table design. Yours is like a spreadsheet. It has only one table. I would urge you to read a little on Db design, relationships, and normalization. Take a look at the attached db. I think you will need further tables. I have entered only the first record in...

Perhaps try setting Error Trapping to "Break on All Errors" in an attempt to find any code that is causing an error. Alternatively, you could post a copy the db for us to examine.

Hello. Welcome to the forum :)

Why don't you use the table as the Record source of your form and bind the controls on the form to the fields of the table?

Google translates your original post to: Welcome to the forum. I'm sure you'll get some great advice from members here.

skeletons never go to a discotheque because .................. they have nobody to dance with 🤣🤣

I don't think it's a good idea to add your question to a post that was solved over 3 years ago. Why attach a text file? You could have written all of that here. Attaching a copy of your db would be far more useful. IMHO it might be better to start a new thread for your inquiry.

Perhaps: Me.TXTCASE.value = DCount("REC_ID", "QPENSIONER_NEW", "YR = '" & Forms!SERVICE_FORM!CYEAR & "' And MN = '" & Forms!SERVICE_FORM!CMONTH & "'")

Can you post a copy of the db with just a few fictitious records.

Have you looked at the templates that MS has to offer e.g. Access Asset Tracking template. See: https://support.microsoft.com/en-us/office/use-the-access-asset-tracking-template-6e99a32c-fbda-48a2-89b0-ef0d68b381ec

Hi Colin First of all, you have done nothing for which you need to apologize. Now, what you decide to do is, of course, your decision but please keep in mind the following: There are many members here, ready and willing to help you. Some of them have vast experience in all aspects of Access...

BTW, I see that you are a new member. Welcome to the forum :)

Sounds like you should have a "period" table which could be used to retrieve values from when your 'Age (millions)' column is updated. BTW, better to avoid the use of "special keys" e.g. )(# when naming fields. Can you post a copy of the db

It's surprising the little tips you can pick up from places like this ;)

Have you tried Google: calculate autocorrelation in excel e.g. https://www.statology.org/autocorrelation-excel/

Take a look at the file I attached in post #20

Bungwaa In the attached file I have renamed some fields and done away with the Lookups in your table. Post back with any questions you have.