Search results

the doubt is not about that VBA can do access the shared folder or not , what i mean is whenver the VBA can do so this means that there is risk of ability of accessing the hidden shared folder through the granted access done earlier by the VBA . if you can help post a link to method of VBA to...

i have just red a thread talking about subfolder in this post https://www.access-programmers.co.uk/forums/threads/network-sharing-folder-with-traverse-permissions.312264/post-1702051 . i am trying to understand it as i am not really good with networking and permissions . in regard of hiding...

regarding the SQL server setup , i am still studying the benefits from using it , but as far as i know , the sql is not accessible by users , it could have password protected database , it make the connection more faster for multiple users use in the same time

as you mentioned , it is easy to access the folder by typing the path unless it is password protected and hidden and only FE can access this shared folder by using the password by VBA in the same time . in this case the user will not know to which folder the FE is connected to and even he knows...

hello @The_Doc_Man , the method above looks the best solution plus the hidding the network folder by $ that @Galaxiom suggested, as i am not really expert with network and permissions , would you please be kind and make a tutorial video for this method that i can try to me app . regards

@isladogs dear @isladogs , i have red your article http://www.mendipdatasystems.co.uk/improve-security-2/4594571073 very carefully and it helped me very much improving security of my app . in this thread and in my case i would like to focus on point number( 8. Split your database ) , i...

in the filter afterupdate the dropdown list i usually use , DoCmd.OpenForm "Formname", , , "Fieldname= Forms!Formname!DropDownName", , acNormal

thank you for the reply , i have the same thoughts of spliting the tables , but i did them in 1 table coz i want to unifiy all coming requests in one list to be managed by the manager and also to get statistics of received requests like the screenshot below ,the request usually have minimum...

thank you @The_Doc_Man for your reply and taking an action to my post. yes i did the DB in access 2016 however i have imported the tables and the forms to an older 2003 format . i hope it open with you. it is attached . indeed i see it somehow complecated proccess atleast for my mind , thats...

@arnelgp @isladogs As I mentioned that I am working on travel agent request and I am facing a new challenge, It is New Service Request Auto assign : what dose it mean ? when the company receive a new service request , this request should go to a specific employee with a specific capabilities of...

one big THANK YOU , your endless support is appriciated i advise anyone pass this forum to subscribe in it , everyone here is helpful .

@arnelgp , i am greatfull for your , i know i might ask for much , for showing only lines with values what do u think if we instead of using + in the line Nz(!supplierpayment, 0) + Nz(!Collection, 0) + Nz(!arrivals, 0) + Nz(!supplierCXLdateDUE, 0) + Nz(!departures, 0) > 0 we make each s...

WOW 😄 . you are my genuse , thank you very much for your effort and time presented to me , i have spent days trying it but couldnt do it . i will study what you did to repeat it if i want to add more fields to the calender . you inspired me ,i will actually will make another calnder to have...

@arnelgp thank you for your reply i want to collect and show the below data in each day cell in the calendar if it exist . -sum of amounts should be paid to the supplier in calnder date based on field [totalbuyUSD] and [HotelOptionDate] field from the reservationQuery as supplier payment. -sum...

Hello Again best Forum Team @isladogs @arnelgp the phase that i am working in now in the travel agent project is Schudule and Summery Calender , that show important information about the future work to do based on the due date , and show also summery about some other information all in based...

mmm , interesting you did it in a smart way for the continus form , i will try to change the graphics to other to have more visual effect . i will study the code u did and if i dont understand somthing in it i will contact you as i will implement this to my database . what do you think instead...

thank you for the help , it leads me to what i need through another code in this link commandbutton-quickstyle-property . but the color number of the button varay from theme to another based on what you select in the office your reply helped .

you alwayes have reply for me. thank you dear . but can't we change the button theme by vba because it have more visual effect than solid color . i have tried this command but it have only 2 options true and false CommandButton.UseTheme property

here is the final design for how it looks thank you all for support . the bar here is a commanf button with theme . i want to change the color of the button to be linked with the achived of the target , like under 25% the button color will be red , between 25 and 75% the button theme to be...

@isladogs @MajP thank you very much , it fixed the error. i have self learned access . so i am not pro in it as u all are . you all helped me much , i am greatful to you all .