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?
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
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 MVP, Access and Data Platform)Commented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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
All Courses

From novice to tech pro — start learning today.