T
tw
I'm having a problem similar to a post from someone else about a month ago.
The problem I'm having is that sometimes access just saves a form or other
object when I close it and doesn't give me the option of discarding the
design changes that were made by asking me to save or cancel. Other times it
works just fine. I haven't found out what causes it.
I'm also having an issue when I try to export from my design db to the live
data if someone is using the live data db when I export. Usually it will
tell me that someone is using the database and design changes can't be saved.
But sometimes it just returns without giving any messages. When I go into
the live data to test the changes, they have not been exported from the test
db.
Neither of the below solutions apply to my situation. I have searched all
the code in my project and there is not a docmd.setwarnings false anywhere.
I checked the settings in Tools | Options | Edit/Find they are all checked to
confirm
Is there another possible solution?
The solution posted to solve this similar issue is the following
Two possiblities:
One: you have deselected the "Confirm" checkboxes in Tools | Options |
Edit/Find. To fix, reselect these items.
Two: you have run VBA code that turned off the warnings and you didn't turn
them back on.
DoCmd.SetWarnings False
' do some code here
DoCmd.SetWarnings True
To fix "two", go to Immediate Window and type
DoCmd.SetWarnings True
and hit Enter.
To not have "two" return, search your code for places where the warnings are
turned off, and the "turn on" step can be bypassed (often occurs if you have
an error handler that sends the code to a place that doesn't include the
"turn on" step).
The problem I'm having is that sometimes access just saves a form or other
object when I close it and doesn't give me the option of discarding the
design changes that were made by asking me to save or cancel. Other times it
works just fine. I haven't found out what causes it.
I'm also having an issue when I try to export from my design db to the live
data if someone is using the live data db when I export. Usually it will
tell me that someone is using the database and design changes can't be saved.
But sometimes it just returns without giving any messages. When I go into
the live data to test the changes, they have not been exported from the test
db.
Neither of the below solutions apply to my situation. I have searched all
the code in my project and there is not a docmd.setwarnings false anywhere.
I checked the settings in Tools | Options | Edit/Find they are all checked to
confirm
Is there another possible solution?
The solution posted to solve this similar issue is the following
Two possiblities:
One: you have deselected the "Confirm" checkboxes in Tools | Options |
Edit/Find. To fix, reselect these items.
Two: you have run VBA code that turned off the warnings and you didn't turn
them back on.
DoCmd.SetWarnings False
' do some code here
DoCmd.SetWarnings True
To fix "two", go to Immediate Window and type
DoCmd.SetWarnings True
and hit Enter.
To not have "two" return, search your code for places where the warnings are
turned off, and the "turn on" step can be bypassed (often occurs if you have
an error handler that sends the code to a place that doesn't include the
"turn on" step).