Search results

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

My guess would be that your code won't compile. Try to compile it and see if it shows some faults

Ebs solution works. See attached file

I don't know what you can do. Have you tried to attach a video file/

Have you tried creating a new db and importing the relevant form, query and table. Delete all records in the new db and then create a couple of fictitious records. Compact, zip and post the file.

From post #12 Can you be more specific

I would be surprised if you could apply conditional formatting to a field at the table level, after all, tables are for storing data, not for viewing.