By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,127 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Office Assistant

P: 6
I am trying to make a delete button using the office assistant as the message box, this is using VBA code. I know how to write the code for the office assistant. But I am not sure on how to create the delete button with the office assistant, any help would be appreciated.
Aug 14 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,638
Here is a standard code Template for displaying a Message Box using the Office Assistant:
Expand|Select|Wrap|Line Numbers
  1. Dim Bal As Balloon
  3. Set Bal = Application.Assistant.NewBalloon
  5. With Application.Assistant
  6.   .On = True
  7.   .Visible = True
  8. End With
  10. With Bal
  11.   .Heading = "Record Deletion"
  12.   .Text = "You are about to Delete Records in Blah, Blah, Blah..."
  13.   .Icon = msoIconAlertWarning
  14.   .Button = msoButtonSetOK
  15.     .Show
  16. End With
Aug 20 '08 #2

Expert 2.5K+
P: 3,532
Don't forget to add the Microsoft Office xx Object Library, where xx is the appropriate version for your version of Access. For v2003 it's Microsoft Office 11.0 Object Library

Linq ;0)>
Aug 20 '08 #3

Post your reply

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