Hi
I appreciate the support and guidance from all the members of the site in solving the problems…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
I have created a database in Access with the columns as Prod id, description, Status, Additional information (large pool of data). Status column have different categories as available, No available, Can be arranged in 30 days & Others.<o
></o
>
In excel I have a column with product Id, Status and Additional Information…In which sales team will enter their list of products (more than one product at a time) and will click on a command button to execute the function, This function should check for the product id in the access database and retrieve the Status and Additional information in the respective product into the excel columns with Status and addinal Info..<o
></o
>
<o
> </o
>
Please help me how to create a VBA code to perform the above task….<o
></o
>
<o
> </o
>
<o
> </o
>
Thank you Once again.<o
></o
>
I appreciate the support and guidance from all the members of the site in solving the problems…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




<o


I have created a database in Access with the columns as Prod id, description, Status, Additional information (large pool of data). Status column have different categories as available, No available, Can be arranged in 30 days & Others.<o


In excel I have a column with product Id, Status and Additional Information…In which sales team will enter their list of products (more than one product at a time) and will click on a command button to execute the function, This function should check for the product id in the access database and retrieve the Status and Additional information in the respective product into the excel columns with Status and addinal Info..<o


<o


Please help me how to create a VBA code to perform the above task….<o


<o


<o


Thank you Once again.<o

