Search results

  1. E

    Form not cooperating

    Ooops,...cut off some of the event procedure: Private Sub Form_Load() 'sets the list for the first Combobox Me.Combo142.RowSource = "SELECT [CCode].[CCode] " & " FROM CCode ORDER BY CCode;" Me.Combo142.Requery End Sub __________________________________________ Private Sub...
  2. E

    Form not cooperating

    The tables "CCAH" and "CType" contain the codes for CType. The filter for the list box should be based on the selections made for CCode/PGCode/PDCode to give me a shortened list of CID's from the table "MasterCID". Here are the event settings for CCode: 'sets the list for the first Combobox...
  3. E

    Form not cooperating

    Option Button --> CType two tables for CType Then PGCode --> and PDCode --> to show results for CID in the "Last CID" ListBox.
  4. E

    Form not cooperating

    Just one form in the dB I forwarded.
  5. E

    Form not cooperating

    I gave them the choice of getting help or scrapping the project. They chose to move forward.
  6. E

    Form not cooperating

    Here you go....
  7. E

    Form not cooperating

    Just had a meting to set up a dummy version of the dB. Let me get it ready and I will forward it to you once I am done.
  8. E

    Form not cooperating

    My company doesn't allow me to share.
  9. E

    New Member

    I just joined this week to get help with an issue I am having on the dB I created. I am a contractor, as a Data Analyst/Business Analyst. Usually use Oracle or MySQL, but have experience with Access (slightly rusty). The response I have received in providing assistance to me has been...
  10. E

    Form not cooperating

    Would DLOOKUP work for me?
  11. E

    Dlookup - Using two form fields (number & drop down text) to query table for data

    I'm searching for a similar solution except that I have 3 Combo boxes (independentof each other, not cascading) for the user to select from on the form. I want that to be, essentially, the filter for a list box on the Form showing the ID associated with the 3 Combo boxes combination. Any...
  12. E

    Form not cooperating

    CType (also part of the event procedure: SELECT [CCode].[CCode] FROM CCode ORDER BY CCode; CCode CType: SampleData= ABCB BLOM CLOM DPOM YYMM _______________________________________ CCAH CType: SampleData= 1505 1504 1503 1502 1501 1412 etc. _________________________________ PGCode Combo Box...
  13. E

    Form not cooperating

    burrina: I'm not sure I follow...Which Combo box should I attach this code?
  14. E

    Form not cooperating

    Combo142 is not what it is actually called. I de-identified my fields at the request of my manager.
  15. E

    Form not cooperating

    CID table: ID (AutoNumber, PK) CID (UNIQUE) RID Frequency CType (CCode) PGCode PGCodeID PDCode PDCodeID CIDNo CreateDate (=Date()) EmployeeID EmployeeName Combo142 can be one of two tables Auto and CCAH, which are the CType ID CID RID Frequency Type CType PGCode PDCodeID PDCode...
  16. E

    Form not cooperating

    I have attached the text file as requested. I can't thank you enough for helping me out.
  17. E

    Form not cooperating

    Option one sounds best. Thanks
  18. E

    Form not cooperating

    "I still don't completely follow. Can you give the hierarchy of your combo boxes and listbox. Does the user select an item from the listbox, which then filters Combo1, and Combo1 filters Combo2 etc? Or Does the user select an item from Combo1, which filters Combo2 etc, which then filters the...
  19. E

    Form not cooperating

    The list box is where I want the result to be displayed. There is a main table (MasterCID) that uses the form [CID Gen] to add a record to the table. Prior to adding the record to the table the end user will filter CID in a List Box (LastCID) to show which CID's have been used already. Each...
  20. E

    Form not cooperating

    I agree, progress is being made and I am hopeful (determined) to get this to work. I was not offended in any way by the Color/Bold of the font. trust me, I am frustrated too (lol). Thanks for the encouragement. I sent a screen shot of the DesignView of the form, in the chance that may help...
Back
Top Bottom