Save MS Access form results

[kcgonz]

How do I save the results of an MS Access form? I have a search
screen that opens a results form filtering items based on the search
screen. I would like to save the results in a new table. I couldn't
find any docmds to do this. Anybody have any ideas? Please note that
the embedded query on the results form includes 3 linked tables.

 

[scubadiver]

What you can do is have a method such as a combo box for finding results
that can act as a filter for make-table query

--
http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org

 

[Keith Wilby]

How do I save the results of an MS Access form? I have a search
screen that opens a results form filtering items based on the search
screen. I would like to save the results in a new table. I couldn't
find any docmds to do this. Anybody have any ideas? Please note that
the embedded query on the results form includes 3 linked tables.

Why would you want to do this? What is your ultimate goal? Storing the
same data twice is a major no-no.

Keith.
www.keithwilby.com

 

[Klatuu]

Keith is correct. There is absolutely no reason to do this. If you can
describe what you are wanting to do, I am sure we can help find a better way.

 

[kcgonz]

Keith is correct. There is absolutely no reason to do this. If you can
describe what you are wanting to do, I am sure we can help find a better way.
--
Dave Hargis, MicrosoftAccessMVP





- Show quoted text -

Thanks to all who replied... I definitely agree that recreating a
table with the same info is not good programming but here is my
dilemma. I have 3 tables (entity table, study table and transaction
table). I currently have them linked as 1 is to many i.e. entity -->
study; entity --> transaction. As mentioned earlier, I have a search
form that opens my results form based on the search criteria. The
search results has VB codes using strwhere commands. The problem is
whenever my criteria in the search form includes a field from
transaction or study, I obviously get multiple entities. In other
words I would like my results to be unique entities. I have tried
using SQL distinct and distincrow within the results form and yet
there are dupes. I have also tried setting the forms properties to be
unique but that doesn't help either. So, I figured that if I am able
to save the results of the form as a table and create a query using
that table and grouping via entity id--I should be able to achieve my
goal...so any help is more than appreciated. Thanks again to all.

 

[Klatuu]

Since a query can use a query, why not base the last query on the query you
use to create the table? That is, instead of a make table query, make it a
select query, then use that as the source for the query that filters for the
final results?

I know you said you are creating criteria in code, but that is not an issue.
You can modify a stored query programmatically, if necessary.

 

[kcgonz]

Since a query can use a query, why not base the last query on the query you
use to create the table? That is, instead of a make table query, make it a
select query, then use that as the source for the query that filters for the
finalresults?

I've tried this as well but the issue I have is I am unable to produce
correct results when I do the query. When I have more than 2
criterias in the query (eg. forms!results!entitytype), such that some
of the fields are emply it doesn't give me the correct results.
Please note that I have about 10 criteria fields on my seach form.
There must be a way to do this correctly, ideas?

I know you said you are creating criteria in code, but that is not an issue.
You can modify a stored query programmatically, if necessary.

How do I create a query in my search code so that it knows to include
the search criteria fields selected by the user? Don't know VB that
well but I may be able to wing it.

 

[Klatuu]

Is your original query returning the correct results?
If it is, the criteria of the new query that calls your existing query may
or may not need the same criteria. You may need to do some experimenting to
get it like it needs to be.

If you are having difficulty with the queries, you may want to post the SQL
of your queries and a question in the Queries room of this newsgroup.