Search results for query: *

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

I am trying to read a table in access2013 and export it to a spreadsheet in excel2013. I am actually naming the spreadsheet using a value in one of the tables fields. It works well except when I try to open the spreadsheet it gives me the error: "excel cannot open the file...

you're right my apologies. Frankly I was not able to get the delete to work exactly how I wanted it to. Is what I ended up doing is defining another field in the table, that line got written to there then delete that record from the table. Overall is what I am doing is I am importing a series...

Thank you all so much I think I have it now. As I typically do when I have an issue I get a lot of help with I will send a small donation to TekTips Cretin

ok the following is the row I need to delete Insert new line above this line only. Please perform insert first than copy paste existing line and modify. Cretin

I changed it back and it is doing the same thing it skips the line that deletes .Workbooks.Open FileName:=strpath & strfile Do While binkeepgoing If InStr(UCase(.Range("A" & L).Value), "Project") > 0 Then .Rows(L & ":" & L + 5).Delete binkeepgoing = False End If L = L...