Search results

I'm hoping someone can help me finish this where Kn0wn1 left off?

I made the changes you stated and when I run the form, I get a debug error of Run-time error '13': Type Mismatch When I select "debug" there is yellow highlighting on the line for "Call addentry(varTime)" in the text block below. If cbEndDays.Value = True Then varTime = "End-Days" Call...

What do you mean by this? Not sure I follow.... I believe I understand your first part and am working on finishing the code based on you example. The part where you state "etc, etc". :)

Hmmm this looks interesting. How would I tie it into the form? The user typically clicks the forward VCR control to move off the current record (and thus saving it) and into a new, blank record How would a loop work? I'm not familiar with that.

I have a form where users enter production data at set times during the day. The set times for dayshift are: 6:30am, 8:30am, 10:30am, 12:30pm, 2:30pm and End-Days. The set times for nightshift are: 6:30pm, 8:30pm, 10:30pm, 12;30am, 2:30am, and End-Nights Both shifts work 12 hour shifts...

hmmmmm, I may have this figured out and running. Looks good so far. Also created a "grandtotal" using the same idea. A BIG THANK YOU to Privateer!!

Can you expound on what you mean with these two tasks? Not sure what you mean by foreign key and relating it back? Don't know what you mean by creating an alias for the week and year using the datepart function? I have an idea what you mean here but I don't want to guess with so many pieces...

I'll give this a try and let you know.

I am trying to create a query that will output only one line per product, giving Summed totals per product of LF Produced (tblProductionNumbers) and Manhours (tblManHours). The query would then divide LF Produced by Manhours for each product to give the value for "Productivity". Do I need...

I thought it might be easier to provide you a copy of my DB so you can see what I have going on. I'm a noobie so I'm sure that things are not as optimized as they could be. When you open the DB the main form will open up. On the left side is where the operator enters in their records. The...

Can I even use DSum with two tables? The part number is in tblProductList and the rest of the data is in tblProductionNumbers.

I also posted this in the forms section but it probably belongs here. I am trying to create a DSum formula (to use as a control source in a chart) in a query that will look at a particular set of records(based on a product type), and take the value of that record's waste number (a calculated...

I am trying to create a DSum formula (to use as a control source in a chart) in a query that will look at a particular set of records(based on a product type), and take the value of that record's waste number (a calculated number) and divide that by the value of that record's LF Run number...

I am using CR2008 I am creating a report for our salesmen and one of the fields in the report will be a text box that shows what the last month was. For instance, if the report is run this month, the report will plug July 2011 into the box because that was what last month was. Tied to this...

May not be relevant but try to open the file using the /decompile switch then use Alt/F11 to open the VBA editor and recompile. I have to do this to mine every now and then when I'm working heavily in developing. The batch file I created and placed on my desktop does all the work for me. Here...

Hello all; This is probably a dumb question but here goes..... I have a form called "frmProductionNumbers" with a subform called "frmSubformTabCtlProductivityWasteCharts" that resides on a tab control. I want to have the chart update it's values based on data in the currently displayed...

Looks like that is working splendidly. I'll have to plug it into the chart to see it working but I just checked manually and the math is coming out correct. I had been trying to create a calculated field using the expression builder in that same table with all the other numbers. I saw "that"...

Sorry but I'm still new to a lot of this. Where do I put that code?

A little more background may help. I have a chart, several really, that show about a dozen products listed along the "X" axis. On the "Y" axis is the waste percentage of each product through the manufacturing process. Workers enter records every two hours showing what product they made along...

I was hoping this post had an answer for me. Yes for what I'm doing the math is correct. You take 5 averages for example, add them together then divide by the number of records. In this case 5. This gives you an average of the percentages. What's so weird about that? I'm not trying to use...