Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, March 30, 2010 – Permalink –

Deletion Warning

Reinforce

After a while, the warning that a record will be deleted becomes routine.
Here’s the code to create your own notice:

  1. Open the database, and click Macros under Objects.
  2. Click New.
  3. Right-click the macro title bar and select Conditions. (In Access 2002, click the Conditions button in the Macro toolbar.)
  4. Click in the first Conditions cell and enter the following:
    MsgBox("Do you really want to delete the record?"273,"Delete")<>1
  5. Click in the Action cell and enter CancelEvent.
  6. Click in the next Condition cell.
  7. Enter an ellipsis (...).
  8. Press [Tab].
  9. Enter StopMacro.
  10. Click in the next Action cell.
  11. Enter Keystrokes.
  12. Under Action Arguments, click in the Keystrokes box and click [Enter].
  13. Close and save the macro as ConfirmDelete.
  14. Open the form in design view, then right-click the form and select Properties.
  15. On the Event tab, click in the On Delete property box and select ConfirmDelete
Create a new warning for Access record deletion



See all Topics

Labels: ,


<Doug Klippert@ 3:15 AM

Comments: Post a Comment


  Monday, March 22, 2010 – Permalink –

Database Phobia

Fear of the unknown

What's a database? What's Access? What's what.
A basic description and explanation.
Aunt Crabby




See all Topics

Labels:


<Doug Klippert@ 3:21 AM

Comments: Post a Comment


  Saturday, March 13, 2010 – Permalink –

This blog has moved


This blog is now located at http://unofficialaccessstuff.blogspot.com/.
You will be automatically redirected in 30 seconds, or you may click here.

For feed subscribers, please update your feed subscriptions to
http://unofficialaccessstuff.blogspot.com/feeds/posts/default.

<Doug Klippert@ 6:51 PM

Comments: Post a Comment