Search results

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.

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?