Search results for query: *

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

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

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

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

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

Now I got it. Thanks for all the help.

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

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

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

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

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

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

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

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

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

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

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

Thanks

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

Is there anything else, that is free?