Add data button

  • Thread starter Daniel_22 via AccessMonster.com
  • Start date
D

Daniel_22 via AccessMonster.com

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
 
R

Rick Brandt

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?
 
D

Daniel_22 via AccessMonster.com

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 said:
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?
 
M

Miss Teacher

Hey Daniel!

I'm learning VBA to!. A fabulous website that I have found which teaches you
via lessons and pictures is:

http://www.functionx.com/vbaccess/index.htm

It has lessons that take you through at a pace that is easy but fast. I
searched long and hard for a good (free) net tutorial and this is the best by
far I found. And it has a full 2007 tutorial (I also have 2007). It not only
contains info about access alone, but all the other surrounding components
involved. It's excellent! Click on "MS Access 2007" on the top left for
specific 2007 tutorials. Or to learn VBA, begin the lessons numbered 1 to 23
(look for th picuture of the violin) in the centre of the page. (I actually
found that the 2007 tutorial group was a good start as it helps you learn to
'get around', then move onto the VBA ones).

Good Luck!

Daniel_22 via AccessMonster.com said:
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 said:
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?
 
Top