Search results

okay done with your suggestions, replaced percentage with numbers (double) but still i cant get it work.

okay i can do that... but how about the flow? i dont know if thats the right word but as you can see the dbs is quite messy when it comes to the calculations. theyre not seeing each other when i tried to pull out values from the table thats why calculations are not working, i know theres a big...

ops sorry, my bad... the calculations are in the Query - QRY_SearchAll Form is - FRM_SearchMulti Then go to "High Level Cost Estimate" tab....

attached is my dbs...

CJ_London, I tried your suggestion but it didnt work. sigh...

CJ_London, thanks. sorry but i made a mistake about the calculation its not [Unit Weight] * 850 * [Year] * [Contingency] BUT IT IS: [Unit Weight] * 850 * [Escalation] * [Contingency] ..... what im getting right now is the Combobox, its WORKING that whenever I chose a Year the Escalation...

Experts of Ms Access I need your help again... I posted my concern way back in this forum but still I cant get it work. I need your help again. The problem is that, I wanted to work on changes of calculation per row. I attached a photo to make it much clearer. In Design Engineering: If...

Thanks missinglinq. but, this conditional formating gives me the #type! result i will have to settle for zero (0) for now if theres no other way.

Form is FRM_SearchMulti.... then the Procurement tab (Contingency Amount and Procurement Estimate) i have lots of item that has #Type! that i deleted.... but i saw 2 items that has that error. i still have problems with my DBS, been posting here before but it seems i still cant get to solve...

i cant convert it into 2002-2003 .mdb format. it says "the specified database sort order, General, is not supported for the target database format". i dont know what that means. im using ms access 2010 by the way. maybe theres a problem or a function not compatible with the older version, IDK.

@ pr2-eugin #Type! comes out again with that code, hehe...

attached is my database... i deleted most of the items in my DBS and some functions... try to search for these items: Fuel Gas Filter Fuel Gas Superheater

i think i have to settle for the first one because the second one prompted me with an error, it says: "data type mismatch in criteria expression"

Thanks a lot. The value appeared is 0 (zero) this is better than #Type! but, is there a chance it could be blank or no value even 0? if none, then i will have to settle for 0.

Like for example this one: Procurement Estimate: [Base Cost]+[Contingency Amount] While Base Cost and Contingency Amount has its own calculation also. Sometimes, Base Cost and Contingency Amount doesnt have values, so I wanted the box to be blank for Procurement Estimate instead of this one...

Hello everyone, im having a problem about my DBS. there is a calculation in the Query then amount or total will appear in the Form. there are some items that doesnt have information in the Table, so obviously calculation wont be involve in that specific item. now, if theres no information to...

Can someone correct this code: Private Sub lkpAssembly_AfterUpdate() lkpQuery.Requery If "Deck" = Nz(Me.LocalX, 0) < 5 Or Nz(Me.LocalX, 30) > 25 Then MsgBox "Please enter a numeric value between 5 and 25" Me.LocalX.SetFocus Exit Sub End If End Sub lkpAssembly - is the name of the combobox...

will try to watch the videos and read the articles. thanks again jdraw!

im NOT really good with programming but i will try this one. i hope i will get this right this time. Thanks jdraw!

i have an idea about cascading combos since my database is using it already. my first post is what im trying to do plus the follow up question: if the user will chose Deck (in the combobox) theres a code that will execute the validation rule like data entry should be greater than 5 but less...