Queries / Forms - Don't open on double click

[Survane]

I have been trying to open several queries in my db and they do nothing when I click on them. When they do open and I check them, the SQL syntax is correct and there appear to be no errors. Some of them are recordsets for forms which don't open as well.

Does anyone have any suggestions?

Thanks,
Survane

 

[TrojanRabbit]

This probably won't help, but it's an idea. Check Options in Tools. Check click behavior. Also check open mode under Advanced. Click behavior forces you to have one choice selected, so that couldn't be it. I would think that exclusive open mode would give an error. Are you getting any errors, or is it just sitting there as if you didn't click at all?

 

[Survane]

They're just sitting there as if I didn't click them.

 

[Survane]

I have also changed my settings from Double to Single click and back. But they still sit there.

 

[oharab]

Do they run if you click open in the menu bar? ----------------------------------
Ben O'Hara
bo104@westyorkshire.pnn.police.uk
----------------------------------

 

[Survane]

No, they don't. Even if I try to open them in design mode, no response.

 

[oharab]

Don;t like saying this, but it sounds like they are knackered! Try importing them into a fresh database. If that doesn;t work then pray!

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.pnn.police.uk
----------------------------------