Operator i en querydef

Burde virke - hvis KRESRESTBEL er et numerisk felt i tabellen KUNRES

Prøv denne:
Qdf1.SQL = "SELECT KUNRES.* FROM KUNRES WHERE KRESRESTBEL > " & varKRESRESTBEL & ";"

ekspertenATsanthell.dk
AT = @

Sendt den til dit Terry.

Form --> frmInvoice
table --> KUNRES

tabellen er en linked tabell men jeg har kopieret den til tblKUNRES.

Tak :-)

MSchlamovitz - det virker desvärre ikke.

Been out but I'm back now and have received your dB. Will look now :-)

where is the code which gives problem?

This code:

varKRESRESTBEL = 0

Set Qdf1 = CurrentDb.CreateQueryDef("myQ")
Qdf1.SQL = "SELECT KUNRES.* FROM KUNRES WHERE KRESRESTBEL > " & varKRESRESTBEL

You don't need to delete the query, just update SQL

Set Qdf1 = CurrentDb.QueryDefs("myQ")
Qdf1.SQL = "SELECT KUNRES.* FROM KUNRES WHERE KRESRESTBEL > " & varKRESRESTBEL

Instead of using Requery/Refresh use



Me.RecordSource = "myQ"

This forces a requery

Stjerne, stjerne :-)

Tak tak :-)

Jeg er ved, at gå ud af mit skind!!!

Vi have between dato men det virker f***me ikke.

----
varKRESRESTBEL = 0
varDateFrom = Me.txtDateFrom.Value
varDateTo = Me.txtDateTo.Value
   
    Set Qdf1 = CurrentDb.QueryDefs("myQ")
    Qdf1.SQL = "SELECT tblKUNRES.* FROM tblKUNRES WHERE KRESFORFDAT BETWEEN & varDateFrom & AND & VarDateTo &"

-----

Jeg har prövet alle muligheder med ', " & osv tegn. Hvad gör jeg galt.
Får alle mulige forskellige fejl, som syntax error etc.

//frustreret

Set a breakpoint on the line
  Qdf1.SQL = "SELECT ....

Then run the code until you hit the breakpoint.

Now copy and paste the SQL text to the debug window (CTRL+G)
first enter a ? followed by the text
"SELECT tblKUNRES.* FROM tblKUNRES WHERE KRESFORFDAT BETWEEN & varDateFrom & AND & VarDateTo &"

now press Enter.

You should now see the SQL string with all variables converted.

Copy this string to a query and try and run it there.
You will very likely get more information about what is wrong. I suspect it is the date formats

Yopu should also use # before and after dates.

Hmm Don't quite understand what you mean. Should i run this after CTRL+G?

?SELECT tblKUNRES.* FROM tblKUNRES WHERE KRESFORFDAT BETWEEN & varDateFrom & AND & VarDateTo &

It just results in the same line.

I have tried using # before and after the dates. I've even checked the textboxes and not used the textboxes but just with date. Then it works. I think its the variable that screws it up. The date in the DB is date/time in format 2015-02-13.

Thanks

any chance of seeing dB?
ekspertenATsanthell.dk

AT = @

Qdf1.SQL = "SELECT tblKUNRES.* FROM tblKUNRES WHERE KRESFORFDAT BETWEEN #" & Format(varDateFrom, "YYYY-MM-DD") & "#  AND #" & Format(varDateTo, "YYYY-MM-DD") & "#"