Microsoft Query
 

following issue, I have created a Query in Excel and need to edit the query,
because I have to change the filter by column to change criteria. it's
working fine on my computer, but when another person tries to edit the query
he gets an errormessage "This query can not be edited by the query wizzard"
and gets directly into MS Query. But I need the Wizzard to make it more
user-friendly. Can anybody help?

thanks in advance!

regards
SB

hi,
are all users using the same version of excel?
You might also think of changing the MSQ to a parameter query where the
query prompts the user for input. to say more i would need to know more
about what your are doing.

regards

FSt1

"SB" wrote:

following issue, I have created a Query in Excel and need to edit the query,
because I have to change the filter by column to change criteria. it's
working fine on my computer, but when another person tries to edit the query
he gets an errormessage "This query can not be edited by the query wizzard"
and gets directly into MS Query. But I need the Wizzard to make it more
user-friendly. Can anybody help?

thanks in advance!

regards
SB

Hi,
yes, we are using the same Excel version (2003).
The query is a link to an external database. We do not need all data from
the database, therefore I have only selected a few fields.
Furthermore, I have limited the amount of data by filtering some item
number. The user should now have the possiblility to change this filter for
another item numbers.

regards
SB

"FSt1" wrote:

hi,
are all users using the same version of excel?
You might also think of changing the MSQ to a parameter query where the
query prompts the user for input. to say more i would need to know more
about what your are doing.

regards

FSt1

"SB" wrote:

following issue, I have created a Query in Excel and need to edit the query,
because I have to change the filter by column to change criteria. it's
working fine on my computer, but when another person tries to edit the query
he gets an errormessage "This query can not be edited by the query wizzard"
and gets directly into MS Query. But I need the Wizzard to make it more
user-friendly. Can anybody help?

thanks in advance!

regards
SB

hi,
you don't need the wizard.
go pass the wizard to the querry itsself. on the query toolbar click
viewcirteria.
a small grid will appear with all of the query fields in it.
In the item number field type [Enter an item number]. save and return to
excel.
each time you refresh the query. it will prompt the user for an item number.
I ususally put a button up on the sheet for the refresh. behind the button i
put this
range("A1").select 'this selects an area inside the query table
selection.querytable.refresh Backgroundquery:=false ' this will refresh the
query

'and prompt the user for item
no wizard needed. and it all take just the click of a button.

regards
FSt1

"SB" wrote:

Hi,
yes, we are using the same Excel version (2003).
The query is a link to an external database. We do not need all data from
the database, therefore I have only selected a few fields.
Furthermore, I have limited the amount of data by filtering some item
number. The user should now have the possiblility to change this filter for
another item numbers.

regards
SB

"FSt1" wrote:

hi,
are all users using the same version of excel?
You might also think of changing the MSQ to a parameter query where the
query prompts the user for input. to say more i would need to know more
about what your are doing.

regards

FSt1

"SB" wrote:

following issue, I have created a Query in Excel and need to edit the query,
because I have to change the filter by column to change criteria. it's
working fine on my computer, but when another person tries to edit the query
he gets an errormessage "This query can not be edited by the query wizzard"
and gets directly into MS Query. But I need the Wizzard to make it more
user-friendly. Can anybody help?

thanks in advance!

regards
SB

ok, thanks! That's a good idea, that will help!

regards
SB

"FSt1" wrote:

hi,
you don't need the wizard.
go pass the wizard to the querry itsself. on the query toolbar click
viewcirteria.
a small grid will appear with all of the query fields in it.
In the item number field type [Enter an item number]. save and return to
excel.
each time you refresh the query. it will prompt the user for an item number.
I ususally put a button up on the sheet for the refresh. behind the button i
put this
range("A1").select 'this selects an area inside the query table
selection.querytable.refresh Backgroundquery:=false ' this will refresh the
query

'and prompt the user for item
no wizard needed. and it all take just the click of a button.

regards
FSt1

"SB" wrote:

Hi,
yes, we are using the same Excel version (2003).
The query is a link to an external database. We do not need all data from
the database, therefore I have only selected a few fields.
Furthermore, I have limited the amount of data by filtering some item
number. The user should now have the possiblility to change this filter for
another item numbers.

regards
SB

"FSt1" wrote:

hi,
are all users using the same version of excel?
You might also think of changing the MSQ to a parameter query where the
query prompts the user for input. to say more i would need to know more
about what your are doing.

regards

FSt1

"SB" wrote:

following issue, I have created a Query in Excel and need to edit the query,
because I have to change the filter by column to change criteria. it's
working fine on my computer, but when another person tries to edit the query
he gets an errormessage "This query can not be edited by the query wizzard"
and gets directly into MS Query. But I need the Wizzard to make it more
user-friendly. Can anybody help?

thanks in advance!

regards
SB