Recent content by CJSSC

Not filtering at all and I am not seeing the expected <OK> or <Cancel> associated with acDialog (basically it hangs up everything). So I tried to create a parameter query to do the table relating for data entry. All three underlying tables have been populated under the same primary key field...

Definition of Open? Combo Box can be invisible until an On Key Down event (such as the Down Arrow being depressed) which changes the combo box .Visible property to True. Am I on target here? Cj

Well, that didn't work either. I know that the best way to have handled this would be a subform ( utilizing the LinkMaster/Child) but the required data entry fields on the MainForm prohibited it (too many) and the popups are almost as large. All underlying tables are related by the SystemID, so...

The Data Enable property jfischeer is referring to is accessed by opening your form in Design view and right clicking OUTSIDE the section (in the gray area...you may need to use the scroll bars down or to the right to get to the edge of your form), then selct properties. Check the Title Bar of...

Intermediate Window was showing zero response from the debug statement until I noticed the misspell of strCritera. Once fixed, the intermediate window is showing the correct SystemID from the MainForm but the SystemID field is still blank on frmC1ProcessGasBox. Checked Relationship as one-to-one...

OK, that's the database window (design master). Go to the Tools/Startup... menu item and select your form (by name) to open when the database is opened. Also (on the same Startup dialog box), deselect the database window opening at startup. You can still access the database window under the...

1. How are opening your form: command button, db startup, etc.? 2. Define &quot;design master&quot;...what's opening on top of your form? Cj

Still no joy! Here's the current code for the command button on the Main Form to bring up the popup form: Private Sub btnC1ProcessGasBoxSubform_Click() Dim strCriteria As String strCriteria = &quot;[SystemID] = &quot; & Me!SystemID Debug.Print &quot;strCriteria: &quot; & strCritera...

Dan, Here's the code I copied into the On_Click event for the command button to open the popup form: Private Sub btnC1ProcessGasBoxSubform_Click() Dim strCriteria As String strCriteria = &quot;[SystemID] = &quot; & Me!SystemID DoCmd.OpenForm &quot;frmC1ProcessGasBox&quot;, , , strCriteria, ...

I want to open a popup form with the same unique ID (not an autonumber function). I've tried Forms!MainForm!UniqueID=Me!UniqueID in the On_Click to open the popup (Command Button on Main Form), the On_Load for the popup form, etc. with zero results. TIA, Cj

Problem solved...the part number field (Part1Number, etc.) cannot be blank (or null) if it is tied to another field such as Description from another table. I added NA for blank part numbers and everything's working great. Thanks, Ken!

How, if each part number is unique?

Only data unique to each record is being captured in the PartRequest table: ID# Date System# Requestor Part1Number Part1Qty Part1Status Part1Issued etc up to Part10 Am I violating normalisation? Cj

I'm trying to comply with &quot;normalization&quot; rules by not capturing the descriptions in table PartRequest since it is already contained in tblNovellusBOM. The two tables are related by the PartNumber to Part#Number field. If a particular part request (for a specific system...

You got it: SELECT PartRequest.*, [tblNovellusBOM].[Description], tblNovellusBOM_1.Description, tblNovellusBOM_2.Description, tblNovellusBOM_3.Description, tblNovellusBOM_4.Description, tblNovellusBOM_5.Description, tblNovellusBOM_6.Description, tblNovellusBOM_7.Description...