Recent content by Mina Garas Daniel

Thanks for your response No its not for report this data in table and I need to calculate sum of qty to calculate percentage by divide qty / SumOfQty That's all And may I use SumOfQty in another calculation in another query Thanks

Hello everyone I have a simple question I have a table containing Code , description , qty and sum columns I need to make sum of qty in sum column I try to use subquery instead of dsum to get better performance as I read on this forum but it does not work is any way to do that specially my...

There are SQL sentences for layered quries Qry1 SELECT QOD_OrdLog.ODID, QOD_OrdLog.ODPK, QOD_OrdLog.PDate, QOD_OrdLog.Kitchen, QOD_OrdLog.Job_Order, QOD_OrdLog.TDPK, QOD_OrdLog.ERP_Code AS FP_ERP_Code, QOD_OrdLog.Item_Eng AS FP_Eng_Name, QOD_OrdLog.Item_Arb AS FP_Arb_Name, QFP_RecPHIP.Unit_Arb...

I will do that.thanks for your support

Those layered queries using for doing calculations the second one I build it based on first one the third one based on second...etc

Dear Isla, thanks for your entity I try your entity what i found when i open your form i found 507 available when i open 7 queries decrease to 154 available queries and query no. 8 also not opened and message of error 3048 appear again what i have to do more to fix it

When I spliting database to front end and back end

Hi everyone i have a problem i face it for first time I have a database with queries layers for 8 levels when DB in single file all queries working perfect when i split it open only 7 queries then error message appear " cannot open any more databases" i researched this issue all results says...

Thanks alot for your support I just want to know if my approach right or not based on your comment it's right thanks alot again

Thanks so much for your care, i try fixed version by you its working fine if i not activate ModifyStartUpProps sub in splash screen onload event i attched my copy after activate this sub and unfortunately ribbon appear again Please check attached file thanks

i do something that fix the problem partially i edit the code to be like following Sub ModifyStartUpProps() 'Call this from your startup form On Error GoTo Err_Handler 'Delete existing start up properties DeleteStartupProps "AllowFullMenus" 'DeleteStartupProps...

Dears I can't find a solution i reinstall office it self, when i use codes for hide ribbon and nave pane but when i use @isladogs method when i put in onload event for splash form to reset startup properties ribbon appear again i need to use this module to disable special keys and menus any...

thanks for your response i have a question is accdr working for multiuser environment or must using accde

Thanks for your response and effort, that what i say when i need to hide nave pane and ribbon its working but i need also disable other properties like special keys, menus, right click ... etc so i use @isladogs modules but when i use ModifyStartUpProps in onload event for splash form ribbon...

Thank you very much again for your response and great effort that clearly appear in tht link really codes very useful, i literally follow your codes for Hide Nav pane Hide ribbon Bybass shift key until here every thing is ok when i test the db every thing working good but i don't know why...