Recent content by crich21

Yes it does work using this method. That was my first thought. So, I believe it has something to do with what @Gasman was saying about PDF Complete taking over the creation of the PDF. However since its not opening the app, it fails. I will try and figure out if PDF Complete can be...

After reading all the replies. All PC are windows 10 with the latest updates using Office 365. Yes the default pdf app is different on the one pc. I understand that access creates its own pdf. All my reports worked fine on the affected PC up until recently, with no changes to the database at...

I have used this line of code for several years to output PDF reports. I output multilple reports with this same method and it works on all but 1 PC. I have one pc that has the PDF Complete app installed as there primary pdf viewer. This is the only PC where this code fails. Has anyone...

I had to comment out the code that clears and repopulates the tables, since those queries need the frmOrder to be open. I did leave all the queries associated with this form in case that helps narrow down my pitfalls. Thanks to everyone chiming in. I'm ready to learn a better way. I am now...

It is a single access backend file located on our server. I am not using sql server. I went thru all tables and it appears I was missing a few indexes. I will be able to make a blank database on Monday and post it. Lots of good advice here. I’m self taught so when I learn knew things I try and...

I did not write the sql. Access query design did that for me. I was able to remove all the group by and having from the sql and it still works as expected. I only have 1 backend file and it is just in a directory on our file server wihich is running windows server 2019. Not sure if there’s...

After compacting and zipping the file is 11mb and it says it’s too big. Yes I am using a make temp table query. So if it doesn’t automatically index then I need to figure out how to add indexes. So I can retest it.

I have not learned enough to fully comprehend every ones replies. I will look up the different things mentioned here and try and understand. I am not sure why the query turned out the way it did. I kept making changes until I got the desired results. Does the temp table have indexes on it...

I have stripped everything I can and this site says its too large to post. Am I allowed to post a link to my dropbox for the file? It's complex and I will say I have achieved alot of what this db has become with the help of this forum. I don't fully understand sql so I use the access query...

I am using a split access database where the backend resides on our server. I have purchased sql server. However, I have tried to convert from access to sql and i run into several errors. It's beyond my knowledge.

I have a form with that has 3 listboxes on it. Each listbox displays a list of items that are missing on an order. lstBox1 displays missing items that are standard on a particular model lstBox2 displays missing items that are standard on a particular conversion lstBox3 displays missing items...

Appears newest release a few days ago, its still an issue.

Awesome. Thank you all. I was only looking back a few days for updates. I was able to rollback the update and fix this issue for now. Now I have to notify all workers to turn off automatic updates, until I can test the "open dummy report" mentioned in the link posted by cheekybuddha.

I will check the additional items u suggested. I already monitored the memory and it stays around 65mb when I click on a button to create a pdf. I have multiple forms with these create pdf buttons and they all have this error since this morning. I have also Increased page file size from 9500 to...

There wasn’t any updates. Windows or otherwise. I’ve already copied new front end. Also tried all the above mentioned.