467,076 Members | 852 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Office Assistant

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
  • viewed: 2411
Share:
2 Replies
ADezii
Expert 8TB
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
  2.  
  3. Set Bal = Application.Assistant.NewBalloon
  4.  
  5. With Application.Assistant
  6.   .On = True
  7.   .Visible = True
  8. End With
  9.  
  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
  17.  
Aug 20 '08 #2
missinglinq
Expert 2GB
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.

Similar topics

reply views Thread by Long, Rochelle (NIH/NIGMS) | last post: by
1 post views Thread by Jarek Zgoda | last post: by
1 post views Thread by Wayne Aprato | last post: by
reply views Thread by =?Utf-8?B?Y3lwaGVyMmc=?= | last post: by
1 post views Thread by =?Utf-8?B?TWFnZ2ll?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.