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!

Recent content by HisEnergy

  1. HisEnergy

    Search Code for my Form Filter doesn't Seem to Work?

    Thanks AceMan1 Do you have any code that shows a a combo box with text values to pass to the form filter of the Subform. I can get just plain Text Fields to pass values and query records. For some reason I must not be setting the combo box up correctly. I can't get any records returned when I...
  2. HisEnergy

    Search Code for my Form Filter doesn't Seem to Work?

    Can someone help me on this code. When I click Submit it pulls all records into my Subform. It doesn't seem to see the value I select from my combox on my main form. Thanks for you help! Private Sub FindSearch_Click() Dim strWhere As String strWhere = "1=1"...
  3. HisEnergy

    Calculation Field in Table - Need Help

    I have a Contact file with Last Name and First Name Field in them. I would like another field that will concantenate these two in a third field automatically I will call Full Name. Having trouble setting up the Full Name field. I sure this is a Calculation. How do I set this up? Thanks
  4. HisEnergy

    Form/Subform - Search Application - Subform Immediately Clears

    Crowley16 I tried this and it doesn't work. Here is the VB Code for my Event Procedure for my Search Control Buttom. Any Ideas? Private Sub Search_Click() Dim strWhere As String Dim strError As String strWhere = "1=1" ' If Last Name If Nz(Me.LastNameTest) <> "" Then...
  5. HisEnergy

    Form/Subform - Search Application - Subform Immediately Clears

    I have a Main Form with unbound controls such as LastName, FirstName, City, State,... That I use to input my serach criteria. On the Main Form is a Control Button Called "Search". When I select "Search" with no Criteria in the unbound controls, I get a list of all records in the file in the...
See more

Part and Inventory Search

Back
Top