Search results

I'm such an IDIOT!! Thanks soooo much jgc! would you like a check or mo? :) j/k I had the code in a module, and not as part of the form, so I think the field "EmpID" was pulling air, because access had no way to be referenced to that field. I moved the code to where it was supposed to be and...

Why does it say "NO records"?? Ok, I changed: Set dbs = Current.db for Set dbs = CurrentDB, now the debug is stoppinf at the line: rstRecipients.MoveFirst Run time error '3021' No current record ??? What does .MoveFirst do? Ok, now I now MoveFirst moves the record position to the first...

No I don't need the recipient stuff. Still getting the message Error '424' "Object require" I took out the error handler and debug is stopping at the following line... Set dbs = Current.db ???? :( - Larry - VBA Amateur

OK I'm stuck When I pressed the Send button, I get the message "Object Required" ??? I get the feeling I'm not using the right reference or the DoCmd.SendObject stuff properly. My table information: table name: tblRecipients Fields: RecipientID, EmpID (formerly 'EnrollerID'), RecipientName...

Thanks for taking the time to assist me jgc, I will implement the code into my model immediatelly and will make the necessary changes. If I get stuck I will post back, and when I have a working solution I will also post the code, so it can help someone else. - Larry - VBA Amateur

jgc, The recipients are fixed for each enroller. I followed your advise. I created a table called recipients. RecipientID, EnrollerID, RecipientName, Email I then proceeded to linking the Enrollers Table with the Recipients Table added a lookup in the EnrollerID column of the Recipient's...

Re: email with criteria? Hi forum, I read many threads but didn't find what I was looking for... This is my problem... there are 9 people entering info on a form. These people are called 'enrollers' and are in a table. These enrollers send the report to different people. For example: Enroller...

Re: 2 Down; 1 to go I was able to solve two... finally! ... by reviewing my form design. The strange expression was the result of my carelessness... My SQL statement in the Query Builder for The Record Source in the Form's property was missing the ACAppsAdults.... that's the reason I was...

Re: Autolookup & weird txt expression Hi fellow developers! I have spent a whole day trying to figure out how to implement autolookup but without success... I have read numerous threads but I cannot get it to work in my db... I have no idea what I'm doing wrong. I have basically 2 tables and...