troubleshooting Question

get result from 'docmd.runsql'

Avatar of redgoalsku
redgoalsku asked on
Microsoft Access
2 Comments1 Solution1052 ViewsLast Modified:
im using access 97 and i need to get the reult of a query that is to be run in vb.

ive tried the following but to no avail..

note: & [Mem No] &  = field in form

SQL = "SELECT Count([tblHire]![Mem No]) AS Expr1 " & _
"FROM tblHire " & _
"HAVING ((tblHire.[Mem No])='" & [Mem No] & "')"

If (DoCmd.RunSQL(SQL)) > 4 Then somethin

.thnx for your help

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros