Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am so thankful to the people who are supporting us in solving our issues...<o></o>
I am stuck with the below tool...please support me in making it work...<o></o>
<o></o>
I am creating a excel tool which is linked with access database. <o></o>
in "Col B" or "Col C" sales team will enter their product IDs and then they will click the button "Get Details", Now on the basis of the either one column the excel ie B or C VBA code should get the details from Access Database like its discount ok,no discout,see massage etc in "Col E".<o></o>
There will be some Product ID not in Database in that case the Col E pertaining to the Product to show "NOT Found" and additional message should show in "COl F" as "Contact Mgr".<o></o>
<o></o>
I can only use DAO code to integrate Excel and Access...<o></o>
<o></o>
Please help me with the sample code so that I can fix it...<o></o>
<o></o>
Thanks a ton in Advance<o></o>
<o></o>
I am so thankful to the people who are supporting us in solving our issues...<o></o>
I am stuck with the below tool...please support me in making it work...<o></o>
<o></o>
I am creating a excel tool which is linked with access database. <o></o>
in "Col B" or "Col C" sales team will enter their product IDs and then they will click the button "Get Details", Now on the basis of the either one column the excel ie B or C VBA code should get the details from Access Database like its discount ok,no discout,see massage etc in "Col E".<o></o>
There will be some Product ID not in Database in that case the Col E pertaining to the Product to show "NOT Found" and additional message should show in "COl F" as "Contact Mgr".<o></o>
<o></o>
I can only use DAO code to integrate Excel and Access...<o></o>
<o></o>
Please help me with the sample code so that I can fix it...<o></o>
<o></o>
Thanks a ton in Advance<o></o>