William Hindman
wdhindman at bellsouth.net
Thu Jan 5 08:31:06 CST 2006
...and don't forget to set the DAO reference higher in the list than the ADO reference ...or remove the ADO reference altogether. William ----- Original Message ----- From: "Bryan Carbonnell" <carbonnb at gmail.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, January 05, 2006 9:21 AM Subject: Re: [AccessD] Problem converting code > On 05/01/06, John Clark <John.Clark at niagaracounty.com> wrote: > >> The bigger problem though is that this was done in A97 and I am now >> using A2K. I will be redoing this program in A2K and the program I am >> currently working on and trying to reuse the code in, is also A2K. I am >> getting errors on the line, "Set rst = CodeDb.OpenRecordset(strSQL)" >> that says too few parameters. I am either being totally dense (a >> distinct possibility) or it is a DAO vs. ADO problem, which I can not >> get through my skull and always have problems with...making me dense >> again...hmmmm. > > It appears to be DAO code, so you will need to add a reference to DAO. > A2K defaults to ADO. > > -- > Bryan Carbonnell - carbonnb at gmail.com > Life's journey is not to arrive at the grave safely in a well > preserved body, but rather to skid in sideways, totally worn out, > shouting "What a great ride!" > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >