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: stru
  • Order by date
  1. stru

    Parameter Query returns blank results and correct results

    It is "Or Is Null" because there are 5 different criteria. So, the Vendor text box on the criteria form will often be empty. Is isn't saying pull Null Vendors.
  2. stru

    Parameter Query returns blank results and correct results

    Hi, I have a parameter query that works to a point. There are 5 parameters. My problem is that when I enter a parameter, say Vendor, the result not only pulls up all of the records that match that Vendor, but also any records where Vendor is blank. I believe these blank records are zero...
  3. stru

    Report with Multiple Criteria

    Hi, I have a report that is currently being generated based on 3 different selection criteria. I have created a form where the info is entered and passes the criteria along to the report. It works fine. I would like to add an additional 2 fields for criteria. The problem I am having is the...
  4. stru

    Save Sort Order

    There was a requery statement somwhere it shouldn't have been. I thought that I had checked all the code for one, but I hadn't. So, problem solved. Thanks for sterering me in the right direction Zameer.
  5. stru

    Save Sort Order

    I don't think the code with the detail button is the problem. Pretty standard, but here it is... Private Sub cmdClientDetail_Click() On Error GoTo Err_cmdClientDetail_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmClients" stLinkCriteria =...
  6. stru

    Save Sort Order

    Hi, I have a continuous form (Form A) which I am able to sort by clicking on the appropriate label. That is, if I wish to sort the form by last name, I click the last name label and it sorts by last name. If I click the first name label, it sorts by first name, etc. On each of the listed...
  7. stru

    Filter subform with combo boxes

    Hi, I'm trying to use 6 combo boxes to filter the records on an underlying subform. I want the results to be determined by cboBox1 AND cboBox2, etc. The problem that I encounter is how to still query the subform when there are multiple null values. I don't want the user to have to fill...
  8. stru

    Parameter query with Form

    Hi, I have a couple of text boxes that set a date range for a query underlying the continuous form I am working on. I got that working and everything was fine. Then I realized that I need to be able to query on additional criteria (a Job Number) as well. So I created a text box to enter a...
  9. stru

    Open a Form to a specific record on another form

    Thaat worked. Thanks for the help MooseMan. Dan
  10. stru

    Open a Form to a specific record on another form

    Hi, I have a command button that uses DoCmd.OpenForm to find a specifc related record for the form it is opening and then closes the old form. The problem is that when there is not related record, it either opens completely blank or wants to create a new record. I would like to add an If...

Part and Inventory Search

Back
Top