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 Shaun E 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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