It's yours now! Always helps when you can reuse a procedure, much easier to make changes in one place vs. many....
Cheers,
It's yours now! Always helps when you can reuse a procedure, much easier to make changes in one place vs. many....
Cheers,
Actually I don't really use that one. I use the 3rd choice in the attached file.
It makes a half hearted attempt at checking for spelling errors before saving.
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
Thank you all for your assistance and acumen.
Agree with moke123 about a generic sub, and will sift thru that code to implement.
May need a helping nudge or three.
It's been years since I've had to look at more intensive Access logistics.
Uncertain how it got out of whack [agree I must have changed some aspects along the line], but now have to return it to functional efficiency.
Thanks again all.
- Mike
Hi Vlad,
Re "for the code in post #12 please try to add "DAO." to the declaration statements for the database and recordset variables (the default is a ADO recordset but you are working with a DAO one)."
How specifically to do that ...?
Thank you.
instead of Dim db as database, you add the reference to DAO -
Code:Dim db as DAO.Database Dim rs as DAO.Recordset
If this helped, please click the star * at the bottom left and add to my reputation- Thanks