Search results

Closed Figured it out. Need to use SendObject() So to have it automatically send without asking you, i think you need to use the above method with ClickYes. To have a message prepped for you to manually send, you need to use SendObject(). Does anybody know any other advantages/disadvantages...

I have looked at a few different threads regarding auto sending reports using e-mail. I have found a method that works, through the use of ClickYes. It basically uses 3 functions, one to resume ClickYes, one to create and auto send an e-mail to specified people with a report attached, and one...

Got It! Okay got it! I had to figure out the whole Alias thing. So in summary: I made a new query and I based that off of my original query (qryRejectDetailsByShift) from my first post. Then right click on the qryRejectDetailsByShift while it's in the upper pane then Properties. I...

Possible Solution: Subquery? I think I found another possible way to do this. I found this on the MS support site. How to Compare a Field to Field in Prior Record. I took this idea and added an additional statement to the Where clause. So, based on this, here is what I did. I made a new...

I'm working on a database used for tracking production. Currently, I have a query based off of multiple tables that looks like this: Product__Date_____Shift___Throughput_Rejects A...........12/4/06.....1.........1500...........5 A...........12/4/06.....2.........3500...........22...

Re-Explained. ^^ Sorry, I think maybe I didn't fully explain the problem. Here is an example of something I would need to figure out. What is the yield of of product A on Shift 3 on 12/4/06? Yield = (Throughput - Rejects) / Throughput If I simply took (Throughput - Rejects) /...

I'm working on a database used for tracking production. Currently, I have a query based off of multiple tables that looks like this: Product__Date_____Shift___Throughput_Rejects A...........12/4/06.....1.........1500...........5 A...........12/4/06.....2.........3500...........22...