I'm writing a VB program to move data from Access to a file in a specific format. I keep encountering an error that I can't seem to figure out. The error is "No value given for one or more required parameters". I get this error for the following line of code:
Set MyBudgetSet = MyConn.Execute("Select * from BudgetItem where ProjectNumber = " & Chr(145) & strProject & Chr(146))
The whole program is attached. Any and all help is appreciated. I'm stumped.