Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DoCmd.Close shutting down all Access

Status
Not open for further replies.
davejackson

davejackson

Technical User
May 8, 2001
34
GB
Hi,
I'm running the following code to delete a specific record from a table from a 'delete form'. (No idea if this is relevant). About half the time the DoCmd.Close line is executed the whole of access closes. (The other half it seems to behave normally and just shuts the form). This is obviously pretty frustrating.

DoCmd.RunSQL "DELETE from tblName Where This = "That";"
DoCmd.Close acForm, "frmName", acSaveYes

Please can anyone shed any light on why this is happening?
Thanks, Dave
 
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
158
Xavierparkash
Xavierparkash
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
396
dhookom
dhookom
BlakeLacy1
  • Locked
  • Question
COPY ALL FOLDERS AND CONTENTS TO A NEW LOCATION
Replies
4
Views
142
Andrzejek
Andrzejek
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
773
JanaLNelson
JanaLNelson
TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
170
Axworthy
Axworthy

Part and Inventory Search

Sponsor

Back
Top