Search results

Yes, you can also walk off a kerb at the side of the road and cross it with your eyes closed and your hands over your ears. Just because you can doesn't mean that you should. Read the following link for an explanation of why you shouldn't ;) Evils of Lookups in tables

"Store accrued leave days" the number of "Leave Days" taken should not be stored in a table. Calculations should be done as and when needed. I hope these "Lookup" are being used on a form to store the PK and NOT as lookups at the table level. BTW Welcome to the forum :):)

Your welcome. I suspect that it's all about understanding the maths ;)

Perhaps: =([Current_Price]-[Stop_Current])/[stop_current]

Might be better to use a subform or a listbox.

Indeed. Thank you for the correction.

Perhaps something like: =([Current_Price]-[Net_Share_Cost])/[Net_Share_Cost] as the Record Source of the textbox called Percentage_PC If you are intending to do anything else with this db I would suggest that you Normalize it and get rid of the many "Lookup" fields that you have. Lookups...

Welcome to the forum :) It is probably best to start a new thread with whatever is troubling you if you can't find the answer in an earlier thread.

Hi Peter. Welcome to the forum :) Before you start on the Front end it would be wise to ensure that your tables are designed and related correctly. Can you post a copy of the db or show us a picture of your relationships window.

Ahhh.... Just a spring chicken, like me ;) :ROFLMAO:

Hi Colin Thanks for the suggestion. Actually, it was watching the video that made me want to find the download ;).

Thank you, gentlemen. Clearly, I've had another "senior" moment. I thought they were downloads for 32/64 bit versions of OFFICE. Sorry to be a bother and thank you for your help and patience.

Yes. That's the one, but I can't see a way to download it :unsure:

Can anybody please give me a link to where I can download the Access Shortcut (right-click) Tool by Dale Fye

EDITED How do you arrive at the values you have in the "From" and "To" columns of the second diagram

Instead of copying the code, what happens if you Call the buttons Click event.

Try: <CInt([How many months?])

can you post a copy of the db with a few fictitious records to illustrate the problem

can you post a copy of the db

you get that when you try to create the accde file. Open any code module, click Debug and try to compile the code