Search results

Hi Doc. I am following you - but I am also quite inexperienced with creating SQL JOINS. Please bear with me. I believe you are saying that I create the join in SQL and it is not the case that I need to literally define a relationship between the Personnel table and the line stop table. I'm...

Hi again JDraw. Here is the SQL I've been trying to make work. SELECT tblinspectionevent.datetime, [jobnumber] & [task] & [resource] AS JobName, tblfinalproducts.finalproducttype, tblinspectionevent.inspector_fk, tblinspectionevent.operator_fk...

I have worked this out - with pencil and paper - many times. Model is definitely that "line is stopped for reason A or B.., then Q happens." Yesterday provides the perfect example of the two - and only two - possible scenarios. I stopped a production line twice for two different reasons...

Hi again All - The business rule is that yes - at the end of the day - one and only one person makes the decision. OK.....so here goes.... (please see the attached screenshot) We roll painted steel through rolling mills. Most of the time everything goes great but when it doesn't go well...

Hi All - I've attached a little test db. I'm trying to wrap my head around subqueries to help with creating reports. I have a table named tblDecisions that would typically have a form to record instances of decisions being made and who made them. The thing is I have a single table for all...

Yep.....especially since my actual job has nothing to do with programming! :-) Thank You - Tim

Hi JDraw - Your advice is well received and I've learned a lot this morning working through my code with your advice. And I cannot find the culprit. :) so................ I'm just going to leave it the way I had it before that worked. Before, when I typed in a CoilNumber that was "Not In...

I know. I’m sure that’s an issue. Our real coil numbers are alphanumeric - thus strings.i believe I mentioned in an earlier post above that the PK for tblCoils is autonumber and there is another field where the actual alphanumeric coil number is stored. Is there a way to resolve this? thanks! Tim

I found the culprit. I have two screens at work that work on. frmChooseComponent was opening on the second screen. And frmChooseComponent is Modal. If you don't have second screen you would see nothing but hear the Access beep. Try this - - I am so grateful for your patience. Tim

Merde........I should just post the entire db.........Taking parts out of it is..............I'm sorry. I closed it and re-opened it here after cleaning up and it works just fine and there is something I am forgetting about posting zipped dbs to this site. Did a compact/repair before zipping...

I got the same. Should be fixed now.

Here it is....and I saved it to the main computer screen instead of the big screen I work on - which I had forgotten to do which I also forgot s an issue when opening it elsewhere.

Actully - don't. Need to figure out issue.

That's a reference to a linked database at another plant that didn't strip while I was stripping the db down fo this post. Sorry about that. I'll try again.

I can't explain why there appear to be no Option Explicits in many of the form modules. Adding now - but I doubt that will make a difference to my bigger question. But thank you very much for pointing that out.

I never observed any "undefined messages." I did a compact/repair before compressing the db to post. Did I forget anything maitenance -wise before posting - just out of curiosity?

Hi DBGuy! I've attached the stripped down version of the db. It will open to a "Main Menu." Click the "Inspections" button. When the Inspections form opens up, fill in the 4 required fields (it was going to be a pain to avoid this and still get to my question). It doesn't matter what you choose...

Hi All - My database is about doing inspections of assembled pieces from formed coils of steel. It might take many coils of steel to complete a job. OR it might only take a partial coil - which is more likely the case - which necessarily means that the same coil could come up in many...

Hi DB - yeah - exactly. I think i'm going to have to create a table called InspectionDetails to house data like this. Then - pass Inspection_ID (from the first form) to the second optional form via OpenArgs which would then associate an Inspection_ID number with an InspectionDetail_ID. Haven't...

Hi All - I have a form where I record inspection data. One of the bound controls is a combo box with several options in it. In most cases, the user would make a selection in the cbo and when the form is closed the chosen value will be stored in the underlying table. There is one potential...