hi, wabeg,
if i am reading this right, you are storing the numbers in text fields. you will have to convert them to numbers with
functions such as cdbl before you can do the division. i don't think the "sum" is necessary. TestDrive
rlh777,
one way to do this is to add the "mailto: " string right before your email address. simply use the update query to update old records, and use very simple VBA to add this string for all new entries. TestDrive
i suspect that you have your ADO library priorized before your DAO library in the References.
go to Tools --> References and re-priorize your libraries and make sure that your DAO is listed higher than ADO.
however, if you need to reference and use both DAO and ADO Recordset objects, dimension...
i suspect that you have your ADO library priorized before your DAO library in the References.
go to Tools --> References and re-priorize your libraries and make sure that your DAO is listed higher than ADO.
however, if you need to reference and use both DAO and ADO Recordset objects, dimension...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.