Search results for query: *

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.

I have a database that has many contacts from many companies. One company has 145 contacts in it, others have 1-5, some others up to 40. I am emailing them in small groups and I want to only email one person from each company with each mailing. As a contact receives an email a Sent checkbox...

Thank you very much. It is quite similar to the code I wound up using. As this code does, I wound up using the OutputTo command to turn the report into a .pdf at a known location on the hard drive, and then I attached the report and the other document that I was trying to add using Outlook...

Thanks. I tried the format property as well, but with quotation marks and got a field populated as "m/d". I too was assuming that the list was limited to pull-down choices. Sorry if I misunderstood, Andy. It's a cool solution, and I went back and removed the code. Simpler is always better...

Andy, the difference is that each time I return to the field I see only day and date. The year is in the table but is ignored in the display. I'll create a report that will display all of the upcoming expiration dates, so that isn't an issue. I just wanted to only see something like 12/25 on...

Simple, but works like a charm! I knew what it needed, but didn't know the right place to put it. Thanks so much for your help.