Recent content by ebbsamsung

Sir Arnelgp, Thank you very much for that brilliant modification. It really fits the revision needed for my simple db. Have a nice day! :):):):):)

Sir Arnelgp, What i mean to say is recursive folder search-find files in sub-directories. Is is possible for this code?

Sir Arnelgp, Thank you very much for the revision of the code sir arnelgp. Its working fine if i supply the full path of the file which is inside the subfolders. This is the full path: S:\Final_Dossier_Files\Part 3. Construction and Commissioning Manual\Section 1_General\Subsection 1-1_General...

Good day Experts, Here i am again for a revision of my simple db based of what my boss said. Is it possible to modify this piece of code with the following modification? Sample: I have two criteria: If Not qualify to this criteria filetosearch = Me.No & "_" & Me.DocumentNo & "_" &...

Sir Arnelgp, A million thanks sir arnelgp, it helps me alot....I can now sleep well tonight.:):):). I can now relax for few days before I leave the company. To sir ridders and the other experts in this forum, THANK YOU SO MUCH:):)

Sir Ridders, Thank you so much sir for your reply, I will definitely study when i leave this company by the end of the month. I am very sorry, I was in hurry to finished the simple db to be given to my boss before leaving. Have a nice day!

Sir Arnelgp, Thank you very much.....Actually, I am already finished simple db using 32bit Office and not considering the 64bit Office users. Then suddenly I was bumped into this when i try to run in another pc or laptop, then there it happened that they were using 64bit. I have 3 modules...

Sir Arnelgp, I used the code but during compiling it marked red this part but no error occur. Please check sir arnel for me whats wrong. Option Compare Database Option Explicit Private Const WM_SETICON = &H80 Private Const IMAGE_ICON = 1 Private Const LR_LOADFROMFILE = &H10 Private Const...

Sir, Here I am again for this problem, I adapted a code running in 32bit MS Access but now I faced this problem if possible to make this code runs in both 32bit and 64bit when they use this database. Is is possible like this? If 64bit run this code else32bit run this code. How can I make it...

Sir Arnelgp, Thank you very much for that piece of code, it helps me alot... Its running now, I just miss-look the end function. I deleted it already and its running fine now. Thank you once again sir Arnelgp. :)

Sir Arnelgp, Thank you so much for helping this code to make it right, Its actually working but the problem now another error message coming pointing to another function. Could you please see it for me the screenshot i attached? Thank you

Sir Cronk, Thanks for the reply, could you please guide how do i make it? I am a novice in VBA actually. Thank you!

Dear Experts, Good day! I found a code to re-link frontend to backend exactly as I want to happen when the DB is open. But when I call the function there is an error occur. Is there any thing that I need to change to work this out or am i wrongly put this in my start up form or wrongly calling...

Sir Ridders, First and foremost, allow me to re-post the successful guidance of Sir Ridders.Thank you so much for your patience and sharing your expertise to get the exact code for my db. :) Anyway, the code was running perfectly, so for those who encounter like this problem, this is what i...

Sir Ridders, First, I modified the path and the If statement by adding "*" in it and its working fine to pop up the pdf file and if nothing there, the last part of the code wont pop up the window explorer pointing to the folder. Second, if i retain as is your code, it will not pop up the pdf...