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 Chriss Miller 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. PaveFE

    Need text box to display value from another

    No worries, I thank you for your help. I understand what you are saying, but this data believe it or not is not really for database use, they just want to be able to fill out this form on a computer and print it out (Hey, I'm just doing what the bosses want). I've taken classes on Access and...
  2. PaveFE

    Need text box to display value from another

    I found something that works. I inserted a text box on the form and put the following in the control source: =Iif([Expr6]>=0 And [Expr6]<10,"Low",Iif([Expr6]>=10 And [Expr6]<20,"Normal",Iif([Expr6]>=20 And [Expr6]<25,"Moderate",Iif([Expr6]>=25 And [Expr6]<32,"High",Iif([Expr6]>=32 And...
  3. PaveFE

    Need text box to display value from another

    I tried to find out where I could change it to "Noob" (although I'm not that far behind), but couldn't see where. I guess when I joined that seemed like the most logical choice. I am familiar with MS Access in a lot of ways, but I don't use it often enough to remember everything, so that's why I...
  4. PaveFE

    Need text box to display value from another

    Whoa, you lost me. Where would I go to write this VBA? The field in my query that has the total number is called "Expr6" I don't yet have anything built (i.e. text box) to display the text that I want to appear. Can you dumb this down for me? Sorry, and thanks. Vince
  5. PaveFE

    Need text box to display value from another

    Okay, one more. If I have a total number in one box, I want a formula that would put in text in another box that would be based on the number in the first box (i.e. First box = 0-9 second box would state "Low", 10-19 would state "normal", etc.) I'm thinking the equation would go in the query...
  6. PaveFE

    Need text box to display value from another

    Now I got it. Thanks for all the help.
  7. PaveFE

    Need text box to display value from another

    Currently I have all the data required in one table (ORM Worksheet). The table just has all the fields required for the entire form, but the fields are not named as different categories as I don't think I really need that (I could be wrong). The form I built is done using tab control to split it...
  8. PaveFE

    Need text box to display value from another

    Okay, after finally convinced my "handlers" that putting the calculated value in the table was a bad idea, they have agreed. But now I need to figure out how else to do it. Here's the scenario: I have a table that will be for aircrew to determine a risk factor for the flight. There are numerous...
  9. PaveFE

    Need text box to display value from another

    Hi, I have a table that has several fields that a number will be input into on the form (based on the table). However I need the last field to calculate a sum of the total input. For Example. Field1 = 1 Field2 = 3 Field3 = 1 Field4 = 5 (needs to calculate total of Fields 1 thru 3) or I can...
  10. PaveFE

    Calculating a total value

    Update! I got it to work by using the =[field1]+[field2}, I found out one of the field names was wrong and that's why I was getting the #Name?. However, now that it is working, I have another problem. Now that I'm able to get that box to add all the values, I now need to have another box to...
  11. PaveFE

    Calculating a total value

    A null is basically what you have when there's no data entry in a textbox. Nulls wreck havoc in calculations where 1 null textbox causes the entire formula to return NUll! Nz returns zero if the expression (textbox in this case) is NUll!" Gotcha, however, I think my original problem where I...
  12. PaveFE

    Calculating a total value

    how are ya PaveFE . . . You need to compensate for no data entry in any of the textboxes . . . CODE = Nz([Field1Name])+Nz([Field2Name])+Nz([Field3Name])+Nz([Field4Name])" What is the Nz for? Thanks, Vince
  13. PaveFE

    Calculating a total value

    Okay, here's more of what I got. I used the formula you stated above, but only used two field names, which worked somewhat. I put a 1 in the first field and a 1 in the second field. The last field has the formula, but it didn't add them up per say, it gave me a value of 11 vs. 2. I need the...
  14. PaveFE

    Calculating a total value

    Well, I did as you said, but it didn't work. When I switched to the Form view, here's what it showed in the fifth box: #Name? Not sure why it isn't working, any ideas? VAD
  15. PaveFE

    Calculating a total value

    Thanks, I'll give it a whirl. I figured it was something easy, but I just couldn't think of it. VAD
  16. PaveFE

    Calculating a total value

    Hi, I've looked to see if this was mentioned elsewhere, but had no luck. How do I calculate a sum for all values entered in a series of text boxes? For example (Aviation related): The form built from a table has say 4 fields where the user puts a value in each field, a number based on risk...
  17. PaveFE

    Using tables in Word

    Hi All, We have a word document that we are trying to emulate a form with. It was built using a table and we want to know if there is a way to make it so that when you type text on one line (row), instead of extending the table when you get to the end, we want it to keep going to the cell...
  18. PaveFE

    How to send report in an email via button

    Thanks
  19. PaveFE

    How to send report in an email via button

    Hi all, I have a database that where I want to have a clickable button (macro?) where upon clicking, it will send an email of a report (or a snapshot view of the report) that is created from the information they just filled out in a form. Is that possible? Also, can I have a button that...
  20. PaveFE

    ppt slideshow, with a twist

    Is there anything else, that is free?

Part and Inventory Search

Back
Top