Recent content by slimjen1

Perfect...thanks so much for all your help!

Ok...Made the correction.... DoCmd.OutputTo acOutputQuery, qryname, acFormatXLS, theFilepath, True Compiles now. Thanks So, I still can't get arnelgp code to work. I have created the function and when I'm getting an error: sub or function not defined Pointing to Call fnkCreateFolder...

I'm getting an error: sub or function not defined Pointing to Call fnkCreateFolder (strFolder) I created the public function under modules...why is it erroring out?

Thanks...sorry about the code tags...thanks for all the suggestions..arnelgp; used your suggestion...worked ok...I'll take it. Anyone has any ideas why a folder can't be created as I indicated in post #4?

Thanks for responding...I tried using hyphens but the user says it can't tell the time from the date...I was trying to put the file in a folder to eliminate the use of time by adding "\Desktop\Exports" but I get an error "microsolf access can't save the output data to the file you've selected...

I apologize for the way the code presented but doing this from my cell phone

All..I'm trying to export a query with date: Private Sub cmdExport Dim qryname as String Dim theFilepath as String qryname= "qryExport" theFilepath = "C:\Users\" & Environ("UserName") & "\Desktop\" theFilePath = theFilePath & qryname & "_" & Format(Date, "yyyy-mm-dd") & ".xls" Docmd.OutputTo...

All, using access 2016...I have a report based on a query I need users to export to a folder on the desktop.The button is on the form. It runs but just places the field names in the columns with no data. Also On the left side there's the numbers 123 like its tring to group something. Here is...

Got it...Thanks for your help!!

All, using access 2016. I have one table with custid, state and order id.. some have the same cust id and state. I want only the records that have the same custid and same state. I keep getting everything. My query is the following select customerid, count(*)as st_count from...

The revisions worked. Didn't need the "End If" I will put this to the users then close this thread. Thanks again.

thanks so much! I'll try this and post back.

What can I change to make this work please?

February was just when it started and I was using it as an example of the problem. I guess since January was the beginning of the year it would have the correct business day except for the holidays which I'm also trying to correct with your modification in #13. But I get an error "overflow"...