Hi Guys,

I need so Code
There's the description

check out If Query "AbfrageNew" exists then delete it, if not then create a Query "AbfrageNew"

Thanks!
Zahn

There should be no need to delete and create.

You can modify the sql of a query...

currentdb.querydefs("AbfrageNew").Sql = " your sql here"

Hi Peter,

You mean with .SQL, the Query will rewrite?

Hi Peter,

I wrote something like this:

Dim sqlstr As String 'the String to save my SQL

CurrentDb.QueryDefs("AbfrageNew").sql = "sqlstr"

the error said following:

Invaild SQL statement: expected "Delete" "Selet" "Insert"...something like that.

What should I do?

Thanks
Zahn

Hi

You need to create the SQL of the query and set the string variable you've declared (sqlstr) to it, something like this



Change the SQL statement to your actual SQL

Hi Zahn,

If the query did not exist, how were you planning to create it? What is it for? What is it supposed to do?

Just my 2 cents...