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

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.
llputneyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
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
 
mbizupCommented:
>DoCmd.RunSQL "DELETE * from tblAppointments;"

Try this instead:
CurrentDB.Execute "DELETE * from tblAppointments;", dbFailOnError
0
 
llputneyAuthor Commented:
:(  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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
What is:

ChangeResolution800x600

?

mx
0
 
llputneyAuthor Commented:
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
 
llputneyAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
llputneyAuthor Commented:
I canNOT wait to get PetersSoftware, thanks for the review!!!
0
 
llputneyAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.