Search results for query: *

Nope - didn't work.

Okay, crazy! I just went back & typed it fresh, instead of inserting the Nz - now it took! Go figure. Anyway - still getting the error

Sorry - I did that, just forgot to type them here

1 & 2 - yeah, I can see that would work 3 - it doesn't like the syntax!! When I try =Sum(Nz(Amount)) It says invalid syntax I tried +Sum(Nz(Amount) Same result. Wierd!

Okay, let's see if I can do all the answers at once! 1) Datasheet view - needed to get the new lines 2) Continuous form - I see, they do add; however, that would make for a very loooong sub-form, or am I just tired? I can format so that each new form is really close, right? Either way - I tried...

Oh - no, that won't work, as I need it to add lines as they go, so datasheet view is needed. If you look in the Northwinds Db, they do use the same thing I'm doing (that's where I got it from!), & the sub-form is datasheet view, but does have totals on it's footer that are referred to in the...

If you format as a continuous form, how do you than also format as datasheet? Also - when I just did it as a form, the form footer field for the total gave me an error, instead of showing $0.

Sorry - forgot to include that I had to build the sub-form off of the updates table, not a query, as when I used the query I couldn't type in any of the fields on the form - ???

Form has only 3 fields in the detail - type, date & amount. It's used as a sub-form on another form, to record account transactions for various funds. The sub-form is set to display in datasheet view, so on the main form they can add as many lines as needed, & always see the previous...

There must be a way to do a calculation & then store the result - that's really all I need to do.

Okay - form is based on a table & sub-table. Main table has the account starting & current balances. Sub table has the update records. Main table is for funding sources that have money coming in & going out, so I created the sub-table to record the transactions. I did an auto-form, so that...

Oh - sorry - yeah, that did it! Thanks.

Thanks, AceMan!! Yeah, I knew that! Zor - I've done that as well, but wouldn't apply for this need. I did use it earlier, though, for the simple "pick a name in the drop-down & go to that record" option!

Okay, sorry to bug y'all with this one, but my "cheat sheets" are on a CD at work, & I'm at home! Simple question: On a form, once the data is entered, users need to choose between "Done" (okay, I can handle that one!) and "Add Another Item". On the add another - I need the code for saving the...

That didn't pull anything into the form. Next idea? ! (code - gotta love it!)

Simple idea: use a combo box on the form header to list all records in a table; select the record you want, & it displays the rest of the data for that record in the form detail. Should be easy, right? Why do I always get stuck on the obvious ones!!!!! Okay - here is the code as I used it from...

Okay - just call me "DUH!!!" That's all it was, AceMan1 - I just needed to change 60 to .6!! Okay - Now I can copy/paste that code into the other 6 reports that have the exact same info, just the "based on" is different! (has to do with unit vs worker vs agency, etc - don't ask!). And then I...

Okay - take 2!! I tried just changing the first text box from "NA" to Null, & I put in the code - didn't work; tried the conditional formatting box - turned it red/bold, even though the result was 92.00%! Code I'm using is: If Me.txtP1_I5_1Compliance <=60 Then...

Ah ha!! See - I knew that IIF statement had something to do with it! Thanks - I'll try it in a bit. I was hoping you'd be online - you always give me excellent advise! +Tammy

I want to apply some text formatting on unbound text boxes, but it's not working. I think I've narrowed down the problem - has something to do with the control source being an IIF statement. I say this because the conditional formatting works fine on other unbound text boxes on the report...