From Access 2000 to Access 2003

[KS]

My well performing queries in Access 2000 for my
comboboxes is bringeing up the parameter box in Access
2002 !

Why ?

KS,Denamrk

 

[Ken Snell]

Could you tell us a bit more info? Such as posting one or two of the SQL
statements? That will help us try to help you.

 

[Guest]

Here is one sample SQL:

SELECT [SAGER].[Sagsnr], [SAGER].[Sagsnavn] FROM SAGER
WHERE ((([SAGER].[Sagsnavn])<>"Ledigt sagsnr") And
(([SAGER].[Kundenr])=Formularer![F PLANER Vedligehold af
EEN planpost]!cboKunde)) ORDER BY [SAGER].[Sagsnavn];

NOTE that it's a DANISH access 2000 !

KS, Denmark

 

[Ken Snell]

SQL syntax appears to be ok. I assume that you're getting a parameter box
for the Formularer![F PLANER Vedligehold af EEN planpost]!cboKunde
parameter?

If yes, check spelling of words; and is the F PLANER Vedligehold af EEN
planpost form open when the query runs?

--
Ken Snell
<MS ACCESS MVP>

Here is one sample SQL:

SELECT [SAGER].[Sagsnr], [SAGER].[Sagsnavn] FROM SAGER
WHERE ((([SAGER].[Sagsnavn])<>"Ledigt sagsnr") And
(([SAGER].[Kundenr])=Formularer![F PLANER Vedligehold af
EEN planpost]!cboKunde)) ORDER BY [SAGER].[Sagsnavn];

NOTE that it's a DANISH access 2000 !

KS, Denmark

-----Original Message-----
Could you tell us a bit more info? Such as posting one or two of the SQL
statements? That will help us try to help you.

--
Ken Snell
<MS ACCESS MVP>




.

 

[KS]

Thanks for your answers !

The application IS working well in W2K/Access2K so I think
there is no spelling wrong - the form is open befire the
query is run because it's a query for a combobox on the
form.

What is wrong when updating from W2K/Off2K to W-XP/Off2K
or W-XP/Off-2002.

I have tried both combinations - I can't get it !

KS,Denmark

-----Original Message-----
SQL syntax appears to be ok. I assume that you're getting a parameter box
for the Formularer![F PLANER Vedligehold af EEN planpost]! cboKunde
parameter?

If yes, check spelling of words; and is the F PLANER Vedligehold af EEN
planpost form open when the query runs?

--
Ken Snell
<MS ACCESS MVP>

Here is one sample SQL:

SELECT [SAGER].[Sagsnr], [SAGER].[Sagsnavn] FROM SAGER
WHERE ((([SAGER].[Sagsnavn])<>"Ledigt sagsnr") And
(([SAGER].[Kundenr])=Formularer![F PLANER Vedligehold af
EEN planpost]!cboKunde)) ORDER BY [SAGER].[Sagsnavn];

NOTE that it's a DANISH access 2000 !

KS, Denmark

-----Original Message-----
Could you tell us a bit more info? Such as posting one

or
two of the SQL

statements? That will help us try to help you.

--
Ken Snell
<MS ACCESS MVP>

My well performing queries in Access 2000 for my
comboboxes is bringeing up the parameter box in Access
2002 !

Why ?

KS,Denamrk



.

.

 

[Ken Snell]

I don't know what else might be wrong, unless somehow the form or the query
has become corrupted. Try rebuilding one or both.

I'd offer to take a look at it, but I don't think my US version can "read"
your Swedish version.

--
Ken Snell
<MS ACCESS MVP>

Thanks for your answers !

The application IS working well in W2K/Access2K so I think
there is no spelling wrong - the form is open befire the
query is run because it's a query for a combobox on the
form.

What is wrong when updating from W2K/Off2K to W-XP/Off2K
or W-XP/Off-2002.

I have tried both combinations - I can't get it !

KS,Denmark

-----Original Message-----
SQL syntax appears to be ok. I assume that you're getting a parameter box
for the Formularer![F PLANER Vedligehold af EEN planpost]! cboKunde
parameter?

If yes, check spelling of words; and is the F PLANER Vedligehold af EEN
planpost form open when the query runs?

--
Ken Snell
<MS ACCESS MVP>

Here is one sample SQL:

SELECT [SAGER].[Sagsnr], [SAGER].[Sagsnavn] FROM SAGER
WHERE ((([SAGER].[Sagsnavn])<>"Ledigt sagsnr") And
(([SAGER].[Kundenr])=Formularer![F PLANER Vedligehold af
EEN planpost]!cboKunde)) ORDER BY [SAGER].[Sagsnavn];

NOTE that it's a DANISH access 2000 !

KS, Denmark


-----Original Message-----
Could you tell us a bit more info? Such as posting one or
two of the SQL
statements? That will help us try to help you.

--
Ken Snell
<MS ACCESS MVP>

My well performing queries in Access 2000 for my
comboboxes is bringeing up the parameter box in Access
2002 !

Why ?

KS,Denamrk



.

.