Search results

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"...

Hi All, I''ve been on a mini vacation. Thanks for all the replies. I have the code in a module and call it in before update on both forms. The form and subform both work separately but not together.

GM Using Access 2010. I am using the following code to audit a form in my database which works fine: Sub AuditChanges(IDField As String, UserAction As String) On Error GoTo AuditChanges_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim ctl As Control Dim...

Thank you Arnelgp for your response. Your code works exactly the way I wanted. Thanks so much!

Ok. The Function in the db allows for the number of business days between two dates. Private Sub cmdCalculate_Click() Dim dteStart As Date Dim dteEnd As Date If Not IsDate(Me.txtStart) Then MsgBox "Please enter a start date", vbOKOnly, "error" Me.txtStart.SetFocus...

Sorry; I'm not following you. If the date field contains 1/12/2016; the business day for that month would be 8. This is counting from the 1st of the month only Monday - Friday. Exclude weekends.