Create Query in VB

[agehoops]

I've generated the SQL string needed for the query, but how do I go about actually creating the new query? I've found various things on the net, namely the CreateQueryDef (I think) but couldn't get it to work. does anyone have the exact code or resource I need?

Thanks

 

[DJkarl]

I've generated the SQL string needed for the query, but how do I go about actually creating the new query? I've found various things on the net, namely the CreateQueryDef (I think) but couldn't get it to work. does anyone have the exact code or resource I need?

Thanks

Call CurrentDb.CreateQueryDef("QueryNameHere", "SQL STRING HERE")

 

[agehoops]

Hey, thanks. it seems to work but I don't see the Query in the Queries list or doesn't this create it there? If not then that's fine, but How do I get it to actually run the query as it isn't doing that? Thanks

 

[DJkarl]

Hey, thanks. it seems to work but I don't see the Query in the Queries list or doesn't this create it there? If not then that's fine, but How do I get it to actually run the query as it isn't doing that? Thanks

It does create it in the queries list, if you had the query list selected while you ran this code press <F5> to refresh the screen, it should show up.

 

[agehoops]

Yea just figured that one out now, thanks. Works a treat