From Access 2000 to Access 2003

  • Thread starter Thread starter KS
  • Start date Start date
K

KS

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

Why ?

KS,Denamrk
 
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.
 
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
 
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>




.
Click to expand...
Click to expand...
 
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
Click to expand...
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



.
Click to expand...
Click to expand...


.
Click to expand...
 
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>


KS said:
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



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top