Web Development

Ask something
Discussion Locked

Need MS Access Command Button help

0 helpful
9 replies

by xpertdragon 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am in a serious bind to get a MS Access Form Completed in Access 2000. The Form Currently has the following data objects: 2 drop down field selectors, 1 ActiveX Date/Calender Field using the pre-defined Calendar for forms in MS Access. 3 Basic Fields all together (2 of them drop downs, 1 a regular text box with a date that is supplied from the Calendar.)

I am trying to create a COMMAND button that will take call current Fields as they are entered or selected, and append them to a Sub-Form (Not sure if that is what is called, a embedded database that is in the footer of the Form). Using the basic COMMAND button wizard is getting me no where near to entering records into a NEW or EXISITING table within the database.

I am looking for specific instructions for appending/adding records into a new TABLE or an existing table with a command button on a form. I need specific instructions or a web page reference please. (I get confused easily.)

Thank you.

Paul

9 replies

by shmaltz

Do you want us to teach you VBA?
Go to your favorite book store and buy a book on VBA/Access. If you want to learn using the Web try MS Tech Net and newsgroups.

by john_wills

This looks to me to be the kind of question best answerable by someone in the same institution: you have a lot of questions and only someone who can see what you already have and ask questions about it can identify your individual questions and answer them - one at a time, you doing work and finding a lot of answers yourselves between the colleagues answers. The apprentice system is still needed.

by rawright

As mentioned before, there is far too much information lacking from your question to allow an answer here. There are some excellent resources available, though, that can provide examples and tutorials. One of the best is, of course, Microsoft, butTechnet is not the right source. Spend some quality time at the MSDN Library ( http://msdn.microsoft.com/library/ ) for more information than you really want. And if you get in a bind after that, check out http://www.codeproject.com for some more articles and real people to assist you.

by haris

You have got subforms.
On click event of the button add this code

Forms![Your Form Name]![Subform name].Form.Controls![Your Control Name] = me.your control name

this will apply the value from your current form to its sub form.

This discussion is closed to new replies.