Recent content by amna77

Hi, in my corrective action database, I want to send report to clients, but that report I want in word. so from my database when i click on send report, then it should send attachnment to the outlook with the word doc. IS it possible to do that? Does someone has any example like that...

You know what, instead of =Sum(()+([Burn])+([Contanmination])+([Drag Marks/ Scratches]).....)) I just did [Burn]+[Contamination]+[DragMarks].. and so on. and i left the same codes on me.recalc on the add button. and now it did put the value of 0 in the total field. Thanks alot for the help...

no every thing on the same form, i don't have sub form.

no error message, but that total value stays same.

Thanks for reply, but still not working.

no actually its not only 2 fields, its more then 2 fields, here i just put down 2 as a example. =Sum(([Blush])+([Burn])+([Contanmination])+([Drag Marks/ Scratches])+([Flash])+([Flow Marks])+([Pin Flush])+([Short])+([Sink])+([Splay])+([Missing Inserts])+([Def Inserts])+([Pad Print])+([Tissing...

hi I have one field on my form, which just calculte the total, like Total=sum(([Blush])+([Burn])) . now when i click on add new record, all forms clears up, but this total field does not. in there value stays the same. any help, how to do clear that. i try to put codes on the add new button...

Thanks for reply, one question how would I make a union query? please thanks

Hi, actully i am trying to create a chart. I have a data for whole year in my append table, now what I want to do is, I want to create a chart. Chart will be a bar graph, but in there i want to show Quarters first, and then 3 months from the last quater and then 4 weeks from last month. for...

Got it now, I did that Recalc on after update event, and its working fine, for stand alone form, plus as a sun form as well. Thanks

Hi, I used that me.recalc on those three fields exit event. it was working fine. this total works fine for stand alone form, but when i made that form as sub form,then it does not work. In short when i open this subform in new window then its working fine, but when i try to enter from main form...

Thankyou ZmrAbdulla , its working now, thanks for help.

i tried that requery macro on changeevent, but still not working, i still have to jump to next record and then come back, then it updates. does not update right away when i make chages

hi on my form i am tying to get total, like total defects, by doing =Sum(([TBlush])+([TBurn])+([TContanmination])). i does calculate sum, but it does not show changes right away, i tried to put requery macro on after update event of thos three fields, so when ever i enter any number it shoud...

hi , is there a way that i can add letter infront of autnumber field. I mean instead of , 1, 2, and 3, I am looking for T1, T2, T3. can someone help me please. Thanks