Add data button "Daniel_22 via AccessMonster.com" <u48436[ at ]uwe> 12/31/2008 1:07:38 PM i created a form which contains many Text boxes. Now i want to put a button on this form which add automatically the information from the text boxes as a new line into a table. My question is, is possible to create this button without write VBA code behind him (only with wizard) ? i didn't now the vba code very well. i am using access 2007. sorry for my bed English thx Daniel -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200812/1

Re: Add data button Rick Brandt <rickbrandt2[ at ]hotmail.com> 12/31/2008 1:45:47 PM On Wed, 31 Dec 2008 13:07:38 +0000, Daniel_22 via AccessMonster.com wrote: [Quoted Text] > i created a form which contains many Text boxes. Now i want to put a > button on this form which add automatically the information from the > text boxes as a new line into a table. My question is, is possible to > create this button without write VBA code behind him (only with wizard) > ? i didn't now the vba code very well. i am using access 2007. sorry for > my bed English > > thx > Daniel I don't think there's anyway to get what you want from just the wizards. My advice is to start learning how to use VBA code. You can't go very far with Access without it. The code to do what you describe is not complicated nor very long. You could of course do this with a bound form and no code. Any reason why you don't want to use a bound form? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com

Re: Add data button "Daniel_22 via AccessMonster.com" <u48436[ at ]uwe> 12/31/2008 6:21:25 PM i wish to learn vba code but i didn't find a good book. can you suggest me a way to learn ? i now vb.net a little and i sow that this languages aren't very different Rick Brandt wrote: [Quoted Text] >> i created a form which contains many Text boxes. Now i want to put a >> button on this form which add automatically the information from the >[quoted text clipped - 5 lines] >> thx >> Daniel > >I don't think there's anyway to get what you want from just the wizards. >My advice is to start learning how to use VBA code. You can't go very >far with Access without it. The code to do what you describe is not >complicated nor very long. > >You could of course do this with a bound form and no code. Any reason >why you don't want to use a bound form? > -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200812/1