Recent content by razchip

In your group settings, is the year group set to Newest to oldest. Thanks for the help. Greg

Thank you, I ran them both, and each one worked. Made my day a lot better. Thanks for the help. Greg

I just can't seem to find the answer that should be fairly easy. I have a date in one Production table and I need to find out which period it falls in from my Accounting period table. An example from the production table would be 2/23/2017 and I need to select the proper period from the...

You could add a text box to a form named StartDate, the second text box named EndDate. Populate these with the desired dates, then set your query criteria to look for the loaded dates. Between [Form]![Startdate] and [Form]![EndDate]. Thanks for the help. Greg

Skip, You're right, this will make it much easier and will only take a few minutes to set up. Thanks. Thanks for the help. Greg

The data is generated from a recipe software as a csv file. Thanks for the help. Greg

I've been trying to figure out how to insert missing data in a table. Another software produces the data, it contains the recipe and the ingredients, it doesn't replicate the recipe number for each row, so if I try to do some special sorts, I lose the connection. Below is an example: Recipe...

This may also be caused by having the compact set to run each time and the compacting is not being completed. Thanks for the help. Greg

Do you have some type of labor gathering system along with the machines PLC program. Seems that a company trying to gather this type of information would also have a labor tracking device that would link to the PLC. Thanks for the help. Greg

Thanks dhookom, I pulled this in last night and found where I was making the error. I was not opening the recordset properly. When I used your code everything worked fine. I really appreciate the help. I've learned a couple of things, so I'm walking away happy, thanks again. Thanks for the...

What is the name of the query your report is based on? 5MgrApproval What is the SQL View of the query your report is based on? qryReportsTo - this lists each manager, no duplicates SELECT ReportsTo.[Reports-To], ReportsTo.EmailAddress, ReportsTo.EmpNo, ReportsTo.ReportName FROM ReportsTo...

I was unable to get a result using the code. Maybe I gave up to soon, but it's so frustrating (20+ hours), it continued to give me all the records. So I made some queries to get the SQL results. I hope I can loop through the query to generate the report . Thanks for the help. Greg

Sorry for the late response, I've been working on this ever since and have not been able to get this or any other code to cycle through properly. I'm trying to use a query now, so I changed the code, but still can't get it to cycle through the query; all records are returned (tired opening the...

dhookom, I don't have any real background with the querydef function, I tried doing what you asked, but I think I'm still out in left field somewhere. tblMgrApproval is where the data is located (reportsto is a text field). 5MgrAppv is the query the report draws from. strSQL = "SELECT * FROM...

In a report, can I loop through a table to pick the parameter. I can't seem to hit the right combination to have the report only show me the "ReportsTo" from the tbl ReportsTo2 for that individual, it continually shows me all results; or do I have to look at this another way. Private Sub...