Recent content by MacroScope

Thank you for the help. I actually found the solution myself, and it's really just one command line. DoCmd.OutputTo acOutputReport, "*Report Name*", acFormatPDF, "*Full File Path*" & "*Name of file*.pdf", False Thank you again for going out of your way to find a solution. I always appreciate...

I created an Access report that is essentially a warning letter that is to be automatically generated when certain conditions apply. I want to print a copy of the letter for snail-mailing, and I want to save a copy as a .pdf file. Of course, opening in print mode is a simple matter, so the...

Thanks for the advice, Duane. I appreciate the help.

Is there anyway you know of that will allow me to do what I suggested? I want to correct the problem but if I can force the table to be read only except when the form is open that would temporarily solve my problem and probably provide me with an error message when the writing attempt to occur...

I agree but I don't know where this is originating and it's not happening in the normal way through a form. That's why I'm trying for this workaround. Nothing would make me happier than to see an error message that points me to where it is coming from. In the meantime, it will at least...

I have a 25 station Access 2007/SQL Server 2012 db that has developed an annoying glitch. One particular table, called Processors, which holds name, user name, phone numbers, and other data for processors on the floor is intermittently changing the name of a processor from the correct name to...

Thank you. It's now posted there as well.

I honestly didn't know where to post it. I just wanted to let others know. It can save a ton of headaches. Everything I tried based on Google searches failed, and this was one of those desperation, shotgun things. It was a tool in my arsenal that I hadn't tried and I just figured what the...

I'm posting this to offer a fix for those who may encounter the above error. I have nearly 20 years experience with Access, and I never encountered the error until today. It just seemed to materialize out of nowhere but it occurred with every event procedure on one form. After troubleshooting...

Actually, I think I got it. I believe IIf(Weekday(Date())=7 And (Format(Date()+1,"d")=1 Or Format(Date()+2,"d")=1),True,IIf(Weekday(Date())<>1 And Format(Date()+1,"d")=1,True,False)) will return True or False on the desired days.

I have an operation that I'd like to carry out on user login on the last weekday or Saturday before the end of the month. Assume the 1st is on Sunday or Monday, the expression would evaluate as true on Saturday, and if the 1st is on, say, Tuesday, then it would evaluate as true on Monday. I...

Thank you, Duane. Your simple and obvious solution solved the problem for me! It's amazing how something so obvious can be unseen, and then it's like, "OF COURSE!" when someone points it out. I appreciate the help.

I haven't written the logic to create the list of potential recipients. That's what I'm struggling with. What I'll do when I have the results I need is to use that query as the Record Source for a form. I don't need assistance with the actual emailing logic. It's written and works fine. I...

I'm satisfied with any random contact. Eventually all will be contacted, but I don't have any preference as to which is first, etc.