Opening A query

[Valentine]

My code looks like this:

strDataTagSrch = Me.cboDataTags.Value
Set dbCurr = Currentdb()
Set qdfCurr = dbCurr.QueryDefs(QueryName)
sqlStr = "stuff and things "
DoCmd.OpenQuery (queryName)

My query opens but there is no information in the query. The SQL statement works I created a query using it an the info appeared.

 

[cheekybuddha]

' ...
Set qdfCurr = dbCurr.QueryDefs(QueryName)
qdfCurr.SQL = "stuff and things "
DoCmd.OpenQuery (queryName)
' ...

 

[theDBguy]

Why are you trying to open a query to display the data in it? I would imagine you simply want to use the information inside the query to perform additional process, like search for files. No?

 

[Valentine]

It is basically a search function for our users to use. I had it printing out as a report but the users would rather have a query so they can sort it and organize the information to research better. We have a field called "Data Tags" in each of our files with information and our users want to sort through all of our files that have a specific data tag.

 

[Valentine]

' ...
Set qdfCurr = dbCurr.QueryDefs(QueryName)
qdfCurr.SQL = "stuff and things "
DoCmd.OpenQuery (queryName)
' ...

I added in the qdfCurr.SQL = sqlStr
My query gets updated with the new SQL every time but i have no data populating the query. The query opens which is what i want but it doesn't have any information and there should be. I ran a normal query with the SQL string from here and info was populated. Is there something i have to do before the DoCmd.OpenQuery?

 

[cheekybuddha]

' ...
Set qdfCurr = dbCurr.QueryDefs(QueryName)
sqlStr = "stuff and things "
Debug.Print sqlStr
qdfCurr.SQL = sqlStr
DoCmd.OpenQuery (queryName)
' ...

Then paste the output from the Immediate Window (Ctrl+G) here.

 

[cheekybuddha]

You might also try:

' ...
Set qdfCurr = dbCurr.QueryDefs(QueryName)
sqlStr = "stuff and things "
Debug.Print sqlStr
qdfCurr.SQL = sqlStr
dbCurr.QueryDefs.Refresh
DoCmd.OpenQuery (queryName)
' ...

 

[Valentine]

Still no information and the print of my SQL was exactly what it needed to be.

 

[Valentine]

I REALLY hate little things causing problems.....I had a space in between my * and variable inside the SQL so it wasnt finding any info with that as its tag.....

 

[cheekybuddha]

That's why I suggested posting your SQL here - many eyes can help spot such things!

 

[Gasman]

That's why I suggested posting your SQL here - many eyes can help spot such things!

Yes, but it has to be within code tags to be obvious?
At least for me it does.

 

[cheekybuddha]

Well, considering the code requested never came I guess that point is moot!

 

[Pat Hartman]

NEVER, EVER open queries for the user to interact with. You have no control over what changes or deletions or additions they might make. Always use Forms (or reports) so that they can view the data and YOU can ensure that they don't modify any data incorrectly.

You can open forms in DS view that do not allow edits or deletions but the users can use the built in filtering options to filter the data if hthey want to.