Recent content by Vicar

Hey, adickie, right on the money, in my case though it was Avery personall assistant! Couldn't get rid of the toolbar, no matter what i tried. Had to uninstall it, to use DB. Thanks for the tip. V

Thank you Seth, Scott and Uncle Gizmo! After finishing my current form (PO), i realized after testing that data selected is stored in the table and unless i go back to this form(i used cascading method for price field as well - :-) sort of breaker; it will keep originaly chosen price) and select...

Hi, please help if you can, i have searched the threads, but unfortunately didn't see anything close. Please point out if i missed some. I am trying to lock or archive old records/invoices from updating when prices update for the same products/services. Anyway of doing it a quick and dirty...

I am making a service db, and one of the main functions in it, is customer's current equipment list with a parts sublist. These are the fields in the servicing equipment table and it is a duplicate of equipment table (EQ ID,Name, Manufacturer,Model,Serial,DateLastServiced(gets updated from a...

I have a main form and a two-tab subforms connected to it. When i had one added, everything was fine, after inserting second one, when i run main form it starts looping-requerying the main form and also it’s subforms. I have included a clean version, maybe someone can tell me what’s the...

Popup Calendar - Version 3 - is absolutely the best and the easiest to use!!!!! Thank you ghudson and thanks to the developer of calendar Denys Brock!!!!!!

It WORKS Thank you all!!!!! It works, my own fault! I was attaching event procedure to the price, when it should have gone to the cost. Dumas :-)

Database sample here it is, maybe it will be easier if you can see the actual thing Thank you all very much!

it looks good but same thing, no change even though nothing is restricted. Thank you

Unfortunately this formula...

Dim Value1, Value2 Value1 = [PriceBook_OLD.Cost] Select Case Value1 Case Is <= 5 Value2 = Vaue1 * 3.8 Case >5 and <=50 Value2 = Vaue1 * 3.2 Case >50 and <=100 Value2 = Vaue1 * 2.8 Case >100 and <=200 Value2 = Vaue1 * 2.4 Case >200 and <=500 Value2 = Vaue1 * 2 Case Is < 500 Value2...

Yes, on the form will be just fine, with all those conditions if possible. Thank you very much!

Simultaneous multi-discount calculation Really need help on this one, here is an excel expression: X Multipliers $ Value Multiplier is less than 5 then *3.8 is less than 50 *3.2 is less than 100 *2.8 is less than 200 *2.4 is less than 500 *2 is greater than 500 *1.8 so if price is less...