|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
October 20th, 2004, 09:41 AM
|
|||
|
|||
Delete Query
Hello,
I am hoping someone might be able to help me out. I am trying to create a delete query in VB for access. I have managed to get it to run the delete query, but I would like to program in the responses to the following questions: "You are about to run a delete query that will modify data in your table. Are you sure.... Yes" "You are about to delete X row(s) from the specified table. Yes" Here is what I have so far: Private Sub Command32_Click() DoCmd.OpenQuery "DELETEQUERY", acViewNormal, acEdit End Sub Does anyone know how to do this??? Thanks, Jason
|
|
#2
October 20th, 2004, 11:44 AM
|
|||
|
|||
|
RE: Delete Query
Hello jasondatabase,
Turn off then turn on the SetWarnings method. Try the revised code below. Hope it will help. '------------------------- Private Sub Command32_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "DELETEQUERY", acViewNormal, acEdit DoCmd.SetWarnings True End Sub '-------------------------
|
|
#3
October 20th, 2004, 04:03 PM
|
|||
|
|||
|
Quote:
Thank you!!!!!!!!!!
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Delete Query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
