Question Update message not displaying!

[johnyjassi]

Hi Guys,

I have some queries in my database, till yesterday it was working fine but today....when I run any query(make table, update or append) its not displaying any message that how many rows are being updated like it use to ask before any query. I have to check the table whether it has updated the rows or not. Any suggestions?
Your help will be appreciated

Thanks!

 

[pbaldy]

First guess is that somewhere in code or a macro you set warnings to False and never set them back. Do you get the warnings after closing and reopening the database?

 

[johnyjassi]

Hi Paul,

Thanks for your reply, yes it shows some other warning messages like if I create a query that creats a table and try to re-run it.....msg pops up that "Table will be delete......." any other suggestions?

 

[pbaldy]

If you're saying that you will get the warnings when you first open the db but not later, the most likely culprit is the SetWarnings. You might search your code and macros for anyplace where you set them to False and make sure they get set back to True.

 

[johnyjassi]

I have no idea where should i check the set warnings false option, because i don't have any forms. I have just few tables and few queries. do you have any idea where should i check the set warnings false option

 

[pbaldy]

If all you have is tables and queries, then my thought was wrong. The general warnings are set in Tools/Options on the Edit/Find tab (or Access Options if 2007).

 

[johnyjassi]

Hi Paul,

Thanks for replying me back. yes you are right, i did the way you just told me, in tools/options/edit/find the action queries box was not checked.....I check marked it and here you go......all set to go. now it shows msgs on any query i run.

Thanks a lot for your help!

 

[pbaldy]

No problem; sorry I started down the wrong path to begin with.