Recent content by Tazbir

Thanks a lot guys this was really helpful

Thanks a lot, that solved my problem

Hi I have a Access DB which contains four tables that are linked to excel sheets. I also have a query. I would like to start Access from VBA in Excel, and launch the query form there. Unfortunately I cannot run the query using Docmd.RunSql because this is a “SELECT” query. I was thinking about...

Thanks for the link. If I understand corectly I cannot run this query because of the SELECT key word.

Hi I'm fairly new to VBA in Access. I want to run a Query using : DoCmd.RunSQL SQL_text However I'm experiencing problems in generating the SQL_text variable. The problem is related to the SQL code. I read some articles about it and I tried to apply that knowledge. Unfortunately, with no...