Search results for query: *

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.

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

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

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.

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

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

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

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

Thaat worked. Thanks for the help MooseMan. Dan

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