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: *

  1. luccas

    Show the total value of records being entered on a fform.

    I,ve tried the DSum function in the contyol properties - data control source, =DSum([FoodTotal]).I can,t enter it I get the message "The expression you entered has a function containing the wrong number of arguments".
  2. luccas

    Show the total value of records being entered on a fform.

    I am entering daily sales into a table named tblSales with fields SalesCounter, Date, Shift, FoodSales, Tax and PayType. I am loading this table from a form, frmDailySales, with two sub forms, frmDailySalesLunch and frmDailySalesDinner. Forms frmDailySalesLunch and frmDailySalesDinner - both...
  3. luccas

    And Or statement, is there a limit to the number of "Or" in a query?

    I need the ‘Like’ it is the only way I’ve tried that gives the correct result. This in clause is in a query grid - an example of how to concat quotesin the in clause would help. You are correct, the reason Or is being used is because the user could use any combination of text boxes. geodelb
  4. luccas

    And Or statement, is there a limit to the number of "Or" in a query?

    jsteph, I need the ‘Like’ it is the only way I’ve tried that gives the correct result. This in clause is in a query grid - an example of how to concat quotesin the in clause would help. You are correct, the reason Or is being used is because the user could use any combination of text boxes...
  5. luccas

    And Or statement, is there a limit to the number of "Or" in a query?

    I am attempting to make a query for 10 text boxes. I have tried to enter it in the Zoom Box and I,ve entered it row by row in the query. Every time it gets cut short after being saved. How do I accomplish this? Example of saved version (Incomplete) Like "*" &...
  6. luccas

    Access 2000 Converting to Access 97

    Is there an easy way to convert an Access 2000 Application to an Access 97 Application?
  7. luccas

    Alignment test on Labels

    I would like the Labels to be the a sample of the first ones, maybe 5, that are going to be printed.
  8. luccas

    Alignment test on Labels

    I want to be able to run a printer alignment test by clicking a button. I need to limit the number of labels printed in order to test printer alignment. How can this be accomplished?
  9. luccas

    Open A Dialog Form from a Report

    I want to use one "Dialog Form" to do several "Reports". I thought it would work this way but I can't Get the "Dialog Form" to stop to fill it out. I can see it opening then the "Report" opens immediately I just need a way to stop it to fill it out...
  10. luccas

    Open A Dialog Form from a Report

    I am trying to open a Dialog Form that populates a Report. I open the Report to start the Dialog Form. The problem I have is the Dialog Form opens then the report comes up before the dialog form can be can be filled out. I have the code in the report “open event”. This is the Code I am...
  11. luccas

    Add a value to null text boxes on a form

    I have a form that I am using to run a query. The query name “qryUCQuery” the form name is “frmSelection” it has 2 text boxes on it ,Text0 and Text2. I am using “frmSelection” to specify the values for “qryUCQuery”. The criteria for the query is “Like "*" &...
  12. luccas

    Using a form to specify a query

    You are right the nulls in the query are handled with this Not Is Null. I don't think I've been clear on the problem I am having. I am using frmSelection to select the Category field on the Query. I have 2 selection choices on frmSelection , if I make both selections everything works. If I Make...
  13. luccas

    Using a form to specify a query

    I tried your suggestion Like "*" & [Forms]![frmSelection]![Text0] & "*" And Not Is Null and if I have a null value in my selection form I get all records. Doesn't seem to effect it.
  14. luccas

    Using a form to specify a query

    I tried this: Like "*" & [Forms]![frmSelection]![Text0] This doesn't handle the nulls and doesn't show the fields with right hand wild cards.
  15. luccas

    Using a form to specify a query

    I found one problem - if I have null values in my selection form -frmSelection -it shows all recordss. How can I handle null values to give no records?
  16. luccas

    Using a form to specify a query

    Thanks this is what i needed . It works great!
  17. luccas

    Using a form to specify a query

    I achieve the desired result if a put: Like "*1*" or Like "*FGR*" directly into the Query. But when I refer to the Query from my Form- [Forms]![frmSelection]![Text0] I can't find anything to give the same result.
  18. luccas

    Using a form to specify a query

    I have a query with a field called Category with text records, one record example: "3 4 SW SRV CCR GR FAF FCO FCR SCR FGR". This example shows 11 categories. I want to use a form to specify up to 10 criteria for this Query. The output will be used to make mailing labels. any help much...
  19. luccas

    Activate a textbox backcolor from another textboxes value

    Thanks - Placing the code in the OnPrint event was the key.
  20. luccas

    Hilite a 0 value record in a report.

    I have a report where I want to activate a textboxes color when the value of another text box = 0. Example: I have a parts list when the value of [parts ordered]-[Parts recieved] = 0. I want a textbox that I have placed over the that record to hilite a color.

Part and Inventory Search

Back
Top