Search results for query: *

...underlying tables have been populated under the same primary key field ([SystemID]). Here's the SQL for the query: SELECT tblC1ConfigSystemAudit.*, tblC1ProcessGasBox.*, tblC1ConfigSystemAuditMissingParts.* FROM tblC1ProcessGasBox INNER JOIN (tblC1ConfigSystemAuditMissingParts INNER JOIN...

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 "design master"...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 = "[SystemID] = " & Me!SystemID Debug.Print "strCriteria: " & 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 = "[SystemID] = " & Me!SystemID DoCmd.OpenForm "frmC1ProcessGasBox", , , 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

...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 ID#...contained in the PartRequest.*) only has 5 parts, then Part6Number, Part7Number, etc. will be blank...

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...

I have a query that is filtering out records when no filters are applied. The underlying table "Zero Length & Required" properties are set to no for all of the text boxes and Memo boxes. I should be able to retrieve all records but I only get records with all fields filled. TIA, Cj

I understand the normalization issue but the issue of outputting the info (such as a report) can be mind-boggling. I know how to get the info out of the table (parameter query for a specific record or criteria), but how do you get the relational info (for this example, description) into the...

I'm using a combo box to autopopulate a form. That's working great (Thanks Paul Bricker), but the underlying table is not receiving this info. combobox has part numbers and descriptions from Master BOM table. System Configuration form needs part numbers and descriptions in the System Config...

Another source of this problem may be in the upgrade level of Office 2K & Win 2K Pro. Both have reference upgrades in the SR-1/SP-2 updates for Office & SP-3 for 2K Pro. FYI: Office 2K Pro is running M$ Jet 3.51 Cj

I think I understand what the original intent was but I'm lost as to why everyone's taking the long way: Private Sub btnSave/Exit_OnClick() DoCmd.Close acForm, "Volunteer",acSavePrompt DoCmd.'Whatever's Next' End Sub A Big Fan of "KISS" Cj