Adding Command Button To Form

[uneek78]

I am using Access 2000. Evidently adding a Command Button isn't as cut and dry as clicking on it, selecting a location on your form, and going through the wizard and choosing what you want. I have added a Save Record & Add Record to my form. Evidently some VB coding is required. Which, I don't see why the option is there to add a button through the wizard w/ preset names (ex - Save Record, Add Record, Next Record, etc..) if they don't automatically work when you use them. Can anybody help me!?! I am familar with access, but have no idea about this VB coding stuff. So if you have the time and decide to answer my question I would need to know step-by-step how to incorporate anything that requires code to make this work. I don't understand ANY VB AT ALL!!!! Yeah, I'm pitiful. The 1st step is admittance. The 2nd step is YOU helping me. I'm about to lose my mind..........

[rommelgenlight]

sure thing.

to make a command button to add a record that you have input in your form, the step are:

1. right click the command button for your add purpose and click properties
2. goto event table and double click the field in the On Click
3. you will see now [Event Procedure]. Then click the "..." button on its right
4. now your in the microsoft visual basic where you are to code

now it will look like this:

Option Compare Database
-------------------------------------------------------
Private Sub Command2_Click()

End Sub

5. in between Private Sub command2_click() and End Sub is a space where you are code.
6. and the code to add new record is

DoCmd.GoToRecord , , acNewRec

7. Actually, when you type docmd., you will notice that you have a guide what next code are to be completed, you only need to follow.

8. then goto its microsoft visual basic menu bar and you will find DEBUG then click compile

9. compiling and saving would be the last thing to do after each and every coding you make.

try it yourself.

[uneek78]

This is the code on the "Add Record" button:

Private Sub Add_Record_Click()
On Error GoTo Err_Add_Record_Click


DoCmd.GoToRecord , , acNewRec

Exit_Add_Record_Click:
Exit Sub

Err_Add_Record_Click:
MsgBox Err.Description
Resume Exit_Add_Record_Click

End Sub

What do I do with it!?!

[rommelgenlight]

put that in your On Click event of your command button of adding.

[uneek78]

This is what I got when I added the above code in there and attempted to use it:

Microsoft Access can't find the macro 'Private Sub Add_Record_Click() On
Error GoTo Err_Add_Record_Click


DoCmd.'

The macro doesn't exist, or the macro is new but hasn't been saved.

[uneek78]

I guess I would like to know why do I go through the wizard for adding the command button and the button not work. You would think it would put the code in there for you being that the options for what kind of button you want are already pre-written in the wizard. Just seems kind of silly to me that you would create the button using their process and it not work automatically. I dunno............memoirs of a non-coder.

[uneek78]

Got it! I google and someone answered this question in this forum and got an easy answer. He said he creates a macro that saves, closes, & reopens the form. I was able to do that..........viola!!!!

[marianne]

good for you uneek78. but macro is not the visual basic coding ok. i guess if you use wizard and its autogenerated codes are functioning, then you need to re-install your ms access application. maybe there is a problem there.