Recent content by trebor1962

Thanks JHB for your reply. I just solved it yesterday. The problem was with a "-" character in the table name used in the OpenQuery call. It was acting very weird but when i took the "-" character out it works fine. Thanks again.

Hello, Could someone please help with this problem i am having with SELECT query in VBA. I created a copy of table A = copyA. Table copyA has all correct data in it. I then reset some fields in original TableA to NULL. All OK. Now when i use the DoCmd.OpenQuery(tmpSQL) in VBA (looking at the...