Search results

i get overflow error message when i try to use "db.QueryTimeout = 600000"

Ihave tried "db.QueryTimeout = 6000" but it times out after 60 seconds

I have this code in a module that keeps timeing out after 60 seconds is there a way to make it run for at least 10 minutes. Dim db As Database Dim strSQL As String Set db = CurrentDb strSQL = "INSERT INTO Daily_Trends_All SELECT Master.* FROM Master WHERE...

I tried Jons query, however since a sales rep is in the table many times each rep would be counted more then once. How would i find the number of individuals reps by month?

I have a table with salesdate[date], center[text], sales_rep[number], and sales[yes/no]. I need to find the number of sales_rep in each center by month who had yes sales Is there a way to make query that would group by month and center, and give a unique count of the sales_rep where sales is...

I have a form that I use to make csv file using vba code. Is there a way for me to zip the csv file using vba code or anyother way in the form. Thank you Nileshtx

when i tried to use TransferSpreadsheet it only worked to transfer data to an existing spreadsheet, but able to create new spreadsheet? please tell me how to create new spreadsheet

I there a way to exporl an results of an sql into excel spreadsheet and let the user pick the file name and location?

I need to create a form that shows data from a table in data sheettype of format. My problem is i need to find a way to let the user of the form pick which fields to group by, how many fields form the table to group with, and what order the fields should be grouped by.