vijay.vizzu
Member
Hi..all
I am working on a project for my users who can create purchase orders by their own. Below is my quick summary of my project.
PO Application tool, in which i am using ADODB connection to fetch details from another excel workbook which is situated at my desktop. I have created some user forms to interact with the files.
Now my problem is.. i have written some code to get details from the other workbook. But its not working, i can't able to find out the way to resolve it as i am new to VBA programming and wants to improve my skills.
Please have a look on frm_PO_Make Form. Please suggest, how can i get details of vendor like if user put vendor code, the vendor details should be displayed on assigned labels like vendor name, address, state and pincode.
Please help me .. to resolve...
I am working on a project for my users who can create purchase orders by their own. Below is my quick summary of my project.
PO Application tool, in which i am using ADODB connection to fetch details from another excel workbook which is situated at my desktop. I have created some user forms to interact with the files.
Now my problem is.. i have written some code to get details from the other workbook. But its not working, i can't able to find out the way to resolve it as i am new to VBA programming and wants to improve my skills.
Please have a look on frm_PO_Make Form. Please suggest, how can i get details of vendor like if user put vendor code, the vendor details should be displayed on assigned labels like vendor name, address, state and pincode.
Please help me .. to resolve...