Solved

Warning msg: "You are about to delete 0 row(s) from the specified table" -- ZERO!?!? HELLO!?!?

Posted on 2007-03-28
9
391 Views
Last Modified: 2011-09-20
I developed an Access database and it is now in the testing/debugging phase with one user playing with the databsae.  The user said that each time she exits the database, she gets a message that pops up saying "You are about to delete 0 row(s) from the specified table."   I am perplexed because I have not seen this message and when I open the same file that the user is working on, it doesnt give me the message on my computer.  Its only on her computer, what's the deal?

The only thing I could think of was my Appointments table.  I have a form that you can use to add appointments/meetings in the Outlook calendar.  So I set up a query to delete all rows in the appointments table when the user exits.  I added the SetWarning messages in my code and the user is STILL getting the same message when she exits the database.

Private Sub Form_Close()
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * from tblAppointments;"
DoCmd.SetWarnings True
ChangeResolution800x600
Application.Quit
End Sub


This was the only thing I could think of because the user wasn't doing any data entry or trying to delete anything or even trying to add an appointment and it's weird to get a message saying, "You are about to delete ZERO rows".....ZERO!?!??! Why is this happening?!?!?  Please help!!!  This is a difficult challenge for me because I can't test this when I'm not even getting the error message.
0
Comment
Question by:llputney
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 18809074
>DoCmd.RunSQL "DELETE * from tblAppointments;"

Try this instead:
CurrentDB.Execute "DELETE * from tblAppointments;", dbFailOnError
0
 

Author Comment

by:llputney
ID: 18809178
:(  Didn't work.

Another thing that's weird is that both the user and I are on a shared network drive and we both have access to the same file.  Now, when I tell her to open her database to check something, I don't see her opening it.  I mean, I almost never see the .ldb file and I only see that when I have the database open on my computer.  
0
 
LVL 75
ID: 18809293
What is:

ChangeResolution800x600

?

mx
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 18809306
Possibly some odd ball timing issues ... code executing during the OnClose followed by Quit.  Can you experiment by moving the code elsewhere ... as a test, if you see what I mean?

mx
0
 

Author Comment

by:llputney
ID: 18809358
Unfortunely, the user uses an 800 x 600 screen resolution and I found out AFTER the fact that I designed it on a 1024 x 768 screen setting.  So, I devised a temporary solution to change the user's screen resolution to 1024 x 768 when the open the db and change it back to 800 x 600 when they exit.  I ordered the ShrinkerStretcher software and I'm still waiting for it.  Once I get it, I will be able to remove the screen resolution problem.  Do you think that's what it is?

Which part of the coding should I move?
0
 

Author Comment

by:llputney
ID: 18809750
I'm SOOOOOO embarrassed...sigh.

I was making changes in the wrong file....no wonder why I couldn't see the user opening/closing the file on our shared network drive.  I feel so so so foolish!!!

My FIRST solution actually worked which was to set up the SETWarning codes:

Private Sub Form_Close()
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * from tblAppointments;"
DoCmd.SetWarnings True
ChangeResolution800x600
Application.Quit
End Sub


So, how should I handle this request?  Shoudl I reward points for your efforts or should I get them refunded?

So Sorry to waste anytime's time, including MINE!!!
0
 
LVL 75
ID: 18809793
Split the points between me and mbiz ... for 'effort'.

btw ... The PetersSoftware SS is VERY cool.  I bought it  and it works VERY well ... covers almost all cases of forms, subforms, tabs .... etc.  It's one cool piece of software.

mx
0
 

Author Comment

by:llputney
ID: 18810593
I canNOT wait to get PetersSoftware, thanks for the review!!!
0
 

Author Comment

by:llputney
ID: 18810609
Uh oh! I couldn't figure out how to split points since EE has had a new makeover.  I clicked "Accept Mulitple Solutions" and ended up only selecting one solution.  Sorry mbizup!  Appreciate the effort anyway!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question