Search results

  1. V

    VBA Search

    "SELECT [tblESTIMATE ].[YourFieldName] FROM [tblESTIMATE ] GROUP BY [tblESTIMATE ].[YourFieldName] ORDER BY [tblESTIMATE ].[YourFieldName]" This will give you your unique values in ascending order.
  2. V

    multi field search criteria problem

    By the way, I am missing a close parethesis on the end of the previous expression.
  3. V

    multi field search criteria problem

    Create 3 new fields in your query. The first one checks the value of textbox1 and ignores it if it is null. In the FIELD box of the query, type: IIF(isnull([Forms]![frmDataSearch]![textbox1]),-1,[strname] Like *&[Forms]![frmDataSearch]![textbox1]&* When you hit ENTER, Access will place a...
  4. V

    Query criteria based on textbox

    Sorry, there's a correction to the statement IIf(IsNull([Forms]![Form1]![TextBox1]),-1,[YOURFIELDNAME]=[forms]![form1]![Textbox1])
  5. V

    Query criteria based on textbox

    1. Replace your field name in your query with the following statement. IIf(IsNull([Forms]![Form1]![TextBox1]),-1,[forms]![form1]![Textbox1]) 2. Place the number "-1" (quotes not included) in the criteria section. It may seem strange, but it works!
  6. V

    Min/Maxing forms thru other forms

    I would assume that you want to open (or switch to) a report or form, and maximize it. Just enter the code: DoCmd.Maximize on the OnActivate event of the form or report that you want maximized.
View older results
Back
Top Bottom