Hi I am very new to VBA. I am hopping to be able to lookup an address from a MySQL table when the user types in the person's ID. I.e. I would like to have a template where the user enters an ID code and a macro goes and looks up the address details from the database and fills in the fields on the template. Anyone know of a site that gives examples of this type of macro? Thanks. Don
Hi Don Here are few good examples http://forums.mysql.com/read.php?10,100302 http://phplens.com/lens/adodb/tute.htm Please get your hand on some ADO (ActiveX Data Objects Programming). The rest should be easy for you Cheers -- http://vbadud.blogspot.com "Donald Campbell" wrote: > > Hi > > I am very new to VBA. I am hopping to be able to lookup an address from > a MySQL table when the user types in the person's ID. > > > I.e. I would like to have a template where the user enters an ID code > and a macro goes and looks up the address details from the database and > fills in the fields on the template. > > Anyone know of a site that gives examples of this type of macro? > > Thanks. > > > Don > >
In message , Shasur writes >Hi Don > >Here are few good examples > >http://forums.mysql.com/read.php?10,100302 >http://phplens.com/lens/adodb/tute.htm > >Please get your hand on some ADO (ActiveX Data Objects Programming). The >rest should be easy for you > >Cheers > Thanks.