Search results

Welcome to the forum :)

Welcome to the forum :)

Perhaps you need to change from Tabbed Documents to Overlapping Windows. See this short video...

Well quite!! but if you simply count the number of days in the period of leave, that's what happens;)

Also, keep in mind that you would need something other than Access for the backend if the network is not a wired network.

<Phuduhutswana> When entering and calculating leave taken, will your app need to differentiate between the employee's usual working days and those that are not usual working days? i.e. if an employee usually works Mon - Fri (5 days) and goes on leave for one week, will you calculate that as 5...

Oh, George. I admire your eloquence.

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: