Do you use DAO for the connection to the database? Otherwise you could add 'Begintrans' in the beginning of your updatecode and 'Committrans' at the end. Then the data will only be saved at the ending, if no errors occured.
Wendy ________________________________ Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Verzonden: woensdag 22 september 2004 23:34 Aan: [EMAIL PROTECTED]; [EMAIL PROTECTED] Onderwerp: [Visual Basic 6 programming] Hello Friends I made my inventory system in vb with help of access . I found another problem through testing my project . i have small inventory system . in that i had a from named "Order" in that form so many tables r updating .but meanwhile when i clicked on save button that time order named table update but when item(For Stock effect) table's turn come . electricity gone and that saved half data(only in order table) . Now how can i do that ? i mean to say delete that saved data . i wanna to make my procedure like if update then all otherwise none ! Kina Jadeja [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT click here <http://us.ard.yahoo.com/SIG=129490m7r/M=294855.5468653.6549235.3001176/ D=groups/S=1705115364:HM/EXP=1098540429/A=2376776/R=0/SIG=11ldm1jvc/*htt p:/promotions.yahoo.com/ydomains2004/index.html> <http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group s/S=:HM/A=2376776/rand=177377218> ________________________________ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] bscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=17726 Please do not reply to this message via email. More information here: http://help.yahoo.com/help/us/groups/messages/messages-23.html <*> To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
