Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CJSSC
  • Order by date
  1. CJSSC

    Open Popup Form w/Matching ID to Main Form

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

    Open Combo Box by Hitting the Down Arrow

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

    Open Popup Form w/Matching ID to Main Form

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

    Input Form

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

    Open Popup Form w/Matching ID to Main Form

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

    form hidden behind design master

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

    form hidden behind design master

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

    Open Popup Form w/Matching ID to Main Form

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

    Open Popup Form w/Matching ID to Main Form

    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, ...
  10. CJSSC

    Open Popup Form w/Matching ID to Main Form

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

    Query filters records on null fields

    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!
  12. CJSSC

    Query filters records on null fields

    How, if each part number is unique?
  13. CJSSC

    Query filters records on null fields

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

    Query filters records on null fields

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

    Query filters records on null fields

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

    Query filters records on null fields

    I have a query that is filtering out records when no filters are applied. The underlying table &quot;Zero Length & Required&quot; 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
  17. CJSSC

    ComboBox won't update underlying table

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

    ComboBox won't update underlying table

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

    =Date() Office 2K Doesn't work!?

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

    FormUnload interfering with Exit Button

    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, &quot;Volunteer&quot;,acSavePrompt DoCmd.'Whatever's Next' End Sub A Big Fan of &quot;KISS&quot; Cj

Part and Inventory Search

Back
Top