Access 2007 programming

Closed
vishal - Aug 6, 2010 at 07:03 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 6, 2010 at 11:24 AM
Hello,

I have imported a excel 2007 file into Access 2007. The excel file 3 columns - Vendor Name, Account Name and Remarks.
I want to prepare a search form in Access 2007 with two controls on it.
[a] testbox for the user to enter the Vendor name
[b] a search command button for the user to click after he enters the Vendor name in the textbox.

ON clicking the search button, he should be displayed the corresponding Account Name and Remarks in the same form or window
Can anyone help me with this code.
Please help else I will loose my job.




1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Aug 6, 2010 at 11:24 AM
open the recordset using the sql
get the data

populate the text box

what is the issue here ?
0