Place query results into a temporary table

[Guest]

I have built a query which queries one table of data and can be filtered by
users via a form containing several checkboxes (with 'Is Null' statements in
VBA) to represent various pieces of data that is missing.
What I need now is to write the results of each search to a temporary table
(by means of a new command button) so the results in the temp table can be
used as the source records for sending emails so as we can obtain the
'missing' data.

Any suggestions or help would be gratefully appreciated and many thanks in
anticipation.

Best reagrds

Allan

 

[RobFMS]

Allan

On the front-end database, create the temporary table. When you need to use
it, just clear the contents first before populating. This is a better
approach than creating and destroying the table with each use.

HTH

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[Guest]

Hi Rob

Thanks for the quick response. If I create a table how can I populate it
with the results of each search and how can all the contents be deleted
without accessing the table itself?

Sorry if my questions are basic but I only began self-learning Access 5
weeks ago.

Best regards

Allan

 

[Joseph Meehan]

I have built a query which queries one table of data and can be
filtered by users via a form containing several checkboxes (with 'Is
Null' statements in VBA) to represent various pieces of data that is
missing.
What I need now is to write the results of each search to a temporary
table (by means of a new command button) so the results in the temp
table can be used as the source records for sending emails so as we
can obtain the 'missing' data.

Any suggestions or help would be gratefully appreciated and many
thanks in anticipation.

Best reagrds

Allan

I may have missed something, but why not just use the query as the
datasource?

 

[RobFMS]

How to populate:
Look at the SQL syntax for "Insert Into"

How to delete the contents:
Delete From <name of table>

Let me know if you have any further questions.

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[Guest]

Hi Joseph

As I said I only began learning Access 5 weeks ago so I'm not yet fully
aware of all it's capabilities. What I have learned is only via the wizards,
here on the discussion forum and via other sources located on the internet.
I have a sample db for sending emails, which I'm trying to apply to my db,
in the sample the source is from a table filled by users from a form. I am
trying to use the results of a search (also obtained via a sample from the
internet) to use a the source.
If you can expand on your suggestion with some directions on "how-to" then I
would be very grateful.

Best regards

Allan

 

[Joseph Meehan]

Hi Joseph

As I said I only began learning Access 5 weeks ago so I'm not yet
fully aware of all it's capabilities. What I have learned is only via
the wizards, here on the discussion forum and via other sources
located on the internet. I have a sample db for sending emails, which
I'm trying to apply to my db, in the sample the source is from a
table filled by users from a form. I am trying to use the results of
a search (also obtained via a sample from the internet) to use a the
source.
If you can expand on your suggestion with some directions on "how-to"
then I would be very grateful.

My suggestion was very general by necessity. I need a better
understanding of what you are doing and your data to be more specific.

As I understand it you want to display the results of a query. You
could just display the query, or maybe a form based on that query.