create Temporary Table - ADO DAO RDO RDS

A temporary table isn't really necessary. Just filter your query based on
the the value on the form that has the date.
--
Dave Hargis, Microsoft Access MVP


"Jazz57" wrote:

> Good afternoon to all
>
> i have a form where i show records from a Query file that have been filtered
> with a dialog box form (those records are filtered by date)
>
> i want to create a temporary table in order to copy all the records i have
> in my form to that temporary table (TblTemporary) .
>
> After that i will create a query of that temporary table and then transfer
> that Query to my Excel file.
>
>
> Can anybody help me?
>
> Thanks in advance
>
>
> --
> Adriano Santos
>

good afternoon and thanks for your reply

How can i do it , i.e. filtering the data from my form?

The data that is on that form is allready filtered. so, i think i have less
work to do.

Can you give me a hand on it?

Thanks in advance
--
Adriano Santos
Portugal



"Klatuu" escreveu:

> A temporary table isn't really necessary. Just filter your query based on
> the the value on the form that has the date.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Jazz57" wrote:
>
> > Good afternoon to all
> >
> > i have a form where i show records from a Query file that have been filtered
> > with a dialog box form (those records are filtered by date)
> >
> > i want to create a temporary table in order to copy all the records i have
> > in my form to that temporary table (TblTemporary) .
> >
> > After that i will create a query of that temporary table and then transfer
> > that Query to my Excel file.
> >
> >
> > Can anybody help me?
> >
> > Thanks in advance
> >
> >
> > --
> > Adriano Santos
> >

Just use the same filtering in the query that you use in the form. It should
return the same records.
--
Dave Hargis, Microsoft Access MVP


"Jazz57" wrote:

> good afternoon and thanks for your reply
>
> How can i do it , i.e. filtering the data from my form?
>
> The data that is on that form is allready filtered. so, i think i have less
> work to do.
>
> Can you give me a hand on it?
>
> Thanks in advance
> --
> Adriano Santos
> Portugal
>
>
>
> "Klatuu" escreveu:
>
> > A temporary table isn't really necessary. Just filter your query based on
> > the the value on the form that has the date.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Jazz57" wrote:
> >
> > > Good afternoon to all
> > >
> > > i have a form where i show records from a Query file that have been filtered
> > > with a dialog box form (those records are filtered by date)
> > >
> > > i want to create a temporary table in order to copy all the records i have
> > > in my form to that temporary table (TblTemporary) .
> > >
> > > After that i will create a query of that temporary table and then transfer
> > > that Query to my Excel file.
> > >
> > >
> > > Can anybody help me?
> > >
> > > Thanks in advance
> > >
> > >
> > > --
> > > Adriano Santos
> > >

good afternoon

Maybe i didn't quiet clear what you meant.

the form as a Row Source from the Query. As i mentioned i have a form dialog
that is displayed when i open my form. On that dialog i put the start date
and the Final Date. .

So, the form just display the records that were filtered, by parameters,
i.e. is just a view of my records.

in the reality, in my Row Source i have Parameters that filter along with he
rest of the Data.

but, sincerely i am not seeing as i am going to do what do you said.

Please, forgive me my ignorance.

I think i still need aditional help.

Thanks in advance for it



s

--
Adriano Santos
Portugal



"Klatuu" escreveu:

> Just use the same filtering in the query that you use in the form. It should
> return the same records.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Jazz57" wrote:
>
> > good afternoon and thanks for your reply
> >
> > How can i do it , i.e. filtering the data from my form?
> >
> > The data that is on that form is allready filtered. so, i think i have less
> > work to do.
> >
> > Can you give me a hand on it?
> >
> > Thanks in advance
> > --
> > Adriano Santos
> > Portugal
> >
> >
> >
> > "Klatuu" escreveu:
> >
> > > A temporary table isn't really necessary. Just filter your query based on
> > > the the value on the form that has the date.
> > > --
> > > Dave Hargis, Microsoft Access MVP
> > >
> > >
> > > "Jazz57" wrote:
> > >
> > > > Good afternoon to all
> > > >
> > > > i have a form where i show records from a Query file that have been filtered
> > > > with a dialog box form (those records are filtered by date)
> > > >
> > > > i want to create a temporary table in order to copy all the records i have
> > > > in my form to that temporary table (TblTemporary) .
> > > >
> > > > After that i will create a query of that temporary table and then transfer
> > > > that Query to my Excel file.
> > > >
> > > >
> > > > Can anybody help me?
> > > >
> > > > Thanks in advance
> > > >
> > > >
> > > > --
> > > > Adriano Santos
> > > >

Maybe I don't fully understand what you are telling me, but if the query you
are using as the recordsource for the form already has the parameters in it,
you could just use the same query as the record source for the report.
--
Dave Hargis, Microsoft Access MVP


"Jazz57" wrote:

> good afternoon
>
> Maybe i didn't quiet clear what you meant.
>
> the form as a Row Source from the Query. As i mentioned i have a form dialog
> that is displayed when i open my form. On that dialog i put the start date
> and the Final Date. .
>
> So, the form just display the records that were filtered, by parameters,
> i.e. is just a view of my records.
>
> in the reality, in my Row Source i have Parameters that filter along with he
> rest of the Data.
>
> but, sincerely i am not seeing as i am going to do what do you said.
>
> Please, forgive me my ignorance.
>
> I think i still need aditional help.
>
> Thanks in advance for it
>
>
>
> s
>
> --
> Adriano Santos
> Portugal
>
>
>
> "Klatuu" escreveu:
>
> > Just use the same filtering in the query that you use in the form. It should
> > return the same records.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Jazz57" wrote:
> >
> > > good afternoon and thanks for your reply
> > >
> > > How can i do it , i.e. filtering the data from my form?
> > >
> > > The data that is on that form is allready filtered. so, i think i have less
> > > work to do.
> > >
> > > Can you give me a hand on it?
> > >
> > > Thanks in advance
> > > --
> > > Adriano Santos
> > > Portugal
> > >
> > >
> > >
> > > "Klatuu" escreveu:
> > >
> > > > A temporary table isn't really necessary. Just filter your query based on
> > > > the the value on the form that has the date.
> > > > --
> > > > Dave Hargis, Microsoft Access MVP
> > > >
> > > >
> > > > "Jazz57" wrote:
> > > >
> > > > > Good afternoon to all
> > > > >
> > > > > i have a form where i show records from a Query file that have been filtered
> > > > > with a dialog box form (those records are filtered by date)
> > > > >
> > > > > i want to create a temporary table in order to copy all the records i have
> > > > > in my form to that temporary table (TblTemporary) .
> > > > >
> > > > > After that i will create a query of that temporary table and then transfer
> > > > > that Query to my Excel file.
> > > > >
> > > > >
> > > > > Can anybody help me?
> > > > >
> > > > > Thanks in advance
> > > > >
> > > > >
> > > > > --
> > > > > Adriano Santos
> > > > >

hi again.

I am not shure that the Query has the parameters but i am going to check and
answer again on this Question.

When you mean Parameters do you mean something like that
PARAMETERS .........;
SELECT Field A, Field B , Field C.... From QDados;

In this issue, i guarantee that he has the PARMETERS, because those
PArameters appear from the dialog form that i have when i open the form
After it i have the recordsource (the other fields) from the Query.

Once again, thanks for your help.

Bets regards

--
Adriano Santos
Portugal



"Klatuu" escreveu:

> Maybe I don't fully understand what you are telling me, but if the query you
> are using as the recordsource for the form already has the parameters in it,
> you could just use the same query as the record source for the report.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Jazz57" wrote:
>
> > good afternoon
> >
> > Maybe i didn't quiet clear what you meant.
> >
> > the form as a Row Source from the Query. As i mentioned i have a form dialog
> > that is displayed when i open my form. On that dialog i put the start date
> > and the Final Date. .
> >
> > So, the form just display the records that were filtered, by parameters,
> > i.e. is just a view of my records.
> >
> > in the reality, in my Row Source i have Parameters that filter along with he
> > rest of the Data.
> >
> > but, sincerely i am not seeing as i am going to do what do you said.
> >
> > Please, forgive me my ignorance.
> >
> > I think i still need aditional help.
> >
> > Thanks in advance for it
> >
> >
> >
> > s
> >
> > --
> > Adriano Santos
> > Portugal
> >
> >
> >
> > "Klatuu" escreveu:
> >
> > > Just use the same filtering in the query that you use in the form. It should
> > > return the same records.
> > > --
> > > Dave Hargis, Microsoft Access MVP
> > >
> > >
> > > "Jazz57" wrote:
> > >
> > > > good afternoon and thanks for your reply
> > > >
> > > > How can i do it , i.e. filtering the data from my form?
> > > >
> > > > The data that is on that form is allready filtered. so, i think i have less
> > > > work to do.
> > > >
> > > > Can you give me a hand on it?
> > > >
> > > > Thanks in advance
> > > > --
> > > > Adriano Santos
> > > > Portugal
> > > >
> > > >
> > > >
> > > > "Klatuu" escreveu:
> > > >
> > > > > A temporary table isn't really necessary. Just filter your query based on
> > > > > the the value on the form that has the date.
> > > > > --
> > > > > Dave Hargis, Microsoft Access MVP
> > > > >
> > > > >
> > > > > "Jazz57" wrote:
> > > > >
> > > > > > Good afternoon to all
> > > > > >
> > > > > > i have a form where i show records from a Query file that have been filtered
> > > > > > with a dialog box form (those records are filtered by date)
> > > > > >
> > > > > > i want to create a temporary table in order to copy all the records i have
> > > > > > in my form to that temporary table (TblTemporary) .
> > > > > >
> > > > > > After that i will create a query of that temporary table and then transfer
> > > > > > that Query to my Excel file.
> > > > > >
> > > > > >
> > > > > > Can anybody help me?
> > > > > >
> > > > > > Thanks in advance
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Adriano Santos
> > > > > >

Parameters to a query are references to external objects. For example:

SELECT * FROM MyTable WHERE [MyTable]![SomeField] = 'Bozo'
is not a paremeter query, but
SELECT * FROM MyTable WHERE [MyTable]![SomeField] = Forms!SomeForm!SomeControl
is a parameter query. It is referencing a value that can chage for each
execution.
--
Dave Hargis, Microsoft Access MVP


"Jazz57" wrote:

> hi again.
>
> I am not shure that the Query has the parameters but i am going to check and
> answer again on this Question.
>
> When you mean Parameters do you mean something like that
> PARAMETERS .........;
> SELECT Field A, Field B , Field C.... From QDados;
>
> In this issue, i guarantee that he has the PARMETERS, because those
> PArameters appear from the dialog form that i have when i open the form
> After it i have the recordsource (the other fields) from the Query.
>
> Once again, thanks for your help.
>
> Bets regards
>
> --
> Adriano Santos
> Portugal
>
>
>
> "Klatuu" escreveu:
>
> > Maybe I don't fully understand what you are telling me, but if the query you
> > are using as the recordsource for the form already has the parameters in it,
> > you could just use the same query as the record source for the report.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Jazz57" wrote:
> >
> > > good afternoon
> > >
> > > Maybe i didn't quiet clear what you meant.
> > >
> > > the form as a Row Source from the Query. As i mentioned i have a form dialog
> > > that is displayed when i open my form. On that dialog i put the start date
> > > and the Final Date. .
> > >
> > > So, the form just display the records that were filtered, by parameters,
> > > i.e. is just a view of my records.
> > >
> > > in the reality, in my Row Source i have Parameters that filter along with he
> > > rest of the Data.
> > >
> > > but, sincerely i am not seeing as i am going to do what do you said.
> > >
> > > Please, forgive me my ignorance.
> > >
> > > I think i still need aditional help.
> > >
> > > Thanks in advance for it
> > >
> > >
> > >
> > > s
> > >
> > > --
> > > Adriano Santos
> > > Portugal
> > >
> > >
> > >
> > > "Klatuu" escreveu:
> > >
> > > > Just use the same filtering in the query that you use in the form. It should
> > > > return the same records.
> > > > --
> > > > Dave Hargis, Microsoft Access MVP
> > > >
> > > >
> > > > "Jazz57" wrote:
> > > >
> > > > > good afternoon and thanks for your reply
> > > > >
> > > > > How can i do it , i.e. filtering the data from my form?
> > > > >
> > > > > The data that is on that form is allready filtered. so, i think i have less
> > > > > work to do.
> > > > >
> > > > > Can you give me a hand on it?
> > > > >
> > > > > Thanks in advance
> > > > > --
> > > > > Adriano Santos
> > > > > Portugal
> > > > >
> > > > >
> > > > >
> > > > > "Klatuu" escreveu:
> > > > >
> > > > > > A temporary table isn't really necessary. Just filter your query based on
> > > > > > the the value on the form that has the date.
> > > > > > --
> > > > > > Dave Hargis, Microsoft Access MVP
> > > > > >
> > > > > >
> > > > > > "Jazz57" wrote:
> > > > > >
> > > > > > > Good afternoon to all
> > > > > > >
> > > > > > > i have a form where i show records from a Query file that have been filtered
> > > > > > > with a dialog box form (those records are filtered by date)
> > > > > > >
> > > > > > > i want to create a temporary table in order to copy all the records i have
> > > > > > > in my form to that temporary table (TblTemporary) .
> > > > > > >
> > > > > > > After that i will create a query of that temporary table and then transfer
> > > > > > > that Query to my Excel file.
> > > > > > >
> > > > > > >
> > > > > > > Can anybody help me?
> > > > > > >
> > > > > > > Thanks in advance
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > Adriano Santos
> > > > > > >

hi again

In this case , the Query has Parameters like you said.

Waiting for your help

Best regards
--
Adriano Santos
Portugal



"Klatuu" escreveu:

> Parameters to a query are references to external objects. For example:
>
> SELECT * FROM MyTable WHERE [MyTable]![SomeField] = 'Bozo'
> is not a paremeter query, but
> SELECT * FROM MyTable WHERE [MyTable]![SomeField] = Forms!SomeForm!SomeControl
> is a parameter query. It is referencing a value that can chage for each
> execution.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Jazz57" wrote:
>
> > hi again.
> >
> > I am not shure that the Query has the parameters but i am going to check and
> > answer again on this Question.
> >
> > When you mean Parameters do you mean something like that
> > PARAMETERS .........;
> > SELECT Field A, Field B , Field C.... From QDados;
> >
> > In this issue, i guarantee that he has the PARMETERS, because those
> > PArameters appear from the dialog form that i have when i open the form
> > After it i have the recordsource (the other fields) from the Query.
> >
> > Once again, thanks for your help.
> >
> > Bets regards
> >
> > --
> > Adriano Santos
> > Portugal
> >
> >
> >
> > "Klatuu" escreveu:
> >
> > > Maybe I don't fully understand what you are telling me, but if the query you
> > > are using as the recordsource for the form already has the parameters in it,
> > > you could just use the same query as the record source for the report.
> > > --
> > > Dave Hargis, Microsoft Access MVP
> > >
> > >
> > > "Jazz57" wrote:
> > >
> > > > good afternoon
> > > >
> > > > Maybe i didn't quiet clear what you meant.
> > > >
> > > > the form as a Row Source from the Query. As i mentioned i have a form dialog
> > > > that is displayed when i open my form. On that dialog i put the start date
> > > > and the Final Date. .
> > > >
> > > > So, the form just display the records that were filtered, by parameters,
> > > > i.e. is just a view of my records.
> > > >
> > > > in the reality, in my Row Source i have Parameters that filter along with he
> > > > rest of the Data.
> > > >
> > > > but, sincerely i am not seeing as i am going to do what do you said.
> > > >
> > > > Please, forgive me my ignorance.
> > > >
> > > > I think i still need aditional help.
> > > >
> > > > Thanks in advance for it
> > > >
> > > >
> > > >
> > > > s
> > > >
> > > > --
> > > > Adriano Santos
> > > > Portugal
> > > >
> > > >
> > > >
> > > > "Klatuu" escreveu:
> > > >
> > > > > Just use the same filtering in the query that you use in the form. It should
> > > > > return the same records.
> > > > > --
> > > > > Dave Hargis, Microsoft Access MVP
> > > > >
> > > > >
> > > > > "Jazz57" wrote:
> > > > >
> > > > > > good afternoon and thanks for your reply
> > > > > >
> > > > > > How can i do it , i.e. filtering the data from my form?
> > > > > >
> > > > > > The data that is on that form is allready filtered. so, i think i have less
> > > > > > work to do.
> > > > > >
> > > > > > Can you give me a hand on it?
> > > > > >
> > > > > > Thanks in advance
> > > > > > --
> > > > > > Adriano Santos
> > > > > > Portugal
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Klatuu" escreveu:
> > > > > >
> > > > > > > A temporary table isn't really necessary. Just filter your query based on
> > > > > > > the the value on the form that has the date.
> > > > > > > --
> > > > > > > Dave Hargis, Microsoft Access MVP
> > > > > > >
> > > > > > >
> > > > > > > "Jazz57" wrote:
> > > > > > >
> > > > > > > > Good afternoon to all
> > > > > > > >
> > > > > > > > i have a form where i show records from a Query file that have been filtered
> > > > > > > > with a dialog box form (those records are filtered by date)
> > > > > > > >
> > > > > > > > i want to create a temporary table in order to copy all the records i have
> > > > > > > > in my form to that temporary table (TblTemporary) .
> > > > > > > >
> > > > > > > > After that i will create a query of that temporary table and then transfer
> > > > > > > > that Query to my Excel file.
> > > > > > > >
> > > > > > > >
> > > > > > > > Can anybody help me?
> > > > > > > >
> > > > > > > > Thanks in advance
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > Adriano Santos
> > > > > > > >

Okay, can you restate your question, I am a little lost
--
Dave Hargis, Microsoft Access MVP


"Jazz57" wrote:

> hi again
>
> In this case , the Query has Parameters like you said.
>
> Waiting for your help
>
> Best regards
> --
> Adriano Santos
> Portugal
>
>
>
> "Klatuu" escreveu:
>
> > Parameters to a query are references to external objects. For example:
> >
> > SELECT * FROM MyTable WHERE [MyTable]![SomeField] = 'Bozo'
> > is not a paremeter query, but
> > SELECT * FROM MyTable WHERE [MyTable]![SomeField] = Forms!SomeForm!SomeControl
> > is a parameter query. It is referencing a value that can chage for each
> > execution.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Jazz57" wrote:
> >
> > > hi again.
> > >
> > > I am not shure that the Query has the parameters but i am going to check and
> > > answer again on this Question.
> > >
> > > When you mean Parameters do you mean something like that
> > > PARAMETERS .........;
> > > SELECT Field A, Field B , Field C.... From QDados;
> > >
> > > In this issue, i guarantee that he has the PARMETERS, because those
> > > PArameters appear from the dialog form that i have when i open the form
> > > After it i have the recordsource (the other fields) from the Query.
> > >
> > > Once again, thanks for your help.
> > >
> > > Bets regards
> > >
> > > --
> > > Adriano Santos
> > > Portugal
> > >
> > >
> > >
> > > "Klatuu" escreveu:
> > >
> > > > Maybe I don't fully understand what you are telling me, but if the query you
> > > > are using as the recordsource for the form already has the parameters in it,
> > > > you could just use the same query as the record source for the report.
> > > > --
> > > > Dave Hargis, Microsoft Access MVP
> > > >
> > > >
> > > > "Jazz57" wrote:
> > > >
> > > > > good afternoon
> > > > >
> > > > > Maybe i didn't quiet clear what you meant.
> > > > >
> > > > > the form as a Row Source from the Query. As i mentioned i have a form dialog
> > > > > that is displayed when i open my form. On that dialog i put the start date
> > > > > and the Final Date. .
> > > > >
> > > > > So, the form just display the records that were filtered, by parameters,
> > > > > i.e. is just a view of my records.
> > > > >
> > > > > in the reality, in my Row Source i have Parameters that filter along with he
> > > > > rest of the Data.
> > > > >
> > > > > but, sincerely i am not seeing as i am going to do what do you said.
> > > > >
> > > > > Please, forgive me my ignorance.
> > > > >
> > > > > I think i still need aditional help.
> > > > >
> > > > > Thanks in advance for it
> > > > >
> > > > >
> > > > >
> > > > > s
> > > > >
> > > > > --
> > > > > Adriano Santos
> > > > > Portugal
> > > > >
> > > > >
> > > > >
> > > > > "Klatuu" escreveu:
> > > > >
> > > > > > Just use the same filtering in the query that you use in the form. It should
> > > > > > return the same records.
> > > > > > --
> > > > > > Dave Hargis, Microsoft Access MVP
> > > > > >
> > > > > >
> > > > > > "Jazz57" wrote:
> > > > > >
> > > > > > > good afternoon and thanks for your reply
> > > > > > >
> > > > > > > How can i do it , i.e. filtering the data from my form?
> > > > > > >
> > > > > > > The data that is on that form is allready filtered. so, i think i have less
> > > > > > > work to do.
> > > > > > >
> > > > > > > Can you give me a hand on it?
> > > > > > >
> > > > > > > Thanks in advance
> > > > > > > --
> > > > > > > Adriano Santos
> > > > > > > Portugal
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Klatuu" escreveu:
> > > > > > >
> > > > > > > > A temporary table isn't really necessary. Just filter your query based on
> > > > > > > > the the value on the form that has the date.
> > > > > > > > --
> > > > > > > > Dave Hargis, Microsoft Access MVP
> > > > > > > >
> > > > > > > >
> > > > > > > > "Jazz57" wrote:
> > > > > > > >
> > > > > > > > > Good afternoon to all
> > > > > > > > >
> > > > > > > > > i have a form where i show records from a Query file that have been filtered
> > > > > > > > > with a dialog box form (those records are filtered by date)
> > > > > > > > >
> > > > > > > > > i want to create a temporary table in order to copy all the records i have
> > > > > > > > > in my form to that temporary table (TblTemporary) .
> > > > > > > > >
> > > > > > > > > After that i will create a query of that temporary table and then transfer
> > > > > > > > > that Query to my Excel file.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Can anybody help me?
> > > > > > > > >
> > > > > > > > > Thanks in advance
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > Adriano Santos
> > > > > > > > >