Search results

Hi Friends, I will appreciate if you guy help me code this in the MS Access if i create a table as shown in the picture below. =IF($D2="Not Required in Current FY","No Visit Required",IF(AND($A2<>TODAY(),$B2=""),"Needs Scheduled",IF(AND(ISNUMBER($B2),$C2=""),"Work Scheduled...

Hi Pat , thanks for your message mate, you are soul saver. Real Gem, Can you share some sample file for it

Hi Guys & Gurus, Firstly pardon my nonsense and novice exposure to Access it's just my first step in Access actually. I am looking to create a form where if I put some information e.g 123 or ABC, it will display the complete detail of that product or thing. I did this in excel but created...

Hi Pat, I was just looking to access the folders, I checked your code too, and it's very good you have an awesome experience, i would like to make products like that, just too newbie in this domain though.

Thanks mate, you code worked awesome , appreciated your support.

Hi Pat, thanks again let me work on this to see how it goes.

Hi Arnelgp, thanks i will go through you process, sorry just saw your message.

Thanks, Pat for raising the fact there are other useful methods. The objective is i want to do quick button access to some folders for my office work purpose without leaving the access dashboard I am willing to create. Please share the other possibility and codes so I can try to see if they...

Hi Moke123, Please see my attached file , the code is placed in there but it doesn't executes for me ,not sure if i m missing some thing or what could be the reason.

Hi The_Doc_Man , Thanks for connecting to help me out, as i am too new to this Access work i am sharing my file for reference , so i created this form and then added a but and in event option i entered the code. But when i click on design view to run it will not open the local drive folder...

Thanks for your reply can you please advise where .exe should be? Can you please create an access file with a button for me where the code would be running it would give me a better understanding, I am very novice to access. First time using through codes.

Hi Experts, I want to access my local drive folder and displayed on the screen with the command button in Access, previously i had the below script for Excel to achieve that, but i am not able to replicate this in Acess , need support on this. Sub sbOpeningAFolder16() Dim FSO Dim sFolder As...