llputney
asked on
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.
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.
ASKER
:( 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.
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.
What is:
ChangeResolution800x600
?
mx
ChangeResolution800x600
?
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
Which part of the coding should I move?
ASKER
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!!!
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!!!
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
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
ASKER
I canNOT wait to get PetersSoftware, thanks for the review!!!
ASKER
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!
Try this instead:
CurrentDB.Execute "DELETE * from tblAppointments;", dbFailOnError