Thank you for the help from my previous post, Bill. I have managed to get the procedure to work properly. I have been busy using this new knowledge to improve the application I have been working on.
There is one little thing that I have still been having problems with.
First of all, since I plan to upsize to SQL server someday, I have been using the ADO object methods.
I still have not been able to get the FIND or FILTER methods to work correctly. I have been able to get around it by putting the search criteria in the SQL statements as BillP suggested. Here are some samples of the problems I have encountered.
rcd.Find "[part#] = " & part & "" where part is a string variable .
Am I doing this incorrectly?
Thanks for all the help....Hope I may have enough knowledge to answer questions soon.
Duane Barker
There is one little thing that I have still been having problems with.
First of all, since I plan to upsize to SQL server someday, I have been using the ADO object methods.
I still have not been able to get the FIND or FILTER methods to work correctly. I have been able to get around it by putting the search criteria in the SQL statements as BillP suggested. Here are some samples of the problems I have encountered.
rcd.Find "[part#] = " & part & "" where part is a string variable .
Am I doing this incorrectly?
Thanks for all the help....Hope I may have enough knowledge to answer questions soon.
Duane Barker
