Recent content by 1268

If that is the case can you not grab max? Sent from my SM-G950U using Tapatalk

Alternately you could just convert the query to sql and reference the variable that way or even use qry def to write the query if you needed to have the actual query for some reason. Sent from my SM-G950U using Tapatalk

Dim adfile1 as CDO.bodypart Din adfile2 as CDO.bodypart Set adfile1 = objsendmail.addattachment(yourattachmentfullfilenamewithpath) Repeat for the second attachment. Sent from my SM-G950U using Tapatalk

Not sure you can if the form is bound to an autonumber table. I tend to not bind my forms and just query the form data into my tables on update. You could run a query on update to append non blank to a final table. I am sure someone here will have a better answer. Sent from my SM-G950U...

What plog daid. And remember if you want to set a variable equal to something you have to tell the progran how to get it. Ie dlookup or recordset. Sent from my SM-G950U using Tapatalk

My context wasnt great. [emoji16] Sent from my SM-G950U using Tapatalk

But the csv name, location and column header dont change do they? You just save over the old csv file? Sent from my SM-G950U using Tapatalk

Ditto Sent from my SM-G950U using Tapatalk

X2 always set things back to nothing and have stout error handling. If u can step through and find the exact point of failure ut helps diagnose too. Sent from my SM-G950U using Tapatalk

Each iteration you save a csv with the same name in the same spot? Why do you need refresh? Maybe I am missing something. Sent from my SM-G950U using Tapatalk

I would imagine not. It can be done, what specifically is your concern or what do you need help with? Sent from my SM-G950U using Tapatalk

Sure, I've used sap. Sent from my SM-G950U using Tapatalk

Right?!? Access can be so open ended, there are often many good ways to do something, a few poorer options, and sometimes even a most right way, but there is almost never one way [emoji16] Sent from my SM-T813 using Tapatalk

Surprised to find more than one way to do something in access.... *sigh Sent from my SM-G950U using Tapatalk

Yes use vba. Build a who loop and call the what function with the who variable. Build a what function getting the what based on the who. Call the email function with what and who. Build an e-mail function based on who and what. In this way you can have the flexibility to send to groups or...