Search results

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.

Did you read the link I gave you regarding the use of lookups in tables? You should be using a combo on a form to "Lookup" the PK of required record and then store that PK in your record.

After making my last post, I notice that June has already mentioned some of the things that I commented on.

Take a look at the attached db. I have used your existing tables to create some new forms that may be more appropriate for your needs. I notice that you have a "Lookup" field called "What" in the table "TransTLB" which I would advise against. See...

Please post a copy of the db. Compact and repair it, then zip it and attach the zip file to your next post.

Hi Bungwaa Welcome to the forum :) I'm sure that you will find many here that are willing to help. Pleased to hear that your needs will likely be fulfilled in less than 20 years....I don't think I'll live that long :ROFLMAO::ROFLMAO::ROFLMAO: Perhaps you could start a new thread with...

June, can I ask if you have ever bought from Helpful Downloads and if so, how was the experience?

I agree. The Yes/No field serves no purpose.

Suggest that you take a look at "Conditional formatting" of your control on the form

Cross-posted: https://www.accessforums.net/showthread.php?t=89178 Please read: https://excelguru.ca/a-message-to-forum-cross-posters/

Try: Private Sub Clear_Investigate_Yes_Click() ' Fuction Name ===> In the field Investigate, Change "Yes" => "No" ' Table Name ==> update Investments01_tbl ' Field Name ==> investigate ' Change Data in Field Investigate, from Yes to No ''CurrentDb.Execute "update Investments01_tbl" & _ '' "set...

Thank you for your kind wishes. I hope you have a great Christmas and New Year too!

You're welcome. Always pleased to help i I can :)

Try changing the "Triple State" property of each radio button to No