Search results

I want that field "Update to" to pull data from FORM's combobox selection as INPUT to "Update to". So instead of typing Sheet1.FIRST NAME, i want Sheet1 and FIRST NAME SHOULD be selected from Combobox and then run the query.

Sheet1 is the Table Where All Data has to be imported to EmployeeDetails. I am using Update Query to Import Data for above. Where i have to type manually all fields i.e. where to update "Update To". TEST Query :- its the query created for update via Form Query Form :- Its the Form where...

I can use it , but you need to guide me on that. Also I have many fields to update like Father's name, DOB, DOj, etc. do i have to create vba for each of this? need you advice. thanks for your response

Dear Experts, First Thanking you in Advance for the help. I am new to Ms Access. Need your guidance in "Update Query". I am trying to update table (EmployeeDetails)from another table(Sheet1). I have made a FORM(QueryForm) where there is Combobox listing down what to Update. For...

Dear All, I have attached the db as well as photo. requesting you to download and try the same. a. Scenario ;What if someone joins new and i add his/her photo in Photo Folder and run the code again ...it still not adding. this happens when i run the code 2nd time. for first time all...

Dear Friends, Firstly i will thanks for your suggestion and help in advance. I am New to Access and not aware about vba. I need your advice. I have mentioned below the code where in a table there are fields mentioned below. a. PPLink ( Path of the folder and file name are mentioned)...

Yes, attachment are stored in Database. I have already considered the 2gb Limit. i am fine with the same requesting you to help on the code.

Hello June7, Your inputs worked. I thank you personally. I need your help in the same area. When i run the Code first time, it runs and attache's the attachment. When running it second time, it does not consider the new updates and doesn't attach the attachment and as well as...

Sorry i did its showing error no 3820. with option of End and Debug. if Debug is selected then its highlighting "rstAttach.Update"

i used the below code as per you Sub test() Dim cdb As DAO.Database, rstMain As DAO.Recordset, rstAttach As DAO.Recordset2, _ fldAttach As DAO.Field2 Set cdb = CurrentDb Set rstMain = cdb.OpenRecordset("SELECT PPLink, Attachment FROM EmployeeDetails", dbOpenDynaset) Do Until rstMain.EOF...

Hello June7, Yes i want that only. if the Image attachment is not present in the folder then it should go to next line for checking if present then attach or move next. please help

Hello, thanks for the reply. but the problem is, lets say there is not attachment, then it should pass on next line for lookup and not stop.

Dear Experts, I would like to thank in Advance for your help. I am new to Access as we as VBA / Macro. I have a DB, where if there are three fields "Student Code, PPLINK, Attachments. i have a code which helps me to auto insert Images of Student in Attachments. Where Student...