Search results

I am having an issue trying to show all records when I load my form. It loads correctly when I don't have a record source for the main form. However, the combobox filters will not work. My goal is to have users be able to use the datasheet, subdatasheet and combobox filters. I can get the form...

namliam, I was just going through my old email and saw this thread. I decided to click on it for some reason and realized I never responded. I can't believe I did that. Anyways, Your suggestion works flawless! Thank you so much for helping me! I really appreciate it and hope you are still active...

Ok so I have a new problem. Your code worked great the first time, but now anytime I try to generate the Excel file the data won't transfer. The file name changes, but the data does not change. It is still the data from the first file I created. Any ideas what is causing this or what's missing...

Your idea worked awesome! I couldn't believe how much faster and more efficient it works! Thank you!!!

Thank you for your reply. I cheated on the excel sheet. I just transfer the data to a hidden worksheet, which populates the worksheet in my screenshot. "Eric" is the name range for the export. The frustrating thing is that with Code 1 the transferspreadsheet works fine as long as Excel is...

I appreciate you taking the time to help me with this. I tried your suggestion and it did take care of the "read only" problem. However, the problem I encountered was that the data was saved to the "PCF Form". The newly created PCF file was blank. So its writing to the Excel Form, but when it...

Here is the code for the mcrPCF: DoCmd.SetWarnings False DoCmd.TransferSpreadsheet acExport, 10, "qselPCF_Form", "G:\HC5D\Group Files\PCF\PCF Form.xlsx", False, "Eric" DoCmd.SetWarnings True Beep MsgBox "A new PCF has been created and saved in G:HC5\PCF\PCF Files"...

I have a database that my group at work uses. One of the features is after they enter data in Access they can press a button that will generate an Excel file to send to suppliers. The code worked fine for a while, but I began having issues. I have had two issues the first one was it wouldn't...

It worked like a champ!!!! Thank you so much for taking the time out of your day to help me. I appreciate it!! Thank you,

I am extremely new to writing code, but was able to successfully write code that transfers the data in my form to and excel spreadsheet template and saves it with a different name. The code works perfect and without issue as long as Excel is not running. However if Excel is already open the...