Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. amna77

    report in MsWord

    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...
  2. amna77

    can't set value to 0

    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...
  3. amna77

    can't set value to 0

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

    can't set value to 0

    no error message, but that total value stays same.
  5. amna77

    can't set value to 0

    Thanks for reply, but still not working.
  6. amna77

    can't set value to 0

    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...
  7. amna77

    can't set value to 0

    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...
  8. amna77

    Chart help

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

    Chart help

    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...
  10. amna77

    total on form

    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
  11. amna77

    total on form

    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...
  12. amna77

    total on form

    Thankyou ZmrAbdulla , its working now, thanks for help.
  13. amna77

    total on form

    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
  14. amna77

    total on form

    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...
  15. amna77

    autonumber with letter

    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
  16. amna77

    relation for subfrm and sub sub frm

    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...
  17. amna77

    update query help

    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.
  18. amna77

    update query 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
  19. amna77

    update query help

    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...
  20. amna77

    mail merge

    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

Part and Inventory Search

Back
Top