Search results

My file name is EmployeeID . See the red marked. Me.txtEmployeePicture = DLookup("FolderPath", "tblFolderPathSyncing", "FID = 1") & "\" & Me.EmployeeID & ".jpg" Me.txtPassportPDF = DLookup("FolderPath", "tblFolderPathSyncing", "FID = 2") & "\" & Me.EmployeeID & ".pdf"

Its work! :) . Private Sub CallDisplayImage() Me.txtEmployeePicture = DLookup("FolderPath", "tblFolderPathSyncing", "FID = 1") & "\" & Me.EmployeeID & ".jpg" Me!txtImageNote = DisplayImage(Me!ImgEmployeePicture, Me!txtEmployeePicture) End Sub EDIT : can someone help me to displaying PDF file...

i also tried this module link do it. But its just display Path and do including the Employee ID

There is ONE folder for ALL employees, as same EACH items for ONE FOLDER, but its distributed by employee ID

Actually, I would like to do, if I open my frmEmployee then path of Image textbox display like : "E:\TEST LOCATION\EMPLOYEE FOLDER\IMAGE\1.jpg" And path of pdf textbox display like : "E:\TEST LOCATION\EMPLOYEE FOLDER\PASSPORT\1.pdf" My Ideas is something like that, fncIsLoadLoc "Collect Main...

tblFolderPathSyncing is my folder path for including database. See that attached picture. Yes, Option Compare Database Option Explicit this is mistake. because before I using two table and call openrecordset "2". forget to delete second recordset variable. Edit : Public Function...

I have 1675 records in my table of tblEMPLOYEEs. Every single items like Image, Passport, Contract etc. is separated folder and In the folder have two kinds of file type is like Image, pdf. I need a function call in my every(Where needed) textbox in Datasource filed like 'For Employee Image...

Can some one help me to auto uploaded the Image from my table location ? My app is split. Note : if my FileType is PDF then need only Path by EmployeeID

Folder Creation is solved.

if I put the code inside the loop then CREATE all folders under the MASTER FILE folder. not separated create a record value under the record value ' create sub-folder under the main folder Set fs = CreateObject("Scripting.FileSystemObject") If fs.FolderExists(SubFolderPath) Then...

okay . I will try...

It means thanks for you are again in my thread and expense much time with me.

Yes, it create last record only. I test single module, it was giving all record .. see screenshot No idea ! how I call code inside the loop.

Why does my LOOP statement's immediate window display all records? but here create only one record. Private Sub cmdCreateSubFolder_Click() Dim dbs As dao.Database Dim rst As dao.Recordset Dim rstData As Variant Dim SourceFolderPath As String Dim...

Sorry for late reply. No sir ! Not like that happens. Because, its work on first time when user like to install the app. App will look up pc main directory path then other will do automatic. That the reason I need a button to work it. Okay. Thank you for your help. I wait for some can do some...

Private Sub cmdCreateSubFolder_Click() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim SourceFolderPath As String Dim SubFolderPath As String Dim ClientFolderName As String Dim i As...

Thanks for your times. You mean, each level One by one Folder create and Sub Folder create by single click each one record. EDIT : If its true. Maybe I need to use and insert a unbound textbox for took row numbers from the subfrom. Am I right ?

Thank you very much. Its work. But not exist with my required. The problem is this line. Here I have to create twice folders as you see Parent in the sub-form. But here only create ONE FOLDER. Maybe it was call like ParentForm ID = SubForm ID No Idea how to call in VBA. I Tried to ID=ID...

Here sLocation and ONE as you callled. it was created. Ex : Main Folder\Master File\ x64 if I manually write (x64) in the vba. but I would like NAME calling from the TABLE. Also look my TABLE relations. ONE - MANY. Secondly problem is dont have sense how to call \X32 folder create.

Thank you for your suggest. I tried One Folder Under one Folder is work LIke : spath = sLocation & "\" & Me.SubFolderName.Value &"\"& here Input something But One in twice not working.