Search results

So.....I added an unbound textbox called txtCoilNumber and modified and added this code to frmInspectMill: Private Sub txtCoilNumber_AfterUpdate() Dim tempCoilNo As String 'new coil number check If Len(Me.txtCoilNumber & "") = 0 Then MsgBox "You must...

Probably because I am thick-headed and don't really know what I am doing. :-) Thus multiple posts......... :-) I believe this keeps coming up because one - anyone - would assume that a table for coils would be an inventory-type table where coils are entered when they are received but that is...

just to clarify - - -No, I do not add a new record for this Coil - directly into tblInspectionEvent. The coil is added to tblInspectMill which could be metaphorically thought of as "sub-table" of tblInspectionEvent along with all of the other types of inspections. an example of why this is so...

Yes. very well. Thank you. No. The coil number ID needs to be added to tblInspectMill because that is where all of the specific and unique data is recorded for unique and specific mill inspections. tblInspectionEvent is only an umbrella table for recording Date, JobNumber (which houses a host...

:-) I WISH I was currently in quarantine. Not to sidebar or derail but the company just released a company wide email giving guidance that may allow for it - - but I can post about THAT in the dedicated corner of the forum. :-)

Exactly - the most important thing. Yep. If you are wondering about the OnLoad event of frmInspectMill (this code): Private Sub Form_Load() Dim rs As DAO.Recordset If Not Trim(Me.OpenArgs & " ") = "" Then 'See if record exists Set rs = Me.Recordset 'MsgBox Me.OpenArgs...

Hi JDraw and Micron - A rare Saturday for me to be at work - - - - and I am really grateful for your input because it's going to be a long ten hour Saturday. :-) - meaning lots of time to work on this. I'm going to work through your guidance. One question before I start: the textbox you added...

It is generated by the purchasing department when the coil is ordered from a supplier. The purchasing department creates a coil tag to be placed on the physical coil when it is received. The coil number is stored - at this point - in the company's large ERP system - -which again - is in no way...

So in a nutshell - tblCoils stores data regarding steel supplier, coating supplier (if coated), perforated or not, etc. etc. The idea is that over time we can run a report on "paint scratches" for instance (which we record during inspections) and by linking to tblCoils ascertain whether paint...

I'd be happy too. The front end of our inspection db is going to ultimately reside on a rugged tablet so that we can spend more time on the floor and less time at our desks. Which means that we're walking from one mill to the next and there is no book anywhere on the floor that lists all of the...

HI JDraw - Just so you know - I have made great use of the info from that link you've sent before! Thanks - That is exactly how I have had the control in question setup. And it works great - for me - but the other guys found it confusing because they'll be in the middle of a new inspection and...

Thanks!

Are you able to easily point me to any kind of example of this condition? That's funny! We don't like small coils either because we have to setup more often and usually waste the first two hundred feet of the head of the coil.

How do I get started with this approach? I have cbo in the header of frmCoilStatus (which is also the "Add New Coil" form) with this code on its AfterUpdate event: Private Sub cboMoveTo_AfterUpdate() Dim rs As DAO.Recordset If Not IsNull(Me.cboMoveTo) Then 'Save before move...

Like I said - the only reason I did it was to take advantage of the "Not In List" property that triggers an "Add New Coil" form....and yeah....I can see the "danger" of existing records inadvertently getting changed. Recognizing it is a bad idea. Not a terrible tradeoff at all. If I went...

Hi Uncle Gizmo - I like your idea - - too big of a fish to fry - -and that type pf data (usage, expiration, partial or not) is already recorded in a separate database by our purchasing department. There won't be any linking to them. Inventory questions are nowhere near my scope. Characteristics...

Tried it but the cbo still shows a record - - - no other control does.

Hi All - After reading through all of your posts I've gone back and done some discovery and tried some different mockups including starting a new form from scratch. When I created the new form I simply selected tblInspectMill and clicked the "Form" icon on the "Create" menu. Then I changed the...

Hi all - I have a data entry form (frmInspectMill) with a combo box (cboCoilToUse) on it whose row source is a simple query that is bound to tblCoils. The SQL is: SELECT tblCoils.CoilNumber_PK, tblCoils.CoilNumber FROM tblCoils; The idea is that the user opens this form to enter various...

:-) Only thing is I argue with myself a lot! Be well all