Help Needed

[jaykishan82]

Dear Friend,
I created a Command Button, what i require is when i click on
that Command button
each time it run a temporary query and show me the output. Exa.Select *
from Tab;

I don't want to create any query.

Help me on this Topic.

Regards,
Jaykishan_82

 

[Smartin]

Dear Friend,
I created a Command Button, what i require is when i click on
that Command button
each time it run a temporary query and show me the output. Exa.Select *
from Tab;

I don't want to create any query.

Help me on this Topic.

Regards,
Jaykishan_82

In the button click event code try this:

Dim SQL As String
SQL = "SELECT * FROM TAB;"
With CurrentDb
.CreateQueryDef "TEMP", SQL
DoCmd.OpenQuery "TEMP", , acReadOnly
.QueryDefs.Delete "TEMP"
End With

This does create a query, but it is immediately deleted.