Search results

arh..my mistake... TotalAmount is name the control at subform footer. so at TotalAmount's ControlSource is =Sum([Total]) i tried replace MaterialSubform with ChildMaterial(control that hold MaterialSubform at Main Form), like this ChildMaterial.Form!TotalAmount at dummy txt box but it show...

y when i use cbo, these solotion not work? it say that i "mismatch in criteria expression.. can any1 help me?

ok guys.. i dunno what exactly happen..i think i done it at right way.. ok..i create Main Form that contain 2 (material and workmanship) subforms. subfrom i create using wizard from query then i use =Sum([TotalAmount]) at subform footer to calculate total price from selected part (i create...

eh..i think i lost sumting... how to separate page? i mean if i have small data, when i want to print it it show 2-3 page in 1 print page... i want print 1 data page per print page... thanks

tell us more details...

It Works !! Not Works.. How bout if i plus 2 Total Amount atthe box at Main Form? thanks...

use Subreport to print out form... :)

wow..nice... thanks..help me alot..especially preview n print report..

not bad...looks like never ending game

this is just a suggestion n my opinion.. i think we need real time forum..i mean we use IRC client to discuss our prob in access like some linux expertist did at Xchat (not remember the server but the channel is #linuxforum, or can check it out at linuxforum.com) but to do this we need...

i use Ms Access 2000 (home)& 2002 (office).. can i choose type of relationshp manually.. i mean i can change ony-to-many to many-to-many or some thing like that... if it possible, how... plz help me...

yeee..i can login back wit my prev login name..so Janjang = nostradamus :P

another question..how to make my combobox shows only month and year? bcoz i just want to list down the month for every year on them... i've tried it (at customer table,failure date, format mmm yyyy) but when i click in cbo, it automatically changed to medium date (dd/mm/yy)

hmm...thanks Le but i see that combobox dont have any coding at AfterUpdate.. can u tell me y and how to do that?

thanks.. i really appreciate it... is the coding for listbox n combobox r same like that? am i need use "!" for tab page also? tq...

can any1 tell me y im missing in my db? look at Monthstock form... plz tell me step -by-step how to do it..plz..im new

sorry... now i can post the db after create new db then import from original.... try then plz give some solution bout it.... thanks

plz help me how to do it... plz look at tables i have "monthyear" & "partno/details and month" table i cant open all part that have same month at table monthyear... but i can open n view customer that bought same part at partno/details... then i cant create form from table Monthyear..i want...

got it..use autoform wizard..easy... look here for details... http://www.functionx.com/access/Lesson27.htm

i just to know how to list the all data at subform that same thing that i selected at combobox.. ok for example.. i want to list all car part that purchased in nov 2005 at subform... date(nov 2005) selected from combo box... then if i change other date (ex: dec 2005) it update n view new...