Creating VBA SQL query compared to the QBE

[shabbaranks]

Hi guys,

Something that I have been taking for granted and only today realised - am I correct in thinking when you create a query using the QBE Access creates a temporary table to display the data and if I was to put the same sql code into VBA I would need to create some sort of field all be it a temporary table or list box to display the results of the sql?

Or am I over thinking the process?

Thanks

 

[namliam]

Overthinking....
Data is only stored in tables, queries are executed when ran not before, not after closing...

The big difference though is in 2 parts:
1) QBE query is compiled query, while in VBA it isnt....
The compiling takes about 0.026785676347 seconds (a VERY short time) on a "somewhat decent pc"... But on big complex queries it can make a difference.

2) QBE can be opened and displayed directly into a data grid, VBA queries cannot....
Unless you take the SQL and inject it into a form/query/report... the VBA query (and its data) only exists in memory

 

[shabbaranks]

Thanks you've explained it perfectly to me.