VBA

[dokko]

New at this, in fact 1st time, so probably a really easy thing to do.

Basically a want to send data from a textbox on an access form, into a table in access, but anything i do doesn't work, but then again, its all random stuff im trying, any ideas?

Thanks.

 

[RockLobster]

Simple Way
-----------

Assuming you are using Access 2003.

1. Click on Forms, choose Create form in Design View
2. Right click in the dark grey area to bring up the properties for the form.
3. In the Record Source property choose your table.
4. You should see a floating toolbar with Label, Textbox, Option Group, etc. Click on Text Box and then click on your form.
5. Right click on the white text box go to properties and in control source choose the field you wish to save the data in.
6. Back to the floating toolbar, this time click on Command button and then click on your form. A command button wizard should popup, choose Record Operatings and then finish the wizard.

All done.

 

[dokko]

You are a star, thanks, worked a treat, i was trying to throw daft code at it all day yesterday and last night, i forgot i even made this thread!!

Cheers.

Do you know of any good VB VBA beginners books i should look out for?

Thanks.