Microsoft Query

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
view>cirteria.
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
> view>cirteria.
> 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
> > > >
> > > >
> > > >
> > > >