Search results

I am not sure but it seems that TBEH2 & TBEX2 variables in TBEH.RCUComments = (SELECT TBEH2.RCUComments ... statement may be creating some conflict with earlier usage of these vars in TBEH.RCUTargetDate = (SELECT ... It is just a guess, I have not used such type of UPDATE .. SET statement...

Yes! It was time saving. vbaInet and gemma-the-husky, I am glad and grateful for your prompt help. Your advice worked fine and saved time. Thanks a lot for your generousness. regards to both. - PKJ

Ok Fine friend! I thought there must be some Access Object which we can use in code. Anyway, Thanks for bailing out from the drudgery of futile search for this solution. regards - PKJ

Thanks vbaInet, I did save as MS Access-2000/2003 format but it saves all other objects like queries, forms etc. So what I have been doing is to delete all those undesired objects and then save in old format. Isn't there any direct method thru vba code. regards, -PK Joshi

Hi Everybody! I am puzzling over to convert my Access-2007 database-tables (but not other objects) into Access-2000/Access-2003 database. Can somebody guide me! regards, P K Joshi

If your database be Access-2007 - You may locate a bar below the Ribbon showing the message - "certain content in the database has been disabled" and a button besides it giving you option to allow it. I hope it should do if your database location/path has not been declared 'trusted location'...

pbaldy & vbaInet, Thanks Friends for the high quality help you are providing on this forum. Though I am not an expert but I would enjoy learning on this forum. My regards to both of you - PKJ (Jaipur, India)

Many Many Thanks!! Lots of thanks to pbaldy - your advice has worked. Thanks to vbaInet for advice. regards - PKJ

Thanks vbaInet! You have asked - -When you run the query does it show the results? No, error message appears in the design view window. Are the fields in the same order in your tables? Yes, the fields have same name and same order. regards - PKJ

Hi Everyone, The query below shows syntax error in FROM clause in Access-2007 - SELECT * FROM q_StationWiseTR_Final UNION SELECT * FROM q_StnPosted_NotFilled_TR-Form ORDER BY SeniorityLevel, StnName, IfWantTransfer DESC , Remark; -- Both the SELECT * has common/same fields. Access does not...