Menu
  • HOME
  • TAGS

Dynamically create Datasheet from SQL query with VBA in Ms Office Access

vba,ms-access,adp,access-data-project

This doesn't seems efficient, but it is working and a bit satisfactory: DoCmd.RunSQL "IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS " & _ "WHERE TABLE_NAME = 'tv') DROP VIEW tv" DoCmd.RunSQL "create view tv as " & txtQry DoCmd.OpenView "tv" Here I am creating a temporary VIEW (tv) in a button's...

How do linked tables in MS Acces works?

vba,ms-access,linked-tables,adp

Linked tables are similar to local tables but their source is not within the local access database. You might Link an Excel sheet as linked table MSSQL as linked table MySQL as linked table (ODBC connection) and so on.. after linking, the tables become standard table like any other tables...