Recent content by Cretin

Thank you for your help everyone I talked to the users and developer that was only for documentation purposes which I have other ways to document it, thank you. Cretin

gmmastros commenting the select folder out won't work I guess we need to use that. Olaf, I am actually executing the SQL in a job scheduler but it may invoke SQL server manager behind the scenes to run the SQL. I am not absolutely sure why we need to select that folder prior to running as you...

I have a query it goes something like the following: Select 'test folder' select * from table. The result set will be like the following: 1 test folder 1 record1 2 record2 3 record3 4 record4 I then need to use a third party product called goanywhere to write the results to a spreadsheet...

Titles are no more than words weak people hide behind. Cretin

It is simple you use and if you want both conditions met and you use or if you want either condition met. Cretin

I did get the date range to work click on the link below Link Cretin

Thank you everyone you were quite helpful. Is what I did is put 2 text boxes on the form. The beginning date and ending date are entered into there. Then I run a macro which runs a query to export the data from the table to a spreadsheet with dates within the range. It then runs some code to...

ok I will try that. I have the records with various dates in the database. So I can just use a pop up form that I enter the beginning and ending dates in and that will generate the report capturing all the records between those dates? Cretin

what didn't work. Did the program just hang there?(that usually means the .bat is waiting for intervention) or did it just not work? Cretin

Below is the SQL view. Is it even possible to store the values from the having part of the statement in a table to be overwritten each time the parameter runs? SELECT TIME_SUMMARY_ARCHIVE.[PROJECT NAME], Sum(TIME_SUMMARY_ARCHIVE.[HRS THIS WEEK]) AS [SumOfHRS THIS WEEK]...

I have a form with a button that runs a macro that runs a parameter query with a begin date and end date. Is there any way to capture those values so I can use them in the name of the report I.E. report_startdate_enddate? Cretin

I think I have completed this successfully. My code is LSQL = "select Date from Time_Summary" 'SQL to retrieve date from the time summary table 'gets the date from the date field of the time summary table. Set strDate = db.OpenRecordset(LSQL) If strDate.EOF = False Then LGST = strDate("Date")...

yes same thing but I have another idea. Is what I am trying top do is generate a spreadsheet named with the date of the data such as weekly_report_20160730. I can get the data to a spreadsheet easily with a macro but had an issue using the macro to rename it so maybe instead of grabbing the...

I did try to open and repair the spreadsheet to no avail Cretin

I actually did it differently for supportability reasons we are not an access or VB shop so if I am not around my boss will have to fix it herself since it is for her which with my documentation she should. Is what I ended up doing is define a field in the table with that data. I already have a...