Good morning:
I have a Query that is the result of a selection with parameters that came
from a dialog form in order to show the records (check purposes only) and
then with a click button transfer the records to an Excel spreadsheet.
Something like this:
TABLE
|
|
+ -> Query -> dialog Form to filter --> Form show filtered records ->
button to transfer to Excel
Everything went Ok until the button , because if i click the button , it
trasnfers the all records (filtered and not filtered) to my Excel spreadsheet
So, when i saw this i thought in make a new button to create a temporary
file with the filtered records and then transfer it to the Excel.
That's my problem now.
I am sorry to not being well understood. Maybe i can't explain the all
scenario quiet clear.
Please forgive me and thanks for your continuous help.
If you want we can create a new post with another name for this purpose.
hope to hear from you
Best regards
--
Adriano Santos
Portugal
"Klatuu" escreveu:
Okay, can you restate your question, I am a little lost
--
Dave Hargis, Microsoft Access MVP
Jazz57 said:
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
:
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
:
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
:
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
:
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
