Message if no result

[Tempy]

Good day,

I am not a programer but have made quite a big access data base and want
to know if it is possible to have a pop up message if there are no
results for a query ?
Tempy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[David B]

Everything is possible in access ! (g)

Something like this would do what you want. cpp12q is the name of the
query. dob is a field in the query

Private Sub Command68_Click()
On Error GoTo Handler

If DCount("[dob]", "[cpp12q]") = 0 Then
MsgBox "There are no records to send"
Exit Sub
Else
Your code to run the query
end if
etc

HTH
David B
"Tempy" <an*******@devdex.com> wrote in message
news:42**********@127.0.0.1...

Good day,

I am not a programer but have made quite a big access data base and want
to know if it is possible to have a pop up message if there are no
results for a query ?
Tempy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[fredg]

On 5 Mar 2005 03:14:50 -0600, Tempy wrote:

Good day,

I am not a programer but have made quite a big access data base and want
to know if it is possible to have a pop up message if there are no
results for a query ?

Tempy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Not from within the query itself.
However, if you make the query a Form's Record Source, and use the
form to display the query results, you can code the Form's Open event:

Private Sub Form_Open(Cancel As Integer)
If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "No Records"
Cancel = True
End If
End Sub

If you wish the query, if it does have data, to look like the usual
query datasheet, simply set the form Default View to Datasheet view.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Tempy]

Thank you for your help, i will try and come back to you if i need help.

best regards,

Tempy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!