Search results for query: *

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

hi I have 4 tables 1:tblMain =Primerykey:IngID is Autonumber 2:TblTrend =Primery Key=IngtrendID is number 3:tblsymbol =PromeryKey=IngsymbolID is number 4:tblDefects in the relationship window, I have joied, tblTrend and tnlsymbols to tblmain, by ID's. Thats fine. now I want to join tbldefects...

UPDATE tblParts SET tblParts.txtBaanNum = ([txtPartNum]); Its working now, actully I closed the database and open it up again, it worked. so thanks for help.

its update query and in the TxtBaanNUmber field,its like that Field=txtbaannum Table=tblparts Update=[txtpartnum] when i view the query, it puts the same value like txtpart, but when i run it, it does not update. thanks

hi I have 2 fields in my update query, one is txtPartNum and other one is txtBaanNum. txtBaanNumber I want to update, it should equal to txtpartNum. so what ever value is in txtpartnum, should update table, so that txtbaannum will have same value as well. when i view the query then it gives me...

how would you send a seprate word merge file? can you please give me an examle, how to do that. I shall be thankful to you. Thanks