RE: Query the brings only 0 value

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi g,

Sorry for the delay. Microsoft's discussion group message notification
is not working.

To answer you question, copy and paste the subroutine into a regular
(not class, form or report) module. When you want to (re)generate your
query, say from a button on a form, simply place it's name in the VBA code
for the button. So if your button's name is cmdRunTheQuery the code might
look something like this:

Private Sub cmdRunTheQuery_Click()

CreateLoadedColumnsWithZeroQuery
DoCmd.OpenQuery "qryLoaded Columns with Zero"

End Sub

Clifford Bass

"g" wrote:

Hi Everyone,

Thanks for giving some time to think the solution for my problem, It's very
much appreciated. I like to try what Clifford suggested but I need more
assistance as where to put this code & how will you get the result like I
wanted. Do I have to create a module to put in the code and call it some
where, something like that?

Thanks again,
.

Quantcast