468,539 Members | 1,906 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,539 developers. It's quick & easy.

VBA button to transfer data in an Access Form to an Access Table

I appreciate the help in advance,

I have a Microsoft Access form that users enter information into (text boxes and option buttons) and on that form I have a button that users are able click. Here is where my issue resides; when the button is clicked I would like the information they have entered to transferred over to a specific table on Access. (I can have this data transfer over to an excel sheet if that would be easier) What would the VBA code be that could write for this button in order to make this happen?

Thank you for your time
Aug 13 '14 #1
4 990
twinnyfo
3,650 Expert Mod 2GB
RGM2244,

You rform should be bound to a Table, then you won't need any code to transfer the data. This is the standard setup for any form.
Aug 13 '14 #2
twinnyfo,

Thank you for getting back so quickly. I believe my form is unbound since I have created that and as of right now there are no tables.
Aug 13 '14 #3
twinnyfo,

If I decide to create a bound form will it automatically create new entries without altering the previous entries with the simple click of the button put into the form?
Aug 13 '14 #4
twinnyfo
3,650 Expert Mod 2GB
In general, yes.

The general concept is that you create the Table first. Then, you create the form, based on the fields in the Table. As you navigate to new records on the form, new records are created in the table. You can also modify any existing records in the Table by navigating to that record in the Form.

I would refer you to this link: Normalizing Databases, which will help you understand some basic concepts about databasae design, and also recommend you search the web for some good MS Access primers on building database projects.

Of course, we are always here to help and offer advice.

We especially appreciate when posters try their own methods first, and when their efforts are ineffective or unsuccessful, post their designs so they can be improved. We love to help those who are trying to expand their capabilities!
Aug 13 '14 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by =?Utf-8?B?Y2xhcmE=?= | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.