Search results

Thanks Ian No I am not saving the amount any where. I have found that putting the calculation in the source works better for me though. If in the control source, then access won't let users change a calculated a control anyway. Thanks again. Jeff

Thanks for all the help guys. Fornattions Suggestion worked with a little modification. What I ended up with is this: =IIf([TotalEquity]<0,([TotalPayoff]-[TotalAllowance]),0) Works like a dream.. Thanks again guys.. Jeff

Thanks guys for your quick replies; however still have no joy with either solution.. Tried the VBA Code on on current and Before_Update.. tried the expression as control source for [PayoffRollover].. any other ideas? Thanks Again, Jeff

Did I miss the BUS???? Please count me in with that code.. PLEASE?? Thanks Jeff jeff@pcdummy.com

I have a Calculated text Box [TotalEquity] this can a return a positive or negative currency amout. OK to here; I arrive at this control by the following: [Allowance]-[PayOff]=[TotalEquity] I need to provide for a control that returns the negative value(if any) of [TotalEquity] and then place...

Thanks Rich Worked great... How stupid of me... Thanks again jeff

Well, do not know it will do exactly what you want.. but you could use the fax software that is built into Win95/98/ME/2000. Create a query based report that is set up to print to the Fax Driver (Fax Software is setup to Work this way) Then simply choose that Printer(Fax Software) as the default...

Thanks for the quick reply Peter Paul; however now my figure is ALWAYS red.. Same thing that happened with my original code.. I am thinking it has something to do with the negative currency format.. Any more suggestions GREATLY Appreciated.. Thanks again Jeff

hi guys. I have looked thru the posts here, and have found some that are close.. But none that works for my particular case.. I have a currency formatted and unbound calculated text box that displays a calculated currency amount If Me![TotalEquity] <= 0 Then Me![TotalEquity].ForeColor =...

OK I have tried every syntax i can think of and am still receiving an #Error with a null value... Please help Ok I have a table (tblAdjustments) AdjustmentID Description AdjustmentCost from this is created a subform.. in the footer have a calculated text box txtTotalAdjustments Control...

I am thinking you need two tables one for companies(and their info) and one for chemicals.. Maybe something like this table1 CompanyID COmpanyName CompanyAdd Etc, etc table2 ChemicalID COmpanyID CHemicalName If you like please send me a copy of your db, and I will take a look at it for...

I am sure this can be done; however, need more information as to db and table structure in order to point you in the right direction. Please reply, an restate your question more clearly.. I will try to assist you as best I can. Thanks jeff

Thanks guys. Tried both ways. Both worked. Decided to go with Fornation's suggestion in the end. However, thanks to everyone for the help Jeff

Thank you very much, I will try as you suggested, will post results. Once again, thank you for taking the time to reply to my post. Very much appreciated. Best Regards, Jeff

Ok Let me try to explain my dilemma. Am trying to construct new db, where customers can by individually or jointly. Have a orders form where when you enter the customer information, you can use an option group to choose "individual" or "joint" purchase. i would like the CO Buyer Fields and...

Could someone please explain to me how to open a form from an external access database using automation. I would like to open the form from within another database. Is this possible? If so, how? Thanks A Million Jeff

Thanks alot! Looks like just what I need, and more than half off the price of the AddSoft or ProView Stuff. Once again, thank you for your quick reply. Sincerely, Jeff

Hi ! I was wondering if any of you gurus had come across a good scheduling/appointment ocx that works with both Access 97 and 2K that doesnt cost a fortune. Would hate to have to code something this complex, when I am sure some has already invented the same wheel... Thanks in advance.... Jeff

Thanks Marion will try that right away. I really appreciate your time in helping me with this matter..... Best Regards, Jeff

pleaseeeeeee help.... Time Bomb Ticking!!!