Order of parameter prompts Changed-why

[babs]

I just went and Looked behind the design view on the Main query that a Form
was based on - I did not save it or change anything- Not of the actual
parameters are in last step of the main query - they are queries that the
Main ones pulls fields from - all query names stayed the same?? Now the Order
of the 4 different parameters is Reversed??????? any way I can change them
BACK????? or why they changed in 1st place???
thanks,
barb

 

[S.Clark]

In the Query Menu, select Query / Parameters.
(A2007: Design Tab / Parameters)

Explicitly enter the values in the desired order of firing.

 

[babs]

Thanks for helping but when I go to the Parameters nothing is listed since
they are actually prompted by the entering the [Invoicedate], [jobdate] etc,
into the queries themselve that feed into this Master query. when I look at
the design view order if of tables, order of fields are all identical. there
are so many parameter inputs 8 that would prefer not to reAdd - and how would
the master query handle that when already in the other queries that it is
based on???

thanks so much for helping any other ideas -
Barb

 

[KARL DEWEY]

What Clark said was to open the query (not master). Copy the prompt and then
in the Query Menu, select Query / Parameters (A2007: Design Tab / Parameters)
and paste the prompts in the order you want them to be used.

Explicitly enter the values in the desired order of firing.

--
Build a little, test a little.

Thanks for helping but when I go to the Parameters nothing is listed since
they are actually prompted by the entering the [Invoicedate], [jobdate] etc,
into the queries themselve that feed into this Master query. when I look at
the design view order if of tables, order of fields are all identical. there
are so many parameter inputs 8 that would prefer not to reAdd - and how would
the master query handle that when already in the other queries that it is
based on???

thanks so much for helping any other ideas -
Barb

In the Query Menu, select Query / Parameters.
(A2007: Design Tab / Parameters)

Explicitly enter the values in the desired order of firing.

 

[babs]

So if I understand correctly - just copy the prompts and leave them Also in
original locations -

do you know why the prompt order Changed when NOTHING was changed or
saved??? and design view order of fields and tables are identical?????

really would like to know- why this happend?
Thanks,
barb

What Clark said was to open the query (not master). Copy the prompt and then
in the Query Menu, select Query / Parameters (A2007: Design Tab / Parameters)
and paste the prompts in the order you want them to be used.

Explicitly enter the values in the desired order of firing.

--
Build a little, test a little.

Thanks for helping but when I go to the Parameters nothing is listed since
they are actually prompted by the entering the [Invoicedate], [jobdate] etc,
into the queries themselve that feed into this Master query. when I look at
the design view order if of tables, order of fields are all identical. there
are so many parameter inputs 8 that would prefer not to reAdd - and how would
the master query handle that when already in the other queries that it is
based on???

thanks so much for helping any other ideas -
Barb

In the Query Menu, select Query / Parameters.
(A2007: Design Tab / Parameters)

Explicitly enter the values in the desired order of firing.

:

I just went and Looked behind the design view on the Main query that a Form
was based on - I did not save it or change anything- Not of the actual
parameters are in last step of the main query - they are queries that the
Main ones pulls fields from - all query names stayed the same?? Now the Order
of the 4 different parameters is Reversed??????? any way I can change them
BACK????? or why they changed in 1st place???
thanks,
barb

 

[babs]

I tried copy and Pasting from the queries into the Properties of the design
of the Main Query that feeds the form - I can copy but won't let me past the
Prompt Criteria in - When i enter in the parameter Between [Write up Start
Date] and [Write up End Date] - that is not correct
Tried to just type Write up Start Date ( it is a Date/Time data type) not
sure on list what data type it is don't see Date/Time and it is saying Text
is wrong data type.

Again - really would love to know why the Order Changed????

Please help.- very frustrated
Thanks,
Barb

So if I understand correctly - just copy the prompts and leave them Also in
original locations -

do you know why the prompt order Changed when NOTHING was changed or
saved??? and design view order of fields and tables are identical?????

really would like to know- why this happend?
Thanks,
barb

What Clark said was to open the query (not master). Copy the prompt and then
in the Query Menu, select Query / Parameters (A2007: Design Tab / Parameters)
and paste the prompts in the order you want them to be used.

Explicitly enter the values in the desired order of firing.

--
Build a little, test a little.

Thanks for helping but when I go to the Parameters nothing is listed since
they are actually prompted by the entering the [Invoicedate], [jobdate] etc,
into the queries themselve that feed into this Master query. when I look at
the design view order if of tables, order of fields are all identical. there
are so many parameter inputs 8 that would prefer not to reAdd - and how would
the master query handle that when already in the other queries that it is
based on???

thanks so much for helping any other ideas -
Barb

:

In the Query Menu, select Query / Parameters.
(A2007: Design Tab / Parameters)

Explicitly enter the values in the desired order of firing.

:

I just went and Looked behind the design view on the Main query that a Form
was based on - I did not save it or change anything- Not of the actual
parameters are in last step of the main query - they are queries that the
Main ones pulls fields from - all query names stayed the same?? Now the Order
of the 4 different parameters is Reversed??????? any way I can change them
BACK????? or why they changed in 1st place???
thanks,
barb

 

[babs]

Still really want to know why order changed -
But yes - I lost my mind - there is a date and time format
put all paramters prompt in except for last 2 - just fall into place after
other 6 done - is that okay?

and again - do you know why the order of prompt changed????
thanks,
Barb

I tried copy and Pasting from the queries into the Properties of the design
of the Main Query that feeds the form - I can copy but won't let me past the
Prompt Criteria in - When i enter in the parameter Between [Write up Start
Date] and [Write up End Date] - that is not correct
Tried to just type Write up Start Date ( it is a Date/Time data type) not
sure on list what data type it is don't see Date/Time and it is saying Text
is wrong data type.

Again - really would love to know why the Order Changed????

Please help.- very frustrated
Thanks,
Barb

So if I understand correctly - just copy the prompts and leave them Also in
original locations -

do you know why the prompt order Changed when NOTHING was changed or
saved??? and design view order of fields and tables are identical?????

really would like to know- why this happend?
Thanks,
barb

What Clark said was to open the query (not master). Copy the prompt and then
in the Query Menu, select Query / Parameters (A2007: Design Tab / Parameters)
and paste the prompts in the order you want them to be used.

Explicitly enter the values in the desired order of firing.

--
Build a little, test a little.


:

Thanks for helping but when I go to the Parameters nothing is listed since
they are actually prompted by the entering the [Invoicedate], [jobdate] etc,
into the queries themselve that feed into this Master query. when I look at
the design view order if of tables, order of fields are all identical. there
are so many parameter inputs 8 that would prefer not to reAdd - and how would
the master query handle that when already in the other queries that it is
based on???

thanks so much for helping any other ideas -
Barb

:

In the Query Menu, select Query / Parameters.
(A2007: Design Tab / Parameters)

Explicitly enter the values in the desired order of firing.

:

I just went and Looked behind the design view on the Main query that a Form
was based on - I did not save it or change anything- Not of the actual
parameters are in last step of the main query - they are queries that the
Main ones pulls fields from - all query names stayed the same?? Now the Order
of the 4 different parameters is Reversed??????? any way I can change them
BACK????? or why they changed in 1st place???
thanks,
barb

 

[Duane Hookom]

The order might have changed if you changed a sort order or something else in
the query. The Access/JET query engine will attempt to optimize the method a
query is run. This could change.

IMO, you should never use parameter prompts. They are generally poor user
interface and should be replaced by references to controls on forms.

--
Duane Hookom
Microsoft Access MVP

Still really want to know why order changed -
But yes - I lost my mind - there is a date and time format
put all paramters prompt in except for last 2 - just fall into place after
other 6 done - is that okay?

and again - do you know why the order of prompt changed????
thanks,
Barb

I tried copy and Pasting from the queries into the Properties of the design
of the Main Query that feeds the form - I can copy but won't let me past the
Prompt Criteria in - When i enter in the parameter Between [Write up Start
Date] and [Write up End Date] - that is not correct
Tried to just type Write up Start Date ( it is a Date/Time data type) not
sure on list what data type it is don't see Date/Time and it is saying Text
is wrong data type.

Again - really would love to know why the Order Changed????

Please help.- very frustrated
Thanks,
Barb

So if I understand correctly - just copy the prompts and leave them Also in
original locations -

do you know why the prompt order Changed when NOTHING was changed or
saved??? and design view order of fields and tables are identical?????

really would like to know- why this happend?
Thanks,
barb

:

What Clark said was to open the query (not master). Copy the prompt and then
in the Query Menu, select Query / Parameters (A2007: Design Tab / Parameters)
and paste the prompts in the order you want them to be used.

Explicitly enter the values in the desired order of firing.

--
Build a little, test a little.


:

Thanks for helping but when I go to the Parameters nothing is listed since
they are actually prompted by the entering the [Invoicedate], [jobdate] etc,
into the queries themselve that feed into this Master query. when I look at
the design view order if of tables, order of fields are all identical. there
are so many parameter inputs 8 that would prefer not to reAdd - and how would
the master query handle that when already in the other queries that it is
based on???

thanks so much for helping any other ideas -
Barb

:

In the Query Menu, select Query / Parameters.
(A2007: Design Tab / Parameters)

Explicitly enter the values in the desired order of firing.

:

I just went and Looked behind the design view on the Main query that a Form
was based on - I did not save it or change anything- Not of the actual
parameters are in last step of the main query - they are queries that the
Main ones pulls fields from - all query names stayed the same?? Now the Order
of the 4 different parameters is Reversed??????? any way I can change them
BACK????? or why they changed in 1st place???
thanks,
barb

 

[babs]

I did mess with a sort - wow!

Not clear on the best way to ask user for Beginning and ending dates.

I have also put them in the criteria row of a query that the form or report
will be based off of. so if create more forms or reports Prompt will come up

example for Invoicedate field

put in criteria row Between [Enter beginning Invoice Date] and [Enter
Ending Invoice Date]

thought this was good because it ties it to the specific Field Invoicedate??

Since my order that user was used to got messed up - not sure what to do
so went to desing view of Main query that feeds the Form and put in the
Parameters in Old order there????

What is your suggest way to do it - something different that either - not
sure of what you are saying about ?references to controls on forms?

I know you have Great input so would really like the appropriate way??

thanks,
barb

The order might have changed if you changed a sort order or something else in
the query. The Access/JET query engine will attempt to optimize the method a
query is run. This could change.

IMO, you should never use parameter prompts. They are generally poor user
interface and should be replaced by references to controls on forms.

--
Duane Hookom
Microsoft Access MVP

Still really want to know why order changed -
But yes - I lost my mind - there is a date and time format
put all paramters prompt in except for last 2 - just fall into place after
other 6 done - is that okay?

and again - do you know why the order of prompt changed????
thanks,
Barb

I tried copy and Pasting from the queries into the Properties of the design
of the Main Query that feeds the form - I can copy but won't let me past the
Prompt Criteria in - When i enter in the parameter Between [Write up Start
Date] and [Write up End Date] - that is not correct
Tried to just type Write up Start Date ( it is a Date/Time data type) not
sure on list what data type it is don't see Date/Time and it is saying Text
is wrong data type.

Again - really would love to know why the Order Changed????

Please help.- very frustrated
Thanks,
Barb

:

So if I understand correctly - just copy the prompts and leave them Also in
original locations -

do you know why the prompt order Changed when NOTHING was changed or
saved??? and design view order of fields and tables are identical?????

really would like to know- why this happend?
Thanks,
barb

:

What Clark said was to open the query (not master). Copy the prompt and then
in the Query Menu, select Query / Parameters (A2007: Design Tab / Parameters)
and paste the prompts in the order you want them to be used.

Explicitly enter the values in the desired order of firing.

--
Build a little, test a little.


:

Thanks for helping but when I go to the Parameters nothing is listed since
they are actually prompted by the entering the [Invoicedate], [jobdate] etc,
into the queries themselve that feed into this Master query. when I look at
the design view order if of tables, order of fields are all identical. there
are so many parameter inputs 8 that would prefer not to reAdd - and how would
the master query handle that when already in the other queries that it is
based on???

thanks so much for helping any other ideas -
Barb

:

In the Query Menu, select Query / Parameters.
(A2007: Design Tab / Parameters)

Explicitly enter the values in the desired order of firing.

:

I just went and Looked behind the design view on the Main query that a Form
was based on - I did not save it or change anything- Not of the actual
parameters are in last step of the main query - they are queries that the
Main ones pulls fields from - all query names stayed the same?? Now the Order
of the 4 different parameters is Reversed??????? any way I can change them
BACK????? or why they changed in 1st place???
thanks,
barb

 

[Duane Hookom]

Your users should have a form with a couple text boxes that they can enter
the beginning and ending dates into. Then the query can have a criteria like:

Between Forms!frmDates!txtStartDate And Forms!frmDates!txtEndDate

Check out this link: http://www.tek-tips.com/faqs.cfm?fid=6763

--
Duane Hookom
Microsoft Access MVP

I did mess with a sort - wow!

Not clear on the best way to ask user for Beginning and ending dates.

I have also put them in the criteria row of a query that the form or report
will be based off of. so if create more forms or reports Prompt will come up

example for Invoicedate field

put in criteria row Between [Enter beginning Invoice Date] and [Enter
Ending Invoice Date]

thought this was good because it ties it to the specific Field Invoicedate??

Since my order that user was used to got messed up - not sure what to do
so went to desing view of Main query that feeds the Form and put in the
Parameters in Old order there????

What is your suggest way to do it - something different that either - not
sure of what you are saying about ?references to controls on forms?

I know you have Great input so would really like the appropriate way??

thanks,
barb

The order might have changed if you changed a sort order or something else in
the query. The Access/JET query engine will attempt to optimize the method a
query is run. This could change.

IMO, you should never use parameter prompts. They are generally poor user
interface and should be replaced by references to controls on forms.

--
Duane Hookom
Microsoft Access MVP

Still really want to know why order changed -
But yes - I lost my mind - there is a date and time format
put all paramters prompt in except for last 2 - just fall into place after
other 6 done - is that okay?

and again - do you know why the order of prompt changed????
thanks,
Barb

:

I tried copy and Pasting from the queries into the Properties of the design
of the Main Query that feeds the form - I can copy but won't let me past the
Prompt Criteria in - When i enter in the parameter Between [Write up Start
Date] and [Write up End Date] - that is not correct
Tried to just type Write up Start Date ( it is a Date/Time data type) not
sure on list what data type it is don't see Date/Time and it is saying Text
is wrong data type.

Again - really would love to know why the Order Changed????

Please help.- very frustrated
Thanks,
Barb

:

So if I understand correctly - just copy the prompts and leave them Also in
original locations -

do you know why the prompt order Changed when NOTHING was changed or
saved??? and design view order of fields and tables are identical?????

really would like to know- why this happend?
Thanks,
barb

:

What Clark said was to open the query (not master). Copy the prompt and then
in the Query Menu, select Query / Parameters (A2007: Design Tab / Parameters)
and paste the prompts in the order you want them to be used.

Explicitly enter the values in the desired order of firing.

--
Build a little, test a little.


:

Thanks for helping but when I go to the Parameters nothing is listed since
they are actually prompted by the entering the [Invoicedate], [jobdate] etc,
into the queries themselve that feed into this Master query. when I look at
the design view order if of tables, order of fields are all identical. there
are so many parameter inputs 8 that would prefer not to reAdd - and how would
the master query handle that when already in the other queries that it is
based on???

thanks so much for helping any other ideas -
Barb

:

In the Query Menu, select Query / Parameters.
(A2007: Design Tab / Parameters)

Explicitly enter the values in the desired order of firing.

:

I just went and Looked behind the design view on the Main query that a Form
was based on - I did not save it or change anything- Not of the actual
parameters are in last step of the main query - they are queries that the
Main ones pulls fields from - all query names stayed the same?? Now the Order
of the 4 different parameters is Reversed??????? any way I can change them
BACK????? or why they changed in 1st place???
thanks,
barb