I want to open an access db using vb code, and change the dbgrid Recordset source depending on sql code. Is this possible?
Lets assume that I have an access query that has 20 names, I want to write code that depending on what name is in a textbox in VB, it will pull only those records in vb.
If that is not possible, then I would choose to write code to change the sql in the actual access database (from within vb) to fit what is in the text box in VB form. Is this possible?
Thanks for your help!