debug issue

when i step into codes in vb

there is code called DoCmd.OpenQuery "Search"

how can i check whether the query is giving the right results?
jaisonshereenAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Your question was:

"how can i check whether the query is giving the right results?"

I explained how to do that ... and apparently there are no results.  You need to look at the data in the Table.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Go to the database window, and open the query directly ... and look at the results.

mx
0
 
jaisonshereenAuthor Commented:
what do u mean by database window?
is the object ....queries in the left pane?
when i went there i can see the query "Search"

but the icon is different than others different

0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
What type of query is 'search' ?

SELECT? or an Action query (Update, Append, etc) ?


mx
0
 
jaisonshereenAuthor Commented:
See this file and rounded in red
query.bmp
0
 
jaisonshereenAuthor Commented:
when i right click and take the design view i can see this:


search.JPG
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok ... it's an Append query.  

open in design view, then *temporarily* change it to a SELECT query - and run the query to see the results - which is what you would get  - if it actually does the Append.

mx
0
 
jaisonshereenAuthor Commented:
there was no row to append !

how can i know where this data comming from?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
From the table in the query - in design view.

mx
0
 
jaisonshereenAuthor Commented:
can u explain what does the search.jpg mean?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
no clue what you are referring to ... JPG ???

mx
0
 
jaisonshereenAuthor Commented:
ok from the second pic!!

Can u explain what the values represent ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.