Recent content by John Tompa

Hello I did indeed cut down my db to isolate the problem which did not go away. But I cut it down from the version I had imported. So I started again from scratch. I created a new db & then imported everything with the wizard. I took my time over it, checking as I went along that nothing...

Hello I have tried opening a blank database & copying everything in using the Wizard. And unfortunately the error is still there, completely unchanged. Everything else (well at least the few samples I did) seems to work correctly. Thank you for the idea. I should have tried it sooner but I was...

Hi To answer the serious question first. No I don't modify the query anywhere in the project in the normal run of the mill. It hasn't changed for some time now. And the name is spelled correctly - and anyway even if it weren't why would the query fail in manual mode when the VBA is stopped on...

Hello spikepl Thanks for that. I'm away for a few days & then I'll give it a try. I'll let you know what happens Best John Tompa

Hello vbaInet No, I'm not recreating or modifying the query, only trying to execute it Hello spikepl That's a good idea, making a blank db & copying everything into it - I was hoping to avoid it! I'll have to get some quiet time & do it thank you both Best John

Hello Sorry about that. It read OK on my PC. Hope this is better Hello I have an error message counting records in a query, or opening the query, using vba. The query runs correctly when executed manually when no VBA is running. I’m fairly sure this code ran a year ago as it is a once a...

Hello I have an error message counting records in a query, or opening the query, using vba. The query runs correctly when executed manually when no VBA is running. I’m fairly sure this code ran a year ago as it is a once a year execution. The code is intA = DCount("*", "qryAdh1EmailAppel")...

Thank you for these two suggestions apr pillai. I tried them both & unfortunately neither worked. I followed something else up. After I had posted my question, the system came up with some similar posts. One of them suggested moving to the next record to close & write the current record then to...

I am running Access 2000. I have a form which has an beforeupdate event to set a time stamp: I also have a combo box with a goto a record using the recordsetclone & bookmark. If I change anything in the displayed record, the GoTo combo box errors with the message "Update or CancelUpdate...