Database doesn't ask about deleting records

G

Guest

I have created a form in Microsoft Word and when the command button
cmdDataSwitch is clicked on that form the following code is executed.

Private Sub cmdDataSwitch_Click()
'Open Access and make visible
Set oApp = CreateObject("Access.Application")
oApp.Visible = True

oApp.OpenCurrentDatabase "W:\Dunndatabase.mdb"

oApp.DoCmd.OpenForm "Dunn Switchboard"

End Sub

The code works fine and opens the form Dunn Switchboard. The problem is
that when records are deleted Access does not ask whether or not you want to
delete the record, it just deletes them. When the database is opened a
different way Access does ask about deleting records. How can I modify the
code to get Access to prompt about deleting records, or is there a better way
to code opening the database via microsoft Word and getting Access to prompt
about deleting records?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
to VanThien Dinh 3
Record-Locking remains open after closing 0
Excel Is it possible to ask a question within a question? 0
Access Command to run access, open to specific form and specific record 1
Code to find table dependencies of queries 10
auto deleting records that are missing data 5
From an Access Button trying to open a Word Document 1

Top