SYSTEM WARNINGS NOT GENERATED

[desikan]

I am facing a very peculiar problem.

I am using Office 2000 Access on Windows 98.Recetly I saw that no system messages are being generated when duplicates are being entered for example on a primary index field. But when the table was opened again, it was seen that the duplicate records had not been saved.

I checked on Tools---Options but I could not find any abnormal settings.

Thanks in advance for any help towards a solution

 

[jrbarnett]

Hello

Are you getting any other Access messages? If not, try going to
Tools -> Options -> Edit/Find and ensure that ticks are in all the items in the Confirm frame.

John

 

[mkov]

Do you have "DoCmd.SetWarnings False" anywhere in your code? This will also turn off all warnings.

 

[desikan]

I am so sorry folks. My PC gave some trouble soon after I posted the query and I could not log on later.
I am sorry for not responding soon.

I checked in Tools -> Options -> Edit/Find and found that ticks are in the action queries. Also, I find that when any record is deleted, the message is coming correctly. It is only when the user makes a mistake like duplicate entries on a primary index field that no message or prompt is generated but luckily the record is not saved.

Also setwarnings function has not been set to "no" anywhere and in any case I made a duplicate entry directly on the table itself and no message came from the system when I closed the table.

 

[jrbarnett]

Hello

Press Ctrl G to open the debug window, then type in the immediate box at the bottom

DoCmd.SetWarnings TRUE <RETURN>

and see if this fixes the problem.

John

 

[desikan]

Hi John,
I put your code and it has fixed the problem.
Thanks for all the help.