Hello, I created a form within V

[dalex17]

Hello,

I created a form within the VB screen of my Access database and called it UserForm1. The only object in that form is a picture of a progress bar.

My question is: How do I link that progress bar to my save button which is on the form. I want that progress bar to execute each time I click the save button.

FYI - I obtained that progress bar from the internet and think it would be cool to incorporate it into my database.

dalex

 

[Rolliee]

Look at the code 'under' the progress bar. It should tell you how to do what you wish. If you cannot understand it show the code here and someone will help.

Rollie E

 

[dalex17]

This is the code behind the progress bar:

Private Sub FrameProgress_Click()

End Sub

Private Sub UserForm_activate()
Call Main
End Sub

This is the SAVE code:

Private Sub Command71_Click()
On Error GoTo Err_Command71_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Exit_Command71_Click:
Exit Sub

Err_Command71_Click:
MsgBox Err.Description
Resume Exit_Command71_Click

End Sub

I guess I am just trying to combine them.

Thanks,

Dalex

 

[Rolliee]

Place the following code in the first sub above.


msgbox "I am here"

This will show you how often it fires.

Rollie E

 

[dalex17]

I'm not interested in how often "it fires", I'm intrested in making it work in conjuction with my save button.

Thanks,

Dalex