|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 7th, 2004, 02:09 PM
|
|||
|
|||
Default message coming up when I try to delete a record in a form
Hi, long time lurker first time poster
Have an issue when I try to delete a record from a form, the msgbox message I coded in to confirm the delete pops up fine,when you click yes on that it brings up that "you are about to delete 1 record(s) ..." message that you get when you delete straight from the table. I'm using RunCommand acCmdDeleteRecord to kill off the record Any help would be appreciated thanks oh also how can I stop it from saying that the database could contain destructive code when it starts up ? the boss is getting suspicious  thanks again 
|
|
#2
August 7th, 2004, 03:50 PM
|
|||
|
|||
|
Default message coming up when I try to delete a record in a form
If MsgBox("Are You Sure?",VbYesNo) = VbYes Then
SetWarnings False RunCommand acCmdDeleteRecord SetWarnings True End If -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Larnoc" wrote in message ... Hi, long time lurker first time poster Have an issue when I try to delete a record from a form, the msgbox message I coded in to confirm the delete pops up fine,when you click yes on that it brings up that "you are about to delete 1 record(s) ..." message that you get when you delete straight from the table. I'm using RunCommand acCmdDeleteRecord to kill off the record Any help would be appreciated thanks oh also how can I stop it from saying that the database could contain destructive code when it starts up ? the boss is getting suspicious thanks again
|
|
#3
August 8th, 2004, 02:37 PM
|
|||
|
|||
|
Default message coming up when I try to delete a record in a f
Seems that Access didn't recognise the setwarnings commands there chap
Thanks for the reply though "PC Datasheet" wrote: If MsgBox("Are You Sure?",VbYesNo) = VbYes Then SetWarnings False RunCommand acCmdDeleteRecord SetWarnings True End If -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Larnoc" wrote in message ... Hi, long time lurker first time poster Have an issue when I try to delete a record from a form, the msgbox message I coded in to confirm the delete pops up fine,when you click yes on that it brings up that "you are about to delete 1 record(s) ..." message that you get when you delete straight from the table. I'm using RunCommand acCmdDeleteRecord to kill off the record Any help would be appreciated thanks oh also how can I stop it from saying that the database could contain destructive code when it starts up ? the boss is getting suspicious thanks again
|
|
#4
August 8th, 2004, 04:29 PM
|
|||
|
|||
|
Default message coming up when I try to delete a record in a f
My mistake! Shoule have been:
DoCmd.SetWarnings False DoCmd.SetWarnings True "Larnoc" wrote in message ... Seems that Access didn't recognise the setwarnings commands there chap Thanks for the reply though "PC Datasheet" wrote: If MsgBox("Are You Sure?",VbYesNo) = VbYes Then SetWarnings False RunCommand acCmdDeleteRecord SetWarnings True End If -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Larnoc" wrote in message ... Hi, long time lurker first time poster Have an issue when I try to delete a record from a form, the msgbox message I coded in to confirm the delete pops up fine,when you click yes on that it brings up that "you are about to delete 1 record(s) ..." message that you get when you delete straight from the table. I'm using RunCommand acCmdDeleteRecord to kill off the record Any help would be appreciated thanks oh also how can I stop it from saying that the database could contain destructive code when it starts up ? the boss is getting suspicious thanks again
|
|
#5
August 8th, 2004, 11:33 PM
|
|||
|
|||
|
Default message coming up when I try to delete a record in a f
Many thanks, worked fine
the help was much appreciated
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Transferring Current Record From One Form To Another | Abilly | General Discussion | 1 | August 3rd, 2004 01:05 PM |
| Remove attachments from newsgroup posts | Earl Kiosterud | Outlook Express | 6 | June 21st, 2004 10:49 PM |
| Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |
| Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |
| Form Does Not Go To New Record | Steve | New Users | 1 | May 12th, 2004 03:15 AM |
Linear Mode
