Search results

Yeah sure: Because of the performance issues I found re-querying on a split database setup (with the back end on a network server, front end on a local computer), I found that populating a local temporary table with the search criteria from the BE database improved performance considerably for...

Figured out how to populate a temp table and requery that - now network performace isn't an issue.

That's a really useful way to search, but it seems to suffer significant performance issues on a split database over a network with it requerying the database after every change of character to update the list. Is there a way to store the results of a of the query in a temp table...

Thanks for your help John Big Booty, that looks like the sort of thing I was after.

Hi, I'm creating a database for less computer literate people to use - and as part of its functionality the end user needs to collect data via email. Is there a way (using VBA) to automatically send the email based on a table/query without having to use the send email wizard. ie the VBA...